On Oct 10, 3:15 am, Serious_Developer <ehabaziz2...@gmail.com> wrote: > Hi,I am wondering in which schema that table belongs to ? Because I > writing SQL Statements and I do not know which login that I login to > start testing those statements ?
I can presume this is your personal database, of which you have access as SYS. The query is simple: select owner, table_name from dba_tables where table_name like '%SUPPLIER%'; which should provide all of the information you requested. David Fitzjarrell -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
