Wednesday, 29 August 2012

Find out the missing table in all schema's query

select * from all_tables where table_name like '%XYZ%';

select * from recyclebin where original_name like '%XYZ%';

1 comment:

  1. If you want to get basic idea on Oracle SQL and PL/SQL you can visit the following blog

    www.javanib.blogspot.com

    nice blog.

    ReplyDelete