Coding Atharva: Procedure

Showing posts with label Procedure. Show all posts

Procedure with parameter to add two numbers

BY DEFAULT IN ***************************** CREATE OR REPLACE PROCEDURE ADDF(N1 NUMBER,N2 NUMBER) IS N3 NUMBER; -- ADD TWO NUMBER BE...

************************************ Procedure for hello CREATE OR REPLACE PROCEDURE HELLO IS BEGIN DBMS_OUTPUT.PUT_LINE('HELL...

****************************** Using SQL command Promt: Execute PROCEDURE_NAME [(Parameters)]; EXEC PROCEDURE_NAME [(Parameters)]; ...

********************************************** Display all employees information CREATE OR REPLACE PROCEDURE EMP_INFO IS CURSOR C1 IS ...