PL/SQL
文章平均质量分 79
Phoenix_99
这个作者很懒,什么都没留下…
展开
-
显示游标
1.简单变量接收数据declare cursor employees_cur is select first_name,last_name from employees; v_firstname employees.first_name%type; v_la原创 2011-09-11 09:55:15 · 364 阅读 · 0 评论 -
Exception
1,定义系统内自带错误编号declaree_insert_excep exception;pragma exception_init(e_insert_excep, -1400);begininsert into departments(department_原创 2011-09-14 22:23:13 · 281 阅读 · 0 评论 -
Exception
1.自定义异常说明declare e_insert_excep exception; pragma exception_init(e_insert_excep,-1400);begin insert into departments(department_原创 2011-10-18 19:06:37 · 365 阅读 · 0 评论 -
SQL再理解
--create table Student(S# varchar(10),Sname nvarchar(10),Sage datetime,Ssex nvarchar(10))--insert into Student values('01' , N'赵雷' , '1990-01-01' , N'男')--insert into Student values('02' , N'钱电' , '...原创 2019-03-08 09:31:24 · 206 阅读 · 0 评论