how could i get the Oracle schema information using the OracleClient class?

Question

helloeverybodyhow could i get the orachle shemacle information such as all the instance nameall the table name and so on. i'm working under the vs.net 2003and using the using System.Data.OracleClient Class. waiting for your helpthanks

aeroswan · Answer

it works thank you very much. and i find another wayusing the MS' System.Data.OracleClient method. first i wrote some packages in the Oracle dband get the return value which is Cursor type.then you can get the schema information via the cursor. in the same wayi get the schema information of a specific table. if any shortcomings existed it is too complicated haha. but it works fastas the stored procedure has compiled before the app runs.

Andrzej Wegierski · Answer

See here . Oracle Client has same methods I think