336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
To obtain the names of all of your tables, you can use the USER_TABLES.
DESCRIBE user_tables;
| Name | Null? | Type |
|---|---|---|
| TABLE_NAME | NOT NULL | VARCHAR2(30) |
| TABLESPACE_NAME | VARCHAR2(30) | |
| CLUSTER_NAME | VARCHAR2(30) | |
| IOT_NAME | VARCHAR2(30) | |
| STATUS | VARCHAR2(8) | |
| PCT_FREE | NUMBER | |
| PCT_USED | NUMBER |
SELECT table_name FROM user_tables;
| TABLE_NAME |
|---|
| DEPT |
| EMPLOYEES2 |
| REGIONS |
| LOCATIONS |
| DEPARTMENTS |
| JOBS |
| EMPLOYEES |
| JOB_HISTORY |
| JOB_GRADES |
| COUNTRIES |
- The TABS view is a synonym of the USER_TABLES view.
- Also try, ALL_TABLES
'Oracle' 카테고리의 다른 글
| Column Information (0) | 2006.11.27 |
|---|---|
| Column Information (0) | 2006.11.27 |
| Table Information (0) | 2006.11.27 |
| How to use the Dictionary Views (0) | 2006.11.27 |
| How to use the Dictionary Views (0) | 2006.11.27 |