Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started