Venky DevMastery

 Procedure With Character Parameter enabled =========================== Create or Replace Procedure FLM_Names_Test1(P_name varchar2) IS n varchar2(50); f varchar2(50); l varchar2(50); m varchar2(50); BEGIN n:='&name'; f:=substr(n,1,instr(n,' ')-1); l:=substr(n,instr(n,' ',1,2)+1); m:=trim(ltrim(rtrim(n,l),f)); dbms_output.put_line('Entered Name is: '||n); dbms_output.put_line('================'); dbms_output.put_line('First Name is:- '||f); dbms_output.put_line('Last Name is:- '||l); dbms_output.put_line('Middle_Name is:- '||m); dbms_output.put_line('--------End of Procedure--------'); --EXCEPTION END; /

 Procedure to add two numbers with Parameter enabled ==================================================== CREATE  OR REPLACE PROCEDURE ADD_TEST1( p_a IN number, p_b IN number) IS a number(3); b number(3); c number(5); BEGIN a:=&a; b:=&b; c:=a+b; DBMS_OUTPUT.PUT_LINE('Total is: '||c);  --EXCEPTION END; / Procedure ADD_TEST1 compiled Exec ADD_TEST1(10,20); Total is: 30 PL/SQL procedure successfully completed.

  PLSQL-Course Contents 1. About PLSQL and features 2. Anonymous &Named Blocks 3. About Editors and IDE's 4. Data types in PLSQL 5. Declaring, Assigning variables. 6. DB programming with PLSQL 7. Conditional Statements(if then else, multi-if,nested if) 8. Reference types 9. Loops in PLSQL(while, for) 10.Cursor,ref cursor and dynamic cursor 12. Collections 13. Bulk Collect 14. collection methods 15. Rowtype array 16. User Defined records 17. Bulk Bind 18. VArray 19. Nested Table 20. pl/sql table vs varray vs nested table 21. Error/Exception handling 22. SQLcode, SQLerrm. 23. user defined errors using Raise statements 24. Pragma Exception_init ...