NOV 27 : Class 18: GMT20251127 130302 Recording 1920x1080 скачать в хорошем качестве

NOV 27 : Class 18: GMT20251127 130302 Recording 1920x1080

page no 99 : PL-SQL Procedure: Challenges with the SQL are 1.Sql cannot run multiple queries at same time 2.we cannot use the control statements as if,for and while 3.there is no expectation handling in sql 4.The query will run multiple times // swayam krushi athram aggaka Drawbacks with SQL: ================== 1.SQL cannot execute multiple queries at a time 2.SQL cannot support query reusability 3.SQL cannot supports control statements & loop statements like if,else,while,.... 4.SQL cannot supports exception handling Advantages with PL-SQL:(Procedural Language-SQL) ======================== 1.PL-SQL can execute multiple queries at a time with the help of procedures 2.PL-SQL can support query reusability with the help of procedures 3.PL-SQL can supports control statements like if,else,while,.... 4.PL-SQL supports exception handling ========================== Pre-requisites for PL-SQL: ========================== 1.SQL CRUD operations (insert,update,delete and select) 2.Functions in C Topics in PL-SQL: I.Procedures II.Functions III.Cursors IV.Triggers Procedures: ----------- A Procedure is a block of SQL statements used for performing CRUD operations. OR A Procedure is like a function used to prepare SET of SQL statements(Create/Insert/Update/Delete/Select). A Procedure is also called as "Stored Procedure". PL-SQL Procedure: ================= Syntax of Called Procedure: --------------------------- create [or replace] procedure ProcedureName(parameterlist) as begin --body of the procedure end; / Syntax of Calling Procedure: --------------------------------- execute ProcedureName(argumenmtslist); Note: To see the result of any procured, run "set serveroutput on;" command first time before you start executing your procedures. R1: Wants to show "Hello World" message using Anonymous Procedure. procedure: BEGIN dbms_output.put_line('Hello World'); END; / Hello World BEGIN dbms_output.put_line('Hello '); dbms_output.put_line('Chanti '); END; / Hello Chanti BEGIN dbms_output.put_line('Hello ' || ' Chanti'); END; / 2.Static Procedure 1.prepare: create procedure sayHi as BEGIN dbms_output.put_line('Hi Chanti'); END; / 2.run: EXECUTE sayHi;