how to see all the tables in SQL*PLUS? - 未名空间MITBBS历史存档

how to see all the tables in SQL*PLUS?

how to see all the tables in SQL*PLUS?# Database - 数据库

h*h2000-07-07 07:07

1 楼

Hi, I just started to use SQL*PLUS for Oracle. Now I have a very naive
question: What command lists all the table names in the database?

B*n2000-07-07 07:07

2 楼

select * from tab;

【在 h***h 的大作中提到】

: Hi, I just started to use SQL*PLUS for Oracle. Now I have a very naive
: question: What command lists all the table names in the database?

A*h2000-07-07 07:07

3 楼

I am not sure, but try "list all" or "list *", it's been
some time i used it.

【在 h***h 的大作中提到】

: Hi, I just started to use SQL*PLUS for Oracle. Now I have a very naive
: question: What command lists all the table names in the database?

zh2000-07-07 07:07

4 楼

select object_name
from all_objects
where object_type='TABLE'

【在 A*****h 的大作中提到】

: I am not sure, but try "list all" or "list *", it's been
: some time i used it.

2024-01-28 18:01

2024-01-09 19:01

2024-01-07 18:01

2024-01-06 18:01

2024-01-06 18:01

2023-12-13 17:12

2023-12-02 07:12

2023-11-26 18:11