Forum Stats

  • 3,826,921 Users
  • 2,260,725 Discussions
  • 7,897,122 Comments

Discussions

INFORMATION_SCHEMA.COLUMNS

Murali_Manohar_M
Murali_Manohar_M Member Posts: 36
edited Oct 25, 2016 7:51AM in WebCenter Sites

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

Murali_Manohar_M

Best Answer

  • Stephan Da Silva-Oracle
    Stephan Da Silva-Oracle Member Posts: 334
    Answer ✓

    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.

Answers

This discussion has been closed.