** STORED PROCEDURE**

                                              ** STORED PROCEDURE**

1)sql stored procedure

CREATE OR REPLACE PROCEDURE raja1
AS
BEGIN
   dbms_output.put_line('Hello World!');
END;

BEGIN
raja1;
end;

create table gasc(name varchar(10),age int,phone int);
insert into gasc values(:name,:age,:phone);
update  gasc set name='alter' where age=18;
select * from gasc;

2)inset stored procedure

create or replace procedure raja2(name in varchar,age in int,phone in int)
AS
begin
insert into gasc values(name,age,phone);
end;

begin
raja2('papu',26,45664);
end;

3)update stored procedure
CREATE OR REPLACE PROCEDURE updateDBUSER(ages IN int)
as
BEGIN
UPDATE gasc SET name = 'altered' where age = ages;
end;

begin
updatedbuser(18);
end;

4)delete stored prpcedure

create or replace procedure raja4(ages in int)
as
begin
delete gasc where age=ages;
dbms_output.put_line('ststement deleted');
end;

begin
raja4(18);
end;

5)select stored prpcedure

CREATE OR REPLACE PROCEDURE geT(
       USERAGE IN GASC.AGE%TYPE,
       USERNAME OUT GASC.NAME%TYPE)
IS
BEGIN

  SELECT NAME
  INTO username
  from  GASC WHERE AGE = USERAGE;

END;

DECLARE
   username gasc.NAME%TYPE;
   userage gasc.age%TYPE;
BEGIN
   get(25,username);
 
   DBMS_OUTPUT.PUT_LINE('username :  ' ||username);
 
END;