全是我自己做笔记,供大家一起分享和探讨.docVIP

全是我自己做的笔记，供大家一起分享和探讨： 第一课：客户端 1.Dos命令行下：sqlplus 用户名：scott 密码：tiger,sqlplus scott/tiger 2.开始－运行－sqlplus 图形版的SQLPLUS 3.http://localhost:5560/isqlplus Toad:管理 Plsql Developer 第二课：更改用户 1.sqlplus sys/bjsxt as sysdba 2.alter user scott account unlock;(解锁) 第三课：table_structures 1.desc 表名 2.select * from 表名 第四课：select语句 1.select ename, sal*12 annual_sal from emp; select ename sal*12 annual sal from emp;双引号可以保持原大小写，并且中间可以加空 格，不加全变为大写 2.desc dual，select 2*3 from dual，dual是系统自带的一张空表，计算数据时可以使用该表 3.任何含有空值的算术表达式的计算结果是空值 4.select ename||sal from emp; 5.select ename || abcdefg from emp; 6.select ename || abcdefg from emp;当字符串中含有单引号时，可用两个单引号代表一 个单引号 7.set linesize 200;--用于设定每行显示的宽度 8.set pagesize 30;--设置显示的页数 第五课：distinct 1.select distinct deptno from emp; 2.select distinct deptno,job from emp; 第六课：where 1.select * from emp where empno = 10; 2.select * from emp where empno 10; 3.select * from emp where ename = hebe; 4.select * from emp where sal (not) between 800 and 1500; 5.select * from emp where comm is (not) null; 6.select * from emp where ename (not) in (smith,philip,jay); 7.select * from emp where ename like _A%; 8.select * from emp where ename like _\%a%;系统默认转义符是\,可以自己指定转义符 select * from emp where ename like _$%a% escape $; 第七课：order by 1.select * from dept; 2.select * from dept order by dept desc;(默认为asc) 3.select ename, sal, deptno from emp where sal 2000 order by deptno asc,ename desc; 第八课：sql_function 1.select ename,sal*12 annual_sal from emp where ename not like _A% and sal 1500 order by sal desc; 2.select lower(ename) from emp; 3.select ename from emp where lower(ename) like _a%; 4.select substr(ename,2,3) from emp;从第二字符截，一共截三个字符。 5.select chr(65) from dual;结果为A 6.select ascii(a) from dual;结果为65 7.select round(35.572) from dual;结果为36 8.sele