INFORMATION_SCHEMA.COLUMNS

Murali_Manohar_M

Dear All,

By querying the database with INFORMATION_SCHEMA.COLUMNS in Oracle webcenter sites support tool we are getting ORA-00942 error.

Can anyone assist on this?

Thanks in Advance,

Murali Manohar M

Stephan Da Silva-Oracle

INFORMATION_SCHEMA.COLUMNS is an MSSQL table. Since you're getting an ORA error I'm guessing you're using an Oracle database.

Try this query:

     SELECT * FROM all_tab_columns WHERE owner = '<your db user name in capitals>';

This page has some information about the table, and you can find some other useful tables there as well: ALL_TAB_COLUMNS

Kind regards,

Stephan.

Stephan Da Silva-Oracle

Hello Murali,

I don't think INFORMATION_SCHEMA.COLUMNS is usually a table or view in Oracle databases. ORA-00942 means the table doesn't exist. Is there any reason to believe that table/view exists?

Kind regards,

Stephan.

Murali_Manohar_M

Nope, Jus trying that!

Thanks

2702267

Information Schema columns is a function supported by sql to provide information on columns of  a given table. I dont think this will work inside WCS support tool. if you want to try this function execute this in SQL tool directly instead of WCS.

Stephan Da Silva-Oracle

INFORMATION_SCHEMA.COLUMNS is an MSSQL table. Since you're getting an ORA error I'm guessing you're using an Oracle database.

Try this query:

     SELECT * FROM all_tab_columns WHERE owner = '<your db user name in capitals>';

This page has some information about the table, and you can find some other useful tables there as well: ALL_TAB_COLUMNS

Kind regards,

Stephan.

Murali_Manohar_M

Thank You