This content has been marked as final. Show 2 replies
Hi,1 person found this helpful
You are trying query view ( information_schema.tables ) from MSSQL on ORACLE??!!
select * from information_schema.tables where table_name = 'articles'
Each RDBMS have your own data dictionary... you must check documention of ORACLE to query the properly data dictionary.
select * from users_tables where table_name = 'articles' or select * from all_tables where table_name = 'articles' or select * from dba_tables where table_name = 'articles'
select * from all_tables where table_name = 'articles'
it worked fine
Edited by: 930694 on May 2, 2012 10:57 PM