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!
Hello, How can I exclude system schema and tables from the results of both queries in SQLPlus ? What can be added to the WHERE clause ? SELECT username FROM sys.dba_users; SELECT owner ||'.'|| table_name FROM sys.dba_tables; Thanks,