Devart Forums

Posted: **Wed 17 Aug 2005 08:26**

Hi.

I want get all tablelist.

plase...

Posted: **Wed 17 Aug 2005 08:44**

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

Posted: **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.

Posted: **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