Updating procedures in pl sql updating ms word

Posted by / 19-Oct-2020 09:10

' customers selected '); END IF; END; / Select * from customers; ---- ---------- ----- ----------- ---------- | ID | NAME | AGE | ADDRESS | SALARY | ---- ---------- ----- ----------- ---------- | 1 | Ramesh | 32 | Ahmedabad | 2500.00 | | 2 | Khilan | 25 | Delhi | 2000.00 | | 3 | kaushik | 23 | Kota | 2500.00 | | 4 | Chaitali | 25 | Mumbai | 7000.00 | | 5 | Hardik | 27 | Bhopal | 9000.00 | | 6 | Komal | 22 | MP | 5000.00 | ---- ---------- ----- ----------- ---------- Explicit cursors are programmer-defined cursors for gaining more control over the context area.An explicit cursor should be defined in the declaration section of the PL/SQL Block.Programmers cannot control the implicit cursors and the information in it.Whenever a DML statement (INSERT, UPDATE and DELETE) is issued, an implicit cursor is associated with this statement.

Syntax of PL/SQL Procedure: print area1 AREA1 --------- 500 Example 2 of PL/SQL Procedure The following statement creates the procedure remove_emp in the schema hr.It is created on a SELECT Statement which returns more than one row.The syntax for creating an explicit cursor is − DECLARE c_id customers.id%type; c_name customer S.The PL/SQL is shown in italics: CREATE PROCEDURE remove_emp (employee_id NUMBER) AS tot_emps NUMBER; BEGIN DELETE FROM employees WHERE employees.employee_id = remove_emp.employee_id; tot_emps := tot_emps - 1; END; / The remove_emp procedure removes a specified employee.When you call the procedure, you must specify the employee_id of the employee to be removed.

updating procedures in pl sql-81updating procedures in pl sql-18updating procedures in pl sql-50

One thought on “updating procedures in pl sql”