Home » SQL & PL/SQL » SQL & PL/SQL » Oracle useing Cross join (Oracle 9i)
Oracle useing Cross join [message #355045] Wed, 22 October 2008 06:38 Go to next message
raghava82
Messages: 1
Registered: October 2008
Location: hyd
Junior Member
Hi,
Friends here is the code which is working on SQL server/Mysql, this code can create table of 16 rows at a time, but I want to work in Oracle9i, if any body know please help.

I have already created table sample2 in sql server/ Mysql, with columns ename, sal then I have executed below code.

insert sample2
select ename,sal from ( select "vinay" as ename union
select "pradeep" union
select "raghava" union
select "raju") as part0 CROSS JOIN
( select 1000 as sal union select 800 union
select 600 union
select 500 ) as part1
Re: Oracle useing Cross join [message #355052 is a reply to message #355045] Wed, 22 October 2008 07:05 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Refer the links

Cartesian Join

Insert Into .. Select

Smile
Rajuvan.
Re: Oracle useing Cross join [message #355058 is a reply to message #355045] Wed, 22 October 2008 07:22 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A useful link: SQL Reference

Regards
Michel
Previous Topic: deadlock
Next Topic: Index with max function (merged 3)
Goto Forum:
  


Current Time: Sat Dec 03 01:35:20 CST 2016

Total time taken to generate the page: 0.08279 seconds