Home » SQL & PL/SQL » SQL & PL/SQL » Recursive SQL Insert (Oracle 11g)
Recursive SQL Insert [message #659258] Tue, 10 January 2017 12:18 Go to next message
Danny Freeman
Messages: 13
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.
Re: Recursive SQL Insert [message #659259 is a reply to message #659258] Tue, 10 January 2017 12:23 Go to previous messageGo to next message
BlackSwan
Messages: 25793
Registered: January 2009
Location: SoCal
Senior Member
Recursive insert is just a figment of your imagination.

What is recursive insert?
Re: Recursive SQL Insert [message #659265 is a reply to message #659258] Tue, 10 January 2017 14:05 Go to previous message
Barbara Boehmer
Messages: 8789
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.
Previous Topic: dependency question
Next Topic: Compiling in Debug Mode
Goto Forum:
  


Current Time: Wed Jan 17 00:18:34 CST 2018

Total time taken to generate the page: 0.08603 seconds