1.查询schema
select user_name from sys.dba_users;
2.查询schema下表
select * from dba_tables where owner = ‘schcemaName’ and table_name = ‘tableName’;
3.查询表结构
select * from user_tab_cols where TABLE_NAME = ‘tableName’;
oracle查询schema,schema下表以及表结构
最新推荐文章于 2023-12-25 17:54:00 发布