Updating procedures in pl sql Zwifex video com

Posted by / 02-Sep-2020 12:33

Updating procedures in pl sql

The following table provides the description of the most used attributes − Select * from customers; ---- ---------- ----- ----------- ---------- | ID | NAME | AGE | ADDRESS | SALARY | ---- ---------- ----- ----------- ---------- | 1 | Ramesh | 32 | Ahmedabad | 2000.00 | | 2 | Khilan | 25 | Delhi | 1500.00 | | 3 | kaushik | 23 | Kota | 2000.00 | | 4 | Chaitali | 25 | Mumbai | 6500.00 | | 5 | Hardik | 27 | Bhopal | 8500.00 | | 6 | Komal | 22 | MP | 4500.00 | ---- ---------- ----- ----------- ---------- DECLARE total_rows number(2); BEGIN UPDATE customers SET salary = salary 500; IF sql%notfound THEN dbms_output.put_line('no customers selected'); ELSIF sql%found THEN total_rows := sql%rowcount; dbms_output.put_line( total_rows

Procedures carry out action(s); functions return a value.

In this chapter, we will discuss Triggers in PL/SQL.

Triggers are stored programs, which are automatically executed or fired when some events occur.

We’ve already talked about bundling up statements in anonymous PL/SQL blocks; now it’s time to bring out the big dogs of rerunnable code – procedures and functions.

(* which is strange – most programmers, in my experience, are crazier than a fly trapped in a bottle!

updating procedures in pl sql-88updating procedures in pl sql-12updating procedures in pl sql-33

If that is the case then no one’s saner than a computer programmer*, because programming is executing the same code over and over again and expecting the same results.