https://blog.youkuaiyun.com/qiyangshenzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/qiyangshen/article/details/78897502https://blog.youkuaiyun.com/qiyangshen/article/details/78897502qiyangshenMon, 25 Dec 2017 22:10:06 +0800https://blog.youkuaiyun.com/qiyangshen/article/details/47147095https://blog.youkuaiyun.com/qiyangshen/article/details/47147095qiyangshenThu, 30 Jul 2015 11:12:29 +0800https://blog.youkuaiyun.com/qiyangshen/article/details/47147035https://blog.youkuaiyun.com/qiyangshen/article/details/47147035qiyangshenThu, 30 Jul 2015 11:11:38 +0800exp userid=ststem/oracl full=yinctype=complete file=c:\sjk.dmp; （ inctype=complete 增量备]]>https://blog.youkuaiyun.com/qiyangshen/article/details/47147065https://blog.youkuaiyun.com/qiyangshen/article/details/47147065qiyangshenThu, 30 Jul 2015 11:11:25 +0800https://blog.youkuaiyun.com/qiyangshen/article/details/47147027https://blog.youkuaiyun.com/qiyangshen/article/details/47147027qiyangshenThu, 30 Jul 2015 11:11:03 +0800https://blog.youkuaiyun.com/qiyangshen/article/details/47147053https://blog.youkuaiyun.com/qiyangshen/article/details/47147053qiyangshenThu, 30 Jul 2015 11:10:57 +0800https://blog.youkuaiyun.com/qiyangshen/article/details/47147013https://blog.youkuaiyun.com/qiyangshen/article/details/47147013qiyangshenThu, 30 Jul 2015 11:10:09 +0800https://blog.youkuaiyun.com/qiyangshen/article/details/47146989https://blog.youkuaiyun.com/qiyangshen/article/details/47146989qiyangshenThu, 30 Jul 2015 11:09:29 +0800 select sysdate from dual; SYSDATE -------------- 16-5月 -12 （2）add_months（d，n） （3）last_day(d):返回指定日期所在月份的最后一天 ]]>https://blog.youkuaiyun.com/qiyangshen/article/details/47146977https://blog.youkuaiyun.com/qiyangshen/article/details/47146977qiyangshenThu, 30 Jul 2015 11:08:57 +0800 select lower(ename),sal from ]]>https://blog.youkuaiyun.com/qiyangshen/article/details/47146965https://blog.youkuaiyun.com/qiyangshen/article/details/47146965qiyangshenThu, 30 Jul 2015 11:08:27 +0800https://blog.youkuaiyun.com/qiyangshen/article/details/47146945https://blog.youkuaiyun.com/qiyangshen/article/details/47146945qiyangshenThu, 30 Jul 2015 11:07:58 +0800 select a2.ename,a2.sal,a2.deptno,a1.mysal from emp a2,(selectde]]>https://blog.youkuaiyun.com/qiyangshen/article/details/47146927https://blog.youkuaiyun.com/qiyangshen/article/details/47146927qiyangshenThu, 30 Jul 2015 11:07:16 +0800 select * from dept;     DEPTNO DNAME          LOC --------]]>https://blog.youkuaiyun.com/qiyangshen/article/details/47146909https://blog.youkuaiyun.com/qiyangshen/article/details/47146909qiyangshenThu, 30 Jul 2015 11:05:15 +0800select * from emp where (sal>500 or job='MANAGER') and ename like'J%'; 2.使用order by字句 示例： 如何按照工资 的从低到高的顺序显示雇员的信息 select * from]]>https://blog.youkuaiyun.com/qiyangshen/article/details/47131483https://blog.youkuaiyun.com/qiyangshen/article/details/47131483qiyangshenWed, 29 Jul 2015 17:45:37 +0800desc dept; 查看所有列 select * from dept； 查询指定列 select ename，sal，job from emp；   查询emp表中的sal、job列 如何取消重复行 select distinct deptno,job from emp; set timing on； 打开显示操作时间的开关（就是每次查询所用]]>https://blog.youkuaiyun.com/qiyangshen/article/details/47131435https://blog.youkuaiyun.com/qiyangshen/article/details/47131435qiyangshenWed, 29 Jul 2015 17:44:29 +0800create table student (   --表名（student）          xh number(4),    --学号          xm varchar2（20），  --姓名          sex char（2），--性别          birthday date ---出生年月          ）； 添加一个字段 SQL>a]]>https://blog.youkuaiyun.com/qiyangshen/article/details/47131399https://blog.youkuaiyun.com/qiyangshen/article/details/47131399qiyangshenWed, 29 Jul 2015 17:41:46 +0800https://blog.youkuaiyun.com/qiyangshen/article/details/47130727https://blog.youkuaiyun.com/qiyangshen/article/details/47130727qiyangshenWed, 29 Jul 2015 17:09:17 +0800 create user sqy identified by sqy; 用户已创建。 2.删除用户 drop user 用户名[cascade];删除用户时，如果已经创建表，那么就需要一个参数，cascade把表也删了 示例： SQL> drop user sqy cascade;]]>https://blog.youkuaiyun.com/qiyangshen/article/details/47130453https://blog.youkuaiyun.com/qiyangshen/article/details/47130453qiyangshenWed, 29 Jul 2015 16:59:20 +0800https://blog.youkuaiyun.com/qiyangshen/article/details/47130285https://blog.youkuaiyun.com/qiyangshen/article/details/47130285qiyangshenWed, 29 Jul 2015 16:49:25 +0800 conn sys/oracl as sysdba; 已连接。 SQL> 2.disc[onnect]断开与当前数据库连接 示例： SQL> disc 从 Oracle Database]]>https://blog.youkuaiyun.com/qiyangshen/article/details/84413809https://blog.youkuaiyun.com/qiyangshen/article/details/84413809qiyangshenFri, 29 Mar 2013 20:01:35 +0800