OraFAQ Forum: SQL & PL/SQL » Recursive SQL Insert

Home » SQL & PL/SQL » SQL & PL/SQL » Recursive SQL Insert (Oracle 11g)

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

Recursive SQL Insert [message #659258]

Tue, 10 January 2017 12:18

Danny Freeman
Messages: 21
Registered: December 2015
Location: UK

Junior Member

Hello People,

Can anybody please explain me recursive insert in SQL? I googled about it but found nothing. I mean I want to know that is it possible for us to use recursive SQL insert.

Report message to a moderator

Re: Recursive SQL Insert [message #659259 is a reply to message #659258]

Tue, 10 January 2017 12:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Recursive insert is just a figment of your imagination.

What is recursive insert?

Report message to a moderator

Re: Recursive SQL Insert [message #659265 is a reply to message #659258]

Tue, 10 January 2017 14:05

Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA

Senior Member

Where did you get the phrase "recursive insert" or "recursive SQL insert" from? You can insert data from a recursive query if that is what you mean. Oracle has hierarchical queries using START WITH and CONNECT BY PRIOR and such. Oracle also has hierarchical queries that use recursive sub-query factoring. You can also write recursive functions and procedures. Any of these could be used to insert data.

Report message to a moderator

Previous Topic:	dependency question
Next Topic:	Compiling in Debug Mode

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 07 13:00:10 CDT 2026