PLSQL: OUTPUT STATEMENT, DATATYPES, VARIABLES, CONSTANTS
22 programming challenges to help you master the fundamentals of DATABASE MANAGEMENT SYSTEM USING ORACLE.
Write a PL/SQL block to print your name and city in two separate lines.
(Output Statement)
Write a PL/SQL block to display numbers from 1 to 5 using DBMS_OUTPUT.PUT_LINE.
(Output Statement)
Write a PL/SQL block to display employee name and salary (use variables).
(Output + Variables)
Write a PL/SQL block to declare a variable and assign your age, then display it.
(Variables)
Write a PL/SQL block to store employee name and salary in variables and display them.
(Variables)
Write a PL/SQL block to declare a constant value for PI and calculate area of a circle.
(Constants)
Write a PL/SQL block to declare a constant tax rate and calculate total salary after tax.
(Constants)
Write a PL/SQL block where constant value cannot be changed (try modifying and observe error).
(Constants)
Write a PL/SQL block to calculate simple interest using constant rate of interest.
(Constants)
Write a PL/SQL block to declare a variable using %TYPE from EMP table salary column.
(Datatypes)
Write a PL/SQL block to declare a record using %ROWTYPE and display employee details.
(Datatypes)
Write a PL/SQL block to store and display current date using DATE datatype.
(Datatypes)
Write a PL/SQL block to convert number to string and display it.
(Datatypes + Conversion)
Write a PL/SQL block using variables, constants, and output statement together.
(Combined Concepts)
Write a PL/SQL block to display employee details using %ROWTYPE, constants, and comments.
(Combined Concepts)
Write a PL/SQL block to calculate bonus (10% of salary) and display result using proper comments.
(Variables + Output + Comments)
Write a PL/SQL block that uses all concepts: variable, constant, datatype, and output.
(Full Practice)