pl/ sql DATABASE NAMED EMPLOYEES INCLUDES COLUMNS SUCH AS EMPID, EMPNAME, BDAY, AND DATEHIRED. WRITE A PL/SQL PROGRAM TO
Posted: Thu May 05, 2022 1:22 pm
pl/ sql
DATABASE NAMED EMPLOYEES INCLUDES COLUMNS SUCH AS EMPID,
EMPNAME, BDAY, AND DATEHIRED.
WRITE A PL/SQL PROGRAM TO EXTRACT ALL THE NAMES AND BIRTHDAYS,
AND DATEHIRED OF THE EMPLOYEES FROM THE DATABASE THROUGN AN
EXPLICIT CURSOR.
WRITE A FUNCTION IN PL/SQL THAT CALCULATES THE AGE OF A PERSON
GIVEN THE BIRTHDAY AND ANOTHER FUNCTION THAT CALCULATES THE DATE
WHEN THE EMPLOYEES WOULD RETIRE (NOTE THAT RETIREMENT DATE IS WHEN
THE EMPLOYEE HAVE ALREADY RENDERED 30 YEARS OF SERVICE IN THE
COMPANY).
DISPLAY ALL THE NAMES, THE AGE(IN YEAR) AND THE DATE OF
RETIREMENT OF THE EMPLOYEES(USE THE FUNCTIONS YOU HAVE CREATED
ABOVE.
DATABASE NAMED EMPLOYEES INCLUDES COLUMNS SUCH AS EMPID,
EMPNAME, BDAY, AND DATEHIRED.
WRITE A PL/SQL PROGRAM TO EXTRACT ALL THE NAMES AND BIRTHDAYS,
AND DATEHIRED OF THE EMPLOYEES FROM THE DATABASE THROUGN AN
EXPLICIT CURSOR.
WRITE A FUNCTION IN PL/SQL THAT CALCULATES THE AGE OF A PERSON
GIVEN THE BIRTHDAY AND ANOTHER FUNCTION THAT CALCULATES THE DATE
WHEN THE EMPLOYEES WOULD RETIRE (NOTE THAT RETIREMENT DATE IS WHEN
THE EMPLOYEE HAVE ALREADY RENDERED 30 YEARS OF SERVICE IN THE
COMPANY).
DISPLAY ALL THE NAMES, THE AGE(IN YEAR) AND THE DATE OF
RETIREMENT OF THE EMPLOYEES(USE THE FUNCTIONS YOU HAVE CREATED
ABOVE.