Could you plz write one sample procedure with one input parameter and one output parameter,that output parameter needs to return multiple values. FOR EXAMPLE: if we pass input parameter as employee designation(like developer) then it has to return all the employee id"s those who are working under that particular designation. plz make one more video with this concept,it will help all
In PL/SQL, there are different ways to create a procedure. The syntax you used earlier, starting with `PROCEDURE findmul(...) IS`, is one way. However, if you're creating the procedure separately, you can indeed use the `CREATE PROCEDURE` syntax. Here's an alternative version of your code using the `CREATE PROCEDURE` approach: ```plsql CREATE OR REPLACE PROCEDURE findmul( x IN NUMBER, y IN NUMBER, z OUT NUMBER ) AS BEGIN z := x * y; END findmul; / DECLARE a NUMBER; b NUMBER; c NUMBER; BEGIN a := 50; b := 10; findmul(a, b, c); DBMS_OUTPUT.PUT_LINE('Multiplication is ' || c); END; / ``` In this version, the `CREATE OR REPLACE PROCEDURE` statement is used to define the procedure separately from the anonymous PL/SQL block. The `DECLARE` section then declares variables and the `BEGIN` section contains the executable part of your code. The choice between creating the procedure within the anonymous block (`PROCEDURE findmul(...) IS ... BEGIN ... END;`) or separately (`CREATE PROCEDURE findmul(...) AS ...`) depends on your specific requirements and coding style preferences. Both approaches are valid in PL/SQL.
Wow, your tutorial is amazing, with simple presentation in a paper tou can make me understand how function and procedures in oracle. Thank you. Please make vid tutorial iseries n implementing this plnsql in orqcle apex, I'm sure your follower will grow more....cmiww
Inside the 1st begin and end block we can perform the operation for abc or not. If your answer is yes. Then why you have taken another begin /end block. If your answer is no. Why we can not perform .?