Home » SQL & PL/SQL » SQL & PL/SQL » Need a little help in deriving the logic (Oracle 10.2.0.4)
Need a little help in deriving the logic [message #573573] Mon, 31 December 2012 06:27 Go to next message
tigsav
Messages: 38
Registered: April 2012
Member
Hi All,

I have a problem at hand.
I have many valid sql statements in a file.
when my procedure runs i want to pick them one by one and execute it but i dont know what they will return nor do i know the queries.

Hence i am thinking of using ref cursor but how do i know the return type ?
Basically the into record type is what i want.
Please help

Thanks and Regards,
tigsav
Re: Need a little help in deriving the logic [message #573576 is a reply to message #573573] Mon, 31 December 2012 06:42 Go to previous message
Michel Cadot
Messages: 58573
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
To know how to handle any SQL, have a look at T.Kyte's print_table function.

Regards
Michel
Previous Topic: How to convert a string into numeric other than to_number
Next Topic: REGEXP
Goto Forum:
  


Current Time: Fri Jul 25 23:04:45 CDT 2014

Total time taken to generate the page: 0.08527 seconds