Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Equivalent term for SYSCAT.TABLES and SYSCAT.COLUMNS

630791Apr 11 2008 — edited Apr 14 2008

Hi

I have a DB2 view as below,

CREATE
VIEW DCLSUSER1.LIT_TAB_COL_MAP_VW AS
SELECT
ss.colname AS colname,
ss.tabname AS tabname ,
ss.typename AS typename
FROM
syscat.columns ss ,
syscat.tables tt
WHERE
ss.tabname = tt.tabname AND
tt.TYPE = 'T' AND
ss.tabschema = 'DCLSUSER1'

What is the corresponding term in Oracle for those
syscat.tables and syscat.columns?

PS. TYPE = 'T' means table, in Oracle, is that same?

Thanks,
J

Locked Post

New comments cannot be posted to this locked post.

Locked on May 12 2008

Added on Apr 11 2008

#database-and-application-migrations

5 comments

5,742 views