
Oracle
厚者居上
这个作者很懒,什么都没留下…
展开
-
exists和in的区别
http://blog.itpub.net/31015730/viewspace-2147932转载 2018-05-09 16:34:55 · 7343 阅读 · 0 评论 -
Oracle基础知识
1.触发器create [or replace] trigger tri_name[before | after | instead of] tri_eventon table_name | view_name | user_name | db_name[for each row] [when tri_condition]beginplsql_sentences;end tri_name;实例:c...转载 2018-04-26 13:38:25 · 129 阅读 · 0 评论 -
sql语句练习
建表:/***学生表********************************************************/create student( //创建学生表sno varchar2(10) primary key,sname varchar2(2),sage number(2),ssex varchar2(5));insert into student values ('s...转载 2018-04-26 16:01:27 · 321 阅读 · 0 评论