Use following oracle sql tableDisplay the first name, last name and salary of all employees hired after “01-JAN-2006‟. Handle exceptions like Invalid cursor, cursor already open and no data found TablesColumnsTable:ΕMPLOYEESColumnData TypeLengthPrecisionScaleNullableEMPLOYEE_IDNUMBER226.NoFIRST_NAMEVARCHAR220YesLAST_NAMEVARCHAR225NoEMAILVARCHAR225NoPHONE_NUMBERVARCHAR220YesHIRE_DATEDATE7NoJOB_IDVARCHAR210NoSALARYNUMBER228YesCOMMISSION_PCTNUMBER22YesMANAGER_IDNUMBER22YesDEPARTMENT_IDNUMBER224YesBONUSVARCHAR2Yes1- 122.2.

Answered: Use following oracle sql table Display…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Use following oracle sql table

Display the first name, last name and salary of all employees hired after “01-JAN-2006‟. Handle exceptions like Invalid cursor, cursor already open and no data found

Tables
Columns
Table:
ΕMPLOYEES
Column
Data Type
Length
Precision
Scale
Nullable
EMPLOYEE_ID
NUMBER
22
6.
No
FIRST_NAME
VARCHAR2
20
Yes
LAST_NAME
VARCHAR2
25
No
EMAIL
VARCHAR2
25
No
PHONE_NUMBER
VARCHAR2
20
Yes
HIRE_DATE
DATE
7
No
JOB_ID
VARCHAR2
10
No
SALARY
NUMBER
22
8
Yes
COMMISSION_PCT
NUMBER
22
Yes
MANAGER_ID
NUMBER
22
Yes
DEPARTMENT_ID
NUMBER
22
4
Yes
BONUS
VARCHAR2
Yes
1- 12
2.
2.

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions