|
|
PL/SQL Tutorial
Using record type in Pl/SQL Sample code
|
|
SQL> declare
2 type ccc is record(
3 region_id regions.region_id%type,
4 regionname regions.region_name%type,
5 v number);
6 ddd ccc;
7 begin
8 ddd.v:=4;
9 end;
10 /
|
Using SQL%notfoud in Pl/SQL
Sample code
declare
2 begin
3 insert into regions values(9,'vvvv');
4 if sql%notfound then
5 dbms_output.put_line('nothing is done');
6 else
7 dbms_output.put_line('nothing is done');
8 end if;
9 commit;
10 end;
Go To
Index
|
|
|
