Fill This Form To Receive Instant Help
Fill This Form To Receive Instant Help
Homework answers / question archive / How do I delete? From Problem 8
How do I delete? From Problem 8.1--8.4
Problem 2
Having created the table structure in Problem 1, write the SQL code to enter the first two rows for the table shown in Figure P8.2. Each row should be inserted individually, without using a subquery. Insert the rows in the order that they are listed in the figure.
OPTION 2:
Delete the entry with EMP_NUM of 100. It is important to delete this so that you would meet the expected output
This one:
100 News John G 2000-11-08 502
Due to some uploading issues with the DDL SQL statement, Please get the query from here. https://www.codepile.net/pile/rRr7r58n
Problem 2.
Emp_1 table structure is created as per question 1.
The above 2 insert SQL statements inserts the data into EMP_1 table as 101 as EMP_NO, News as EMP_LNAME, John as EMP_FNAME,
G as EMP_INITIAL, 08-Nov-00 as EMP_HIREDATE, 501 as JOB_CODE.
OPTION 2:
The above SQL statement deletes the record from EMP_1 where EMP_NUM = 100
