Transcription of 60-415 ASSIGNMENT # 2 Solution (SQL DDL and PL/SQL) …
{{id}} {{{paragraph}}}
Example: quiz answers
60-415 ASSIGNMENT # 2 Solution (SQL DDL and PL/SQL) …
60- 415 assignment # 2 Solution ( sql ddl and PL/SQL) Total: 8+5+(3+5+5)+6+6+6+6 = 50 1. The EMP Table Structure Summary EMP_NUM CHAR(3) (Must be a number between 1 and 1000) (Primary Key) EMP_LNAME VARCHAR2(15) EMP_FNAME VARCHAR2(15) EMP_INITIAL CHAR(1) (Must be a char between A and Z EMP_HIREDATE DATE (NOT NULL) JOB_CODE VARCHAR2(10) (Foreign key to Job) The JOB Table Structure Summary JOB_ID VARCHAR2(10) (Primary key) JOB_TITLE VARCHAR2(15) (NOT NULL) MIN_SALARY NUMBER(6) MAX_SALARY NUMBER(6))
b. Pass the values defined in the above step to the PL/SQL block through SQL*Plus substitution variables . The bonus must be converted from a whole number to a decimal (For example from 15 to .15) . If the salary is null, set it to zero before computing the total compensation. Execute the PL/SQL block. Reminder : Use the NVL
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: