Training mudinchipochu pa...!!! :-(

Hi,

Today is the final day for me in training.
All my trainings got over and I vil be into the proj very soon.
Lot more to study, but really its not that much exciting to work in
Oracle technologies(technicaly spkin) but apart from that, there are
lot of things to learn....!!!
Adha adutha episodela pappooom
vanga velaya papoom.....
:-)
~Break~

S/w giant vs Web Search Giant - Microsoft Battle with Gooogle

Do visit this link
The Google Vs Microsoft Battle

"NEW ARRIVALS" To Pondy

Hi,

Pondy is climbing like SENSEX index, so many improvements in all biz areas.
Almost all banks are opened their branches in pondy.
1.ICICI
2.HSBC
3.HDFC
4.CITIBANK (RECENTLY OPEND, IN BUSSY ST END)

Not only this, the culture of cosmopolitan city is also spreading in Pondy,
yeah,
1. Pizza Hut
2. Pizza Corner
3. MarryBrown
4. Cafe Day (may come soon)

Apart from this all chennai biz giants are lookin their eyes towards pondy
since this beautiful city has no taxes, like
1. Adayar Anandha Bhavan (in JN st)
2. Saravana Bhavan (near Antony church round turn)
3. Pothys and Chennai silks are likely going to come up !!!

Also this small city has 4 Engg colleges and 4 Medical colleges, this is too much !!

I m really wondering how business is going to grow in pondy???!!!

Pls add your business strategies / forethoughts to the Future Biz for Pondy..!!!

-Biz bee


I dint remember the most, only few da..!!
"www.Pondicherry.calm"
When u go back to Chennai, the caption is like
"Get back to Rush Hours"

vk- next time when v go in ecr, v vil c and i vil post it !!!

Multiple Records Insert - SQL query

This query also works in MS Access. Hope the same query runs in DB2 also.

insert into Email_TableR (EmpID,EmailID,Active) select T1.EmpID,T1.EmailID,T1.Active from Email_Table1 T1,Email_Table2 T2 where T1.EmpID = T2.EmpID;

Muruganandham Krishnan

From: Pavadaidurai A

Thanks vk....

From: Karthigeyan Velou (Tata Consultancy Services) [mailto:v-kvelou@microsoft.com]

Hi Durai,

Check this one

insert into tab1

select * from tab2

where exists

( select * from tab3

where tab2.student = tab3.student)

Regards,
vk

From: chandramouly.rathinasababathy@oracle.com

durai pls try out this !!!
insert all into table1(student)
select student from table2
intersect select student from table3;

end mouly

From: Pavadaidurai A [mailto:Pavadaidurai_A@infosys.com]



This is somewhat similar to multiple records insert...

I dont remember the syntax .....

can anybody help me out for this....

From: Pavadaidurai A

Friends,

Please help me out this is urgent....
I have three tables table1 ,table2 and table3
all these tables have a single column with same datatype and same name(say 'student')
i want to insert the all the rows which are common in table2 and table3 into table1......
please give me a query for this