2 Replies Latest reply: May 3, 2012 12:57 AM by 933697 RSS

    what is the sql query to know the database name having known table name?

    933697
      when i am running the following query....error coming

      select * from information_schema.tables where table_name = 'articles'


      Error starting at line 1 in command:
      select * from information_schema.tables where table_name = 'articles'
      Error at Command Line:1 Column:33
      Error report:
      SQL Error: ORA-00942: table or view does not exist
      00942. 00000 - "table or view does not exist"
      *Cause:
      *Action:

      i am running the above query in SQLDeveloper tool against ORACLE database
      plz give alternate solution.