Question: write code pl/sql with output 1. create a copy of the table employee (New table name is employee_copy) 2. Write anonymous block to display Firstname

write code pl/sql with output

1. create a copy of the table employee (New table name is employee_copy) 2. Write anonymous block to display Firstname and Salary of employee number 110 (use %TYPE) 3.Write anonymous block to display average salary of all employees (use %TYPE) 4.What is the difference between %ROWTYPE and %TYPE

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!

i have syntax but when i run query it shows compilation error. send me pl/sql syntax with output 1. create a copy of the table employee (New table name is employee_copy) 2. Write anonymous block to...

why this show error? Worksheet Query Builder DECLARE EmployeeName employee. Name TYPE: BEGIN SELECT ficat_name, salary INTO VEmployeeName PROM employee WHERE employee_id=110; DES OUTPUT.PUTLINE...

write pl/sql code with output 1. create a copy of the table employee (New table name is employee_copy) 2. Write anonymous block to display Firstname and Salary of employee number 110 (use %TYPE)...

give code for PL/sql 1. create a copy of the table employee (New table name is employee_copy) 2. Write anonymous block to display Firstname and Salary of employee number 110 (use %TYPE) 3.Write...

PL/SQL Question: write a PL/SQL anonymous block that performs the following tasks. CREATE TABLE department ( DEPARTMENT_ID NUMBER PRIMARY KEY, DEPARTMENT_NAME VARCHAR2(50) NOT NULL UNIQUE, LOCATION...

In a school, the Personnel Department is responsible for storing details about all staff who work for the school. There are four categories of staff: management teacher support staff maintenance and...

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

I WANT SCREENSHOT OUTPUT Q1. Below a Table is given, Create a table and name as you like and insert few values as it shown in the below table Write a PL/SQL block to calculate the incentive of an...

Returns the status of the cursor An attribute that processes an exact number of rows or counts the number of rows fetched in a loop An attribute used to determine whether the most recent FETCH...

Name the following chart, and identify the items represented by the letters (a) through(f). Sales and Costs $200,000 $150,000 $100,000 $50,000 10,000 20,000 30,000 40,000 50,000 60,000 70,000 80,000...

List the four assumptions about the random error e required for a multiple-regression analysis.

if a project has a positive net present value, then _ _ _ _ . . The profitability index is greater than 1 . IRR is lower than the cost of capital of the project. The project will be accepted based on...

With a centralized cash depository a. a MNC can facilitate fund mobilization. O b. system-wide excess cash is invested at the most advantageous rates. C. system-wide cash shortages are borrowed at...

5. Go to www.walmartstores.com, the Web site for Wal-Mart. Click on Careers and then click on Diversity. Review Wal-Marts diversity efforts. What has Wal-Mart done to strengthen its diversity? Rate...

12. How can companies ensure that talented women have access to development programs?

2. The Big Brothers/Big Sisters of America is the oldest teen mentor organization in the country. Go to its Web site at www.bbbsa.org. Read about the corporate partners; read the newsletters and...