oracle query table name and table column name

1. Query table name:

select table_name,tablespace_name,temporary from user_tables [where table_name=表名]

Among them: table_name: table name (varchar2 (30));
tablespace_name: table space to store the table name (varchar2 (30));
temporary: Whether it is a temporary table (varchar2 (1)).
eg: select table_name,tablespace_name,temporary from user_tables where table_name='TEST_TEMP';
Result:

------------------- -------------------------------------------------- ----------
table_name tablespace_name temporary
TEST_TEMP SDMP N

--------------------- -------------------------------------------------- ---------
Note: The table name variable value must be in uppercase letters.
2. Query table column name:

select column_name,data_type ,data_length,data_precision,data_scale from user_tab_columns [where table_name=表名];

Among them: column_name: column name (varchar2(30));
data_type: column data type (varchar2(106));
data_length :The length of the column (number);
eg:select column_name,data_type,data_length,data_precision,data_scale from user_tab_columns where table_name='TEST_TEMP';
Result:

------ -------------------------------------------------- -----------------------
column_name data_type data_length data_precision data_scale
ID NUMBER 22 0
NAME NVARCHAR2 20
SEX CHAR 1
GRADE NVARCHAR2 10

---------------------------------------- ------------------------------------------

Note: Table name variable values ​​must be in uppercase letters.
In addition, you can also obtain data from related tables through all_tab_columns.

eg:select * from all_tab_columns where table_name='TEST_TEMP';

For more Oracle query table names and table column names related articles, please pay attention to the PHP Chinese website!