摘要: package com.ctian; import java.util.Scanner; public class Picture { public static void print_blank(int vblank)//空格 { for(int i=0;i<=vblank;i++) System.out.print(" "); } public static voi... 阅读全文
posted @ 2017-08-08 18:49 kiskistian 阅读(102) 评论(0) 推荐(0) 编辑
摘要: package com.conatructor; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.ObjectInputStream; import j... 阅读全文
posted @ 2017-08-08 09:00 kiskistian 阅读(231) 评论(0) 推荐(0) 编辑
摘要: --after和before CREATE OR REPLACE TRIGGER del_emp1 BEFORE update OR insert OR delete ON scott.emp REFERENCING new AS nn old AS oo FOR EACH ROW WHEN (nn.sal >... 阅读全文
posted @ 2017-08-01 14:55 kiskistian 阅读(526) 评论(0) 推荐(0) 编辑
摘要: insert into bonus values('周末','cooker',4000,1000); insert into bonus values('周一','cooker',4000,1000); insert into bonus values('周二','cooker',4000,1000); insert into bonus values('周三','cooker',4000,10... 阅读全文
posted @ 2017-07-18 10:53 kiskistian 阅读(167) 评论(0) 推荐(0) 编辑
摘要: select * from EMP where ENAME ='SMITH'; select ename || ' is a ' || job from emp; select distinct empno from emp; select * from emp where COMM>SAL; select COMM+SAL from emp; select * from emp where j... 阅读全文
posted @ 2017-07-17 12:10 kiskistian 阅读(140) 评论(0) 推荐(0) 编辑