Question: Hello, this question is for oracle SQL. Table: Employees Employee First Name Id Dept Code Credit Limit Phone Manager-id Ext Last_Name Hire_Date 201 202 203

Hello, this question is for oracle SQL.

Hello, this question is for oracle SQL. Table: Employees Employee First Name

Table: Employees Employee First Name Id Dept Code Credit Limit Phone Manager-id Ext Last_Name Hire_Date 201 202 203 204 205 206 207 208 209 210 Brown Kern Woods Owens Perkins Rose Smith Campbel1 Jacobs Hoffman Exe Sal Sh Sa Sal Act Shp Shp Mkt Sal 01-Jun-1998 16-Aug-1999 02-Feb-2004 01-Jul-2003 01-Mar-2000 null 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 S15.00 S25.00 3484 (null) 8722 7591 6830 5286 202 null (ul) 2259 1752 203 3357 2974 203 Susan 1m Martha 201 201 202 en Hen Caro Dan Fred Paula Nancy 203 201 #2. write a SQL statement to add a new employee Rick Adam to the Employees table. Rick 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- 3757 His credit limit is set to $35.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!