oracle 数据库常见sql语句

drop user usernamecascade;  删除用户

drop tablespace tablespacename including contents and datafiles cascade constraint; 删除表空间

查询所有字段类型

SELECT *
FROM all_tab_cols
WHERE table_name = UPPER('UP_ORG_UNIT') and COLUMN_name='NAME' ;