Oracle PL/SQL基本语法练习

详细链接 http://blog.csdn.net/acmman/article/details/52422492
– 查询

select * from myemp;

– 通过as创建表

create table empvd20 as select * from emp041301;

– 创建数据源

create table EMP0413(EMPNO NUMBER,
                     ENAME VARCHAR2(10),
                     JOB VARCHAR2(9),
                     MGR NUMBER,
                     HIREDATE DATE,
                     SAL BINARY_DOUBLE,
                     COMM BINARY_DOUBLE,
                     DEPTNO NUMBER);

create table dept0413(DEPTNO NUMBER, DNAME VARCHAR2(50));

– 插入数据一种方法

INSERT INTO EMP041301
SELECT 1110, '张三', '主管', 1110, to_date('12-3-14', 'dd-MM-yy'), 5200, 0, 20 FROM dual 
UNION ALL
SELECT 1111, '李四', '销售', 1116, to_date('03 - 11 - 15', 'dd-MM-yy'), 3400, 500, 30 FROM dual
UNION ALL
SELECT 1112, '王五', '销售', 1116, to_date('25 - 4 - 12', 'dd-MM-yy'), 4400, 800, 30 FROM dual 
UNION ALL
SELECT 1113, '赵二', '后勤', 1110, to_date('30-5-11', 'dd-MM-yy'), 3450, 0, 40 FROM dual 
UNION ALL
SELECT 1114, '李磊磊', '会计', 1110, to_date('22-12-15', 'dd-MM-yy'), 2500, 0, 50 FROM dual 
UNION ALL
SELECT 1115, '张少丽', '销售', 1110, to_date('11-3-16', 'dd-MM-yy'), 2400, 1400, 30 FROM dual 
UNION ALL
SELECT 1116, '林建国', '主管', 1116, to_date('22-1-16', 'dd-MM-yy'), 5700, 0, 20 FROM dual 
UNION ALL
SELECT 1117, '马富邦', '后勤', 1116, to_date('22-7-13', 'dd-MM-yy&#