Rem
Rem $Header: cdemodr2.sql 03-jun-97.15:41:15 azhao Exp $
Rem
Rem cdemodr2.sql
Rem
Rem  Copyright (c) Oracle Corporation 1997. All Rights Reserved.
Rem
Rem    NAME
Rem      cdemodr2.sql - create and populate test table TAB2.
Rem
Rem    DESCRIPTION
Rem      Demonstrate INSERT/UPDATE/DELETE statements RETURNING LOBS.
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    azhao       06/03/97 - Created
Rem

connect scott/tiger
drop table tab2;

create table tab2 (c1 integer, c2 blob, c3 clob);

Rem
Rem insert some rows for UPDATE later
Rem

insert into tab2 values(101, null, null);
insert into tab2 values(102, null, null);
insert into tab2 values(103, null, null);
insert into tab2 values(104, null, null);
insert into tab2 values(105, null, null);
insert into tab2 values(106, null, null);
insert into tab2 values(107, null, null);
insert into tab2 values(108, null, null);
insert into tab2 values(109, null, null);
insert into tab2 values(110, null, null);

Rem
Rem insert some rows for DELETE later
Rem

insert into tab2 values(201, '111', 'AAA');
insert into tab2 values(202, '111', 'BBB');
insert into tab2 values(203, '333', 'CCC');
insert into tab2 values(204, '444', 'DDD');
insert into tab2 values(205, '555', 'EEE');
insert into tab2 values(206, '666', 'FFF');
insert into tab2 values(207, '777', 'GGG');
insert into tab2 values(208, '888', 'HHH');
insert into tab2 values(209, '999', 'III');
insert into tab2 values(210, '000', 'JJJ');


commit;

quit

