OraFAQ Forum: SQL & PL/SQL » insert

Home » SQL & PL/SQL » SQL & PL/SQL » insert (10g windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

insert [message #307656]

Wed, 19 March 2008 06:32

oracle_coorgi
Messages: 188
Registered: September 2006
Location: INDIA-karnataka

Senior Member

hi
i have three table t1 ,m1 ,output_table
i want to insert the records for each all pk_id for everymonth the output should be like sample output_table
how do i insert by procedure through cursor

t1	m1	output_table	
pk_id	mon	fk_id	mon_name
101	jan	101	jan
102	feb	101	feb
103	mar	101	mar
104	apr	101	apr
105	may	101	may
106	jun	101	jun
107	jul	101	jul
108		102	jan
109		102	feb
110		102	mar
111		102	apr
		102	may
		102	jun
		102	jul

Report message to a moderator

Re: insert [message #307663 is a reply to message #307656]

Wed, 19 March 2008 06:52

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Check the documentation for INSERT INTO... SELECT and Cartesian Products

Report message to a moderator

Re: insert [message #307665 is a reply to message #307656]

Wed, 19 March 2008 06:52

Maaher
Messages: 7065
Registered: December 2001

Senior Member

It looks like you want a cartesian product. Select from both tables without a join condition.

MHE

Report message to a moderator

Re: insert [message #307666 is a reply to message #307656]

Wed, 19 March 2008 06:53

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This is called a cartesian product.

Regards
Michel

Report message to a moderator

Previous Topic:	ORA-01722
Next Topic:	Oracle UTL_FILE exception read_error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 09:33:16 CST 2025