Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Required: Use the Employees table (copy and paste the code in SQL command line) Based on the given table: Employees table as shown below, write

Required: Use the Employees table (copy and paste the code in SQL command line) Based on the given table: Employees table as shown below, write the PL/SQL that applies single row function in order to get the printed output per number. Copy and paste the PL/SQL code on the space provided after each questions.

image text in transcribed

image text in transcribed

image text in transcribed

i put already the structure and can somebody help me...thank you!

Direction: Use the Employees table (copy and paste the code in SQL command line) Based on the given table: Employees table as shown below, write the PL/SQL that applies single row function in order to get the printed output per number. Write your answer in a short bond paper. Copy and paste the PL/SQL code on the space provided after each questions. EMPLOYEE ID FIRSTNAME LASTNAME JOB ID SALARY MANAGER ID DEPARTMENT ID AD PRES 90 100 STEVEN KING 101 NENA 102 LEX 103 ALEXANDER HUMOLD ItPROG 104 BRUCE ERNST IT PROG 107 DIANA LORENT IT PROG 124 REV?H HOURGOS ST MAN 141 TR?RA RAJ3 42 CURIIS DAVIES SI CLER 143 RANDALL HATOS ST CLERR 44 PETER VARGAS ST CUERR 24000 17000 17000 100 100 101 102 103 100 ROCHARAD VE DE HAAN AD VP 90 60 60 60 50 50 50 50 50 - 6000 4200 5800 3500 3100 2600 2500 10500 11000 9 600 1006 1400 9000 T CLERR 124 124 124 160 14 ELLENABELSh REP 176 JONATHAN TAYLOR B RE 90 201 HICHAEL 03 PA HART?18 HE HAS MHREF 106 a0i 2000 108 King,Steven lunold, Alexanden rnst, Bruce Lorentz Diana

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Process Driven Database Design With Oracle PL SQL

Authors: Rajeev Kaula

1st Edition

1795532386, 978-1795532389

More Books

Students also viewed these Databases questions

Question

3. The group answers the questions.

Answered: 1 week ago

Question

How wide are Salary Structure Ranges?

Answered: 1 week ago