查询数据库中的表
MYSQL > show TABLES
Oracle select table_name from all_tables
------------------------------------------------------------------------------
MYSQL > desc department
Oracle select column_name,data_type,nullable
from all_tab_columns
where owner = '用户名大写' and table_name='DEPARTMENT';
*表名要大写