Question: Output in Oracle 1. Create a view which displays the ename, dname and sal of all the employees of deptno 30. Create a PL/SQL program

Output in Oracle Output in Oracle 1. Create a view which displays the ename, dname

1. Create a view which displays the ename, dname and sal of all the employees of deptno 30. Create a PL/SQL program to display highest salary using view created. 2. Create a table My_emp1001 (instead of 1001 write last 3 digits of your enrollment no.) having records of deptno = 30 now Create a view MY_View based on the table My_emp1001 . Now select all the records from the view MY_View

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!

drop table department purge; drop table employee purge; create table department (ID, department_name) as select deptno, dname from dept; create table employee (employee_id, dept_id) as select empno,...

DATABASE PROGRAMMING CREATE TABLE dept ( deptno NUMBER(2,0), dname VARCHAR2(14), loc VARCHAR2(13), CONSTRAINT n_pk_dept PRIMARY KEY (deptno) ); CREATE TABLE emp( empno NUMBER(4,0), ename...

sql deptno number (2,0), dname varchar2 (14), loc varchar2 (13), constraint dept_pk primary key (deptno)); Create Table Emp( empn number (4,0) primary key, empname varchar2 (10), job varchar2 (9),...

LAB OVERVIEW Lab 7 will introduce the concept of database views. Deliverables Lab Report (Answer Sheet) containing both the student-created SQL command(s) for each exercise, and the output showing...

Populate.sql: Please show with steps on cmd SQL format Rem ******** dropping tables ************* DROP TABLE SALGRADE; DROP TABLE EMPLOYEE; DROP TABLE DEPT; Rem ******** create table DEPT...

WRITE SQL QUERIES FOR THE FOLLOWING QUESTIONS WHICH IS BASED ON EMPLOYEES TABLE Below is a sample of searched CASE statement. It finds the average salary of the employees in the Employees table,...

1. Create a view named WEST_COAST_CUSTOMERS_Vthat consists of all the data for customers that live in Los Angeles and San Diego. Display all the customers using this view. 2. Construct a view called...

DATABASE PROGRAMMING - WRITE THE SQL QUERIES FOR THE FOLLOWING QUESTIONS CREATE TABLE dept ( deptno NUMBER(2,0), dname VARCHAR2(14), loc VARCHAR2(13), CONSTRAINT n_pk_dept PRIMARY KEY (deptno) );...

Output in Oracle enrollment number in Q2 is 007 1. Create a view which displays the ename, dname and sal of all the employees of deptno 30. Create a PL/SQL program to display highest salary using...

-- echo Building demo tables. Please wait. DROP TABLE EMP CASCADE CONSTRAINTS; DROP TABLE DEPT; DROP TABLE SALGRADE; DROP TABLE Prod CASCADE CONSTRAINTS; DROP TABLE Vend; CREATE TABLE DEPT ( DEPTNO...

On 1 April 20X0 Slow and Steady Co held non-current assets that cost $312,000 and had accumulated depreciation of $66,000 at this date. During the year ended 31 March 20X1, Slow and Steady Co...

Four identical particles each with charge Q are at the corners of a square of side L. The particles are released one at a time proceeding clockwise around the square. Each particle is allowed to...

General accounting question Melody Corp. planned and actually manufactured 150,000 units of its single product in 2023, its first year of operations. Variable manufacturing costs were $25 per unit of...

Discuss these Hacker types and possible ways to prevent them in network security: -White Hat -Black Hat -Gray Hat -Phreaker -Spammer -Phisher

4. What are the facts that need to be considered? What assumptions are you making?

2. Who are the stakeholders, and how would they define the problem? What are the values of greatest importance to these stakeholders?

1. What is the values dilemma presented in this short case study? What values seem at issue as you define the problem?