plsql 如何查询数据库中 所有以S开头的表

oracle 11g
2025-03-25 02:06:01
推荐回答(1个)
回答(1):

Normal User:
select table_name from user_tables where table_name like 'S%';
SysDBA User:
select table_name from dba_tables where table_name like 'S%';