PLSQL: SELECT, %TYPE AND %ROWTYPE

Write a PL/SQL block to fetch employee name from EMP table for empno = 7369 and display it.

(SELECT INTO Statement)

Write a PL/SQL block to retrieve salary of an employee and print it.

(SELECT INTO Statement)

Write a PL/SQL block to fetch employee name and job using a single SELECT statement.

(SELECT INTO Statement)

Write a PL/SQL block to display department number of an employee using SELECT INTO.

(SELECT INTO Statement)

Write a PL/SQL block to fetch hiredate of an employee and display it.

(SELECT INTO Statement)

Write a PL/SQL block to count total number of employees using SELECT INTO.

(Aggregate Function + SELECT)

Write a PL/SQL block to declare a variable using %TYPE based on EMP.SAL and display salary.

(%TYPE)

Write a PL/SQL block to declare variables for employee name and job using %TYPE.

(%TYPE)

Write a PL/SQL block to fetch salary using %TYPE variable and display it.

(%TYPE + SELECT INTO)

Write a PL/SQL block to calculate annual salary using %TYPE variable.

(%TYPE + Calculation)

Write a PL/SQL block to update salary using %TYPE variable.

(%TYPE + UPDATE)

Write a PL/SQL block to declare a variable using %TYPE from DEPT table.

(%TYPE)

Write a PL/SQL block to declare a record using %ROWTYPE for EMP table.

(%ROWTYPE)

Write a PL/SQL block to fetch complete employee record using %ROWTYPE and display fields.

(%ROWTYPE + SELECT INTO)

Write a PL/SQL block to display employee name, salary, and job using %ROWTYPE.

(%ROWTYPE)

Write a PL/SQL block to update salary using %ROWTYPE variable.

(%ROWTYPE + UPDATE)

Write a PL/SQL block to insert a record using %ROWTYPE.

(%ROWTYPE + INSERT)

Write a PL/SQL block to fetch employee details based on empno using %ROWTYPE.

(%ROWTYPE + SELECT INTO)

Write a PL/SQL block using SELECT, %TYPE, and output statement together.

(Combined Concepts)

Write a PL/SQL block to fetch employee details using %ROWTYPE and display all columns.

(Combined Concepts)

Write a PL/SQL block to calculate bonus (10% of salary) using %TYPE.

(Combined Concepts)

Write a PL/SQL block to fetch employee record and update salary if less than 2000.

(SELECT + %ROWTYPE + IF)

Write a PL/SQL block to fetch highest salary using SELECT INTO and %TYPE.

(Aggregate + %TYPE)

Write a PL/SQL block to fetch employee with highest salary using %ROWTYPE.

(%ROWTYPE + SELECT)

Write a PL/SQL block to display employees working in a specific department using loop and %ROWTYPE.

(LOOP + %ROWTYPE)

Write a PL/SQL block to increase salary of employees department-wise using %TYPE.

(%TYPE + UPDATE)

Write a PL/SQL block to fetch and display all employee records using cursor and %ROWTYPE.

(Cursor + %ROWTYPE)

Write a PL/SQL block to copy data from EMP table to another table using %ROWTYPE.

(%ROWTYPE + INSERT)