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
Messages: 1
Registered: October 2008
Location: hyd
Junior Member
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
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Refer the links

Cartesian Join

Insert Into .. Select

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: 63945
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A useful link: SQL Reference

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

Current Time: Fri Oct 28 04:21:47 CDT 2016

Total time taken to generate the page: 0.06290 seconds