I want get all tablelist.

Mr.Ajo · Post by **Mr.Ajo** » Wed 17 Aug 2005 08:26

Hi.

I want get all tablelist.

plase...

Paul · Post by **Paul** » Wed 17 Aug 2005 08:44

OraDirect .NET have no such functionality. Please use standard Oracle views.

Mr.Ajo · Post by **Mr.Ajo** » Wed 17 Aug 2005 09:44

I want list of TableNames in DB.

Ex) adoConnection Component...
adoConnection.GetTableNames( lstTable, False);

I have ODAC 4.5.0.17.

Paul · Post by **Paul** » Thu 18 Aug 2005 05:54

We fixed this in ODAC 5.50. You can use TOraSession.GetTableNames function in ODAC 5.50. ODAC 4.50.0.17 have no such functionality. Please use the following query

Code: Select all

      SELECT User || '.' || Object_Name Name 
      FROM User_Objects 
      WHERE Object_Type in ('TABLE', 'VIEW') 
      ORDER BY Object_Name;

Or use the next one for receiving all tables

Code: Select all

      SELECT Owner || '.' || Object_Name Name 
      FROM All_Objects 
      WHERE Object_Type in ('TABLE', 'VIEW') 
      ORDER BY Object_Name