常用命令与sql

获取表结构

desc table_name

SELECT *
FROM ALL_TAB_COLUMNS
where owner= 'user' and table_name   = 'table_name';