PLSQL Tutorial
https://www.dotnettricks.com/learn/sqlserver/difference-between-stored-procedure-and-function-in-sql-server http://index-of.co.uk/Database/Oracle%20Database/Oracle%20PL-SQL%20Programming,%206th%20Edition.pdf https://www.plsql.co/ 1. Khai báo biến tên_biến kiểu_dữ_liệu [default] [giá_trị_khởi_tạo] ví dụ: name varchar(20) default "Nguyen Huy Bo"; point number(10,2) default 22 ; giá trị lớn nhất là 9999999999,99 PI constant double default 3.14; DECLARE --global variable a integer := 10; b integer := 20; c integer; f real; BEGIN c := a + b; f := 70.0/3.0; DECLARE -- Local variables num1 number := 195; num2 number := 185; BEGIN -- code here END; END; / IF THEN END IF; IF (a <= 20) THEN --...