Home » SQL & PL/SQL » SQL & PL/SQL » how to retriev the data
how to retriev the data [message #20373] Sun, 19 May 2002 06:16 Go to next message
bhavana
Messages: 3
Registered: May 2002
Junior Member
How to retriev the data from all the tables in one database.

Report message to a moderator

Re: how to retriev the data [message #20396 is a reply to message #20373] Mon, 20 May 2002 16:42 Go to previous messageGo to next message
Su
Messages: 154
Registered: April 2002
Senior Member
It may not be possible in a single SQL, I guess. You have to write a PL/SQL routine to a) retrieve all the tables one by one from database, possibly using a cursor b) fetch each table name and c) EXECUTE IMMEDIATEly a SELECT statement with fetched table name. Right now nothing better than this strikes in my mind, but there could be better one. (let me) Check it out.

Good luck :)

Report message to a moderator

Re: how to retriev the data [message #20497 is a reply to message #20373] Thu, 30 May 2002 01:18 Go to previous message
shyampaliyath
Messages: 22
Registered: May 2002
Junior Member
hai
u can do one thing spool the resultant data to file and store it as sql file and run the sql file from the command prompt.

select 'SELECT * FROM '+tname from tab

Report message to a moderator

Previous Topic: decode function condition
Next Topic: gui application
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 13:04:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.