17,086
社区成员
发帖
与我相关
我的任务
分享
set linesize 100
set pagesize 40
select *
from ALL_TABLES where OWNER ='OAS' or OWNER ='OASPRD'
Order by tablespace_name,table_name
set pagesize 40
set linesize 100
select * from all_tables
where owner in('OAS','OASPRD') --in里面的owner要大写
order by TABLESPACE_NAME,TABLE_NAME
set linesize 100
set pagesize 40
select * from all_tables -- 其中*號可以換成你想要的信息的字段名
where owner in ( 'OAS' , 'OASPRD')
order by tablespace_name, table_name;