飞鸟的轨迹

1. 创建用户启动sqlplussqlplus /nolog以sys用户登录为例conn sys/change_on_install as sysdba;如果原来有这个用户，执行删除（skt）//查看所有用户select username from dba_users;//删除用户drop user skt cascade;说明： 删除了u...

常用sql汇总1. 查询表结构，导出到Excel表原文传送门：http://blog.youkuaiyun.com/u011544778/article/details/50907157SELECT B.TABLE_NAME AS "表名", C.COMMENTS AS "表说明", B.COLUMN_ID AS "字段序号", B.COLU...