Question: Name Null? Type ------ -------- ------------ DEPTNO NOT NULL NUMBER(2) DNAME VARCHAR2(14) LOC VARCHAR2(13) Name Null? Type ------ -------- ------------ DEPTNO NOT NULL NUMBER(2) DNAME

Name Null? Type ------ -------- ------------ DEPTNO NOT NULL NUMBER(2) DNAME VARCHAR2(14) LOC VARCHAR2(13) Name Null? Type ------ -------- ------------ DEPTNO NOT NULL NUMBER(2) DNAME VARCHAR2(14) LOC VARCHAR2(13)

-- create a function called GET_DEPT_NAME in eclipse : --1)the function return the department name as an output. it received the deptno as an input parameter -- 2)use GET _DEPT_NAME function in a sql select statement to list name, and department name of all employees avoiding using join in the quary

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!

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),...

in Sql C. Command Prompt - sqlplus SQL> desc Course Name Null? Type CORSNO CNAME DEPTNO# CMAX NUMBER(3) VARCHAR2 (30) VARCHAR2(2) NUMBER(2) C. Command Prompt - sqlplus SQL> Name desc DEP Null? Type...

1. If an employee works on all the project 1, 2, and 3, then list the social security number of the employee. 2. Retrieve the social security numbers of all direct and indirect supervisees James Borg...

1. List all the join conditions or join paths (pairwise) existing between these tables. 2. List the primary key and all the foreign keys in each table. 3. Based on each pair of primary key and...

Please i need a SQL query if possible 1) Display all employee names (last name and first name separated by a comma and a space) and salary with appropriate column aliases. Also, for yearly salary...

SESSION: SUMMER 2017 LAB 1B SQL * Plus - CREATING TABLES and CONSTRAINTS FOLLOW INSTRUCTIONS: DO NOT SKIP A SINGLE STEP SECTION I: NOTE: Do not specify any constraints with the create statement...

SESSION: SUMMER 2017 LAB 1B SQL * Plus - CREATING TABLES and CONSTRAINTS Successful people did not attain their success without first overcoming challenges.------- Catherine Pulsifer FOLLOW...

1. List each donor who has made a pledge and indicated a single lump sum payment. Include first name, last name, pledge date, and pledge amount. 2. List each donor who has made a pledge and indicated...

SECTION A [20 Marks) The following are the ER Diagram for the HR Database and table structure for the employees. Write the query statements for all the questions (Questions 1-4). HR DEPARTMENTS...

Convert the formula for water density in problem 21 to be for T in degrees Kelvin.

Following is a list of various costs incurred in producing toy robotic helicopters. With respect to the production and sale of these toy helicopters, classify the following cost as either variable,...

higher rate of return if ( check all that apply ) : Storing the asset is difficult. The asset is unusual and infrequently traded. . The future price of the asset is highly uncertain. The profits from...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

3. What next steps do you think LUX* should take to cement its strong service culture, continue service innovation, and maintain its high profitability?

1. Prepare a flowchart of Dr. Mahalees service encounters.

3. As Sophia Costa, what action would you take in your first five minutes with Dr. Mahalee?