Re: Select all tables from schema

"BloodHobbes" <gandalfenhobbes_at_yahoo.com> wrote in message news:ceafa83c.0403180613.6527749f_at_posting.google.com...
| Hi thankx for all those replies!!!
|
| But i want to export this data programmatically. How do i make a sql
| which will fill a cursor with all the data i need?
|
| thanks a lot for reading and responding!!

still not very clear.... what output format? what are you doing with the data? where/what are you loading it into? how many tables? how much data?

i believe MS-SS allows one stored procedure to return multiple (sequential) resultsets from multiple cursors -- that's not what you're expecting, is it? you won't get 'a cursor' to return all the data from a schema in oracle

;-{ mcs Received on Thu Mar 18 2004 - 17:10:08 CST