GetTableNames

[brian]

Hi,
If I use TSession.GetTableNames, I will get a string list with the names of tables associated with a specify database.

What is the similar function if I use TOracleSession???

Thanks.

 

[jpickup]

Try:
SELECT object_name FROM user_objects
WHERE object_type = 'TABLE';

or

SELECT object_name FROM all_objects
WHERE object_type = 'TABLE';

The first returns all tables in the currently logged in user's schema, the second for all schemas.

 

[brian]

thanks.