Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello, this question is for Oracle SQL. Table: Employees Last Name Dept Hire_Date Code Phone Manager id Ext Employee First Name Credit Limit 201 202

Hello, this question is for Oracle SQL.

image text in transcribed

Table: Employees Last Name Dept Hire_Date Code Phone Manager id Ext Employee First Name Credit Limit 201 202 203 204 205 206 207 208 209 210 Susan 1m Martha E1len Hen Caro Dan Fred Paula Nancy Brown Kern Woods Owens Perkins Rose Smith 01-Jun-1998 16-Aug-1999 02-Feb-2004 01-Jul-2003 01-Mar-2000 nu l 01-Dec-2004 01-Apr-2003 17-Mar-1999 16-Feb-2004 $30.00 $25.00 $25.00 $15.00 $25.00 null $25.00 $30.00 $15.00 $25.00 3484 (nul1) 8722 7591201 6830 202 5286 202 null (null1) 2259 203 1752 203 3357 2974 Exe Sal 201 Sa Sal Act Campbe11 Jacobs Hoffman Shp Mkt Sal 201 203 #12, write a SQL statement to add a new employee John Adam to the Employees table, John joined the Accounting department His date of joining is 18th Sept, 2011. He works for manager with id: 203. He is allotted any phone extension 3758 His credit limit is set to $40.00. Use the sequence to uniquely identify the new employee

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

Database Management Systems Designing And Building Business Applications

Authors: Gerald V. Post

1st Edition

0072898933, 978-0072898934

More Books

Students also viewed these Databases questions