PL/SQL Learning

1. Print HelloWorld
DECLARE--Description section
BEGIN
Dbms_output.put_line (' Hello,world ');
END;

2. Reference variable, query and print 7835 of the name and salary
DECLARE--Define variables save name and salary
PName emp.ename% TYPE; Psal emp.sal% TYPE;
BEGIN
--Get the employee's name and salary
SELECT Ename,sal
Into Pname,psal
From EMP
WHERE
Empno = 7839;
Dbms_output.put_line (PName | | ' The salary is ' | | PSAL);
END;

3. Record-type variables

DECLARE emp_rec emp% RowType;
BEGIN
SELECT
* Into Emp_rec
From
Emp
WHERE
Empno = 7839; Dbms_output.put_line (
Emp_rec.ename | | ' The salary is ' | | Emp_rec.sal
) ;
END;

PL/SQL Learning