Base dato

Clasified in Notes of Philosophy of University.

Written at July 15, 2009 on enEnglish with a size of 925 bytes.

drop table f;

create table f (a number (10),b varchar(60));

insert into f values(5, 'cinco');

insert into f values(6, 'seis');

insert into f values(7, 'siete');

insert into f values(8, 'ocho');

insert into f values(9, 'nueve');

create or replace procedure eje1 as begin update f set a = power(a, 2) where length(B) = 5;

end eje1;

begin eje1;

end;

select * from f

Tags:xd
This document has been visited 9 times and has received 1 votes
© Wikiteka, 2010
Chuletas  |  Apuntes