OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » pl/sql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

pl/sql [message #2330]

Sun, 07 July 2002 22:41

SHARMA POLPE
Messages: 5
Registered: July 2002

Junior Member

hi anyone please

i want to create pl/sql proc for which
a table will update by giving value.,

exmp. taking empno updating the emp table

Report message to a moderator

Re: pl/sql [message #2336 is a reply to message #2330]

Mon, 08 July 2002 07:31

K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore

Senior Member

SIR,

CREATE OR REPLACE PROCEDURE PROEXAMPLE(pGIVENVALUE VARCHAR2)
IS
BEGIN
UPDATE EMP SET SALARY=SALARY+100 WHERE EMPNO=pGIVENVALUE;
END PROEXAMPLE;
/

K.SREENIVASAN

Report message to a moderator

Previous Topic:	how to add the single quotation mark ' to the variable of varchar2 type
Next Topic:	Take a row in a table and move it to another table - Need help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 14:40:52 CDT 2024