search

Home >Database >Mysql Tutorial >oracle查询表字段以及所有表

oracle查询表字段以及所有表

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 15:26:171256browse

select * from user_tables --查询当前用户下所有的表信息 select * from ALL_ALL_TABLES a where A.OWNER ='SPHB' --查询某个用户下所有的表 select * from ALL_TAB_COLUMNS a where A.OWNER ='SPHB' --查询某个用户下的所有表里面的字段 select * from all

select * from user_tables --查询当前用户下所有的表信息


select * from ALL_ALL_TABLES  a where A.OWNER ='SPHB'  --查询某个用户下所有的表


select *  from ALL_TAB_COLUMNS  a where A.OWNER ='SPHB'   --查询某个用户下的所有表里面的字段

 
select * from  all_VIEWS a where A.OWNER ='SPHB'   --查询某个用户下的所有的视图

 

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：在MAC 10.5.5 上 编译给 iPhoneOS2Next article：Oracle 中的Userenv（）

Related articles

See more