新建 文本文档.txt

来自「关于oracle和sql的书籍和ppt教程,非常好,本人珍藏品」· 文本 代码 · 共 44 行

/*create table cpx_table(c_id number(15),c_name varchar2(21) default 'andy',
c_sex char(4) ,c_date date default sysdate not null);
*/

/*
insert into cpx_table values(001,'111','na',to_date('1983-10-20','yyyy-mm-dd'));
insert into cpx_table values(002,'222','nv',to_date('1982-10-2','yyyy-mm-dd'));
insert into cpx_table values(003,'333','na',to_date('1983-12-30','yyyy-mm-dd'));
insert into cpx_table values(004,'444','nv',to_date('1980-10-20','yyyy-mm-dd'));
*/

/*
create table cpx_table1 (c_id int,c_name varchar2(21) default 'andy',
c_sex char(4) ,c_date date default sysdate not null);*/



/*insert into cpx_table1(c_sex) values('na');*/

/*create or replace trigger cpx_trigger
before insert 
     
on cpx_table
for each row

declare
   aa int;
begin
    case 
      when inserting then 
       select max (c_id) into aa from cpx_table;
       update cpx_table set c_id=(aa+1) ;
    end case;
end;*/

/*
insert into cpx_table (c_name,c_sex,c_date)  select c_name,c_sex,c_date  from cpx_table1;*/


/*
insert into cpx_table (c_name,c_sex) values ('jj','na');*/