Re: Select all tables from schema

From: Hermann Maier <benutzer_at_beispiel.at>
Date: Thu, 11 Mar 2004 13:33:03 GMT
Message-ID: <f3d22f4e0de82e040562331c65dd6121@news.teranews.com>

BloodHobbes schrieb:
> Hi,
>
> Could anyone help me out here? I want to select all records from all
> the tables of a certain scheme (oracle 9i). Is there anyway to do
> this?

How would one do that? UNION is not possible because of different structure of the tables.
If you want to generate sql queries (dynamic) over all tables you can "select table_name from user_tables" and then loop through this cursor.

Regards,

Hermann Received on Thu Mar 11 2004 - 07:33:03 CST