Elton's Blog

Tag: table_name

Oracle数据库列出所有表

by on 一.10, 2010, under Database

可以使用下面的命令来列出当前用户所有的表

1
2

select * from tab;
select table_name from user_tables;

如果想列出所有的表，可以使用

1

select table_name from all_tables;
Leave a Comment :, more...

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!

Visit my friends!

A few highly recommended friends...

Archives

All entries, chronologically...