https://youtu.be/O7kq9kL36t4
May 20
Oracle Trigger
Click on the images to see them clearly
Example:
Ref: https://docs.oracle.com/cd/B13789_01/server.101/b10759/statements_7004.htm
May 20
Oracle Functions
Click on Image to see them clearly
Example:
CREATE FUNCTION get_bal(acc_no IN NUMBER)
RETURN NUMBER
IS acc_bal NUMBER(11,2);
BEGIN
SELECT order_total
INTO acc_bal
FROM orders
WHERE customer_id = acc_no;
RETURN(acc_bal);
END;
/
Ref: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/lnpls/CREATE-FUNCTION-statement.html
