Question: In SQL Plus, write a script that performs the following: Login to SQL Plus as user SCOTT Issue a statement to display the employee number,

In SQL Plus, write a script that performs the following:

  1. Login to SQL Plus as user SCOTT
  2. Issue a statement to display the employee number, employee name, and salary from the "emp" table .
  3. Issue a statement to delete all records with employee number in the range of 7500 - 7800 from the "emp" table.
  4. Issue a statement that repeats Step 2.
  5. Issue a statement to perform a query on the emp table based on its state 5 minutes previous.
  6. Issue a ROLLBACK statement to undo the transaction.

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!

Q:

Practice 3: Using Single-Row Functions to Customize Output Write a query to display the system date. Label the column Date. Note: If your database is remotely located in a different time zone, the...

Q:

Create one sql script file to complete the following. You cannot run separate SQL statements for the homework. You will also need to place a semicolon after each SQL statement, a requirement for SQL...

Q:

/* company.sql Script to define and populate the example database COMPANY from Chapter 3 of Elmasri and Navathe (pp.70-75 in the 6th edition), with some modifications */ -- drop tables DROP TABLE...

Q:

Write an SQL script that performs the following. Generates a query to display , empno, ename, dname, sal, and hiredate using the formatting details below. Column Headings ( use SQL Plus COLUMN...

Q:

B . Consider the "emp" and "dept" tables from a part of the relational database schema of "Company" database given below, and answer the following questions: ) = ( 5 marks Emp ( empno , ename, job,...

Q:

please as soon as possiable i will rate you up 1. Open SQL developer and create a new connection to Oracle server 2. Express the following queries in SQL: a) List first name, last name and department...

Q:

This assignment will demonstrate the use of transactions. Specifically, changes will be rolled back to a previous state prior to performing a commit. The assignment will be composed of SQL Plus DML...

Q:

This assignment will demonstrate the use of transactions. Specifically, changes will be rolled back to a previous state prior to performing a commit. The assignment will be composed of SQL Plus DML...

Q:

Write a script in SQL Plus that performs the following: Login to SQL Plus as user SCOTT Issue a statement to display the employee number, employee name and salary from the "emp" table Issue a...

Q:

This assignment will demonstrate the use of transactions. Specifically, changes will be rolled back to a previous state prior to performing a commit. The assignment will be composed of SQL Plus DML...

Q:

A stool at a restaurant is anchored to the floor. When a customer is in the process of sitting down, a horizontal force with magnitude F1 is exerted at the top of the stool support as shown in the...

Q:

Someone has two job offers and must decide which to accept. The job in City A pays $47,000 and the average cost of living there is $65,000, with a standard deviation of $15,000. The job in City B...

Q:

EXERCISE 12-3. Internet Assignment Go to the Web site of Art Schneiderman, a consultant, at (http://www.schneiderman.com/AMS.htm). Art worked for Analog Devices when it became the first company to...

Q:

Business - to - business marketing differs from consumer marketing in that business - to - business marketing Select one: A . is targeted at many individual and household customers B . relies upon...

Q:

Should other employees (cleaner, spotters, and front counter staff) be put on a similar plan? Why or why not? If so, how, exactly? The question of whether to pay Carter Cleaning Centre employees an...

Q:

Do you feel that Jack Carters gender wage differential is justified? Is it a wise practice in todays workplace? Carter Cleaning Centres does not have a formal wage structure nor does it use rate...

Q:

Is there another incentive plan you think would work better for the pressers? Describe it. The question of whether to pay Carter Cleaning Centre employees an hourly wage or an incentive of some kind...