Transcription of Egitim-Introduction to Oracle 9i SQL Student Guide Vol2
{{id}} {{{paragraph}}}
Practice SolutionsIntroduction to Oracle9i: SQL A-3 Practice 1 Solutions1. Initiate aniSQL*Plus session using the user ID and password provided by the *Plus commands access the The following SELECT statement executes successfully:TrueSELECT last_name, job_id, salary AS SalFROM employees;4. The following SELECT statement executes successfully: TrueSELECT * FROM job_grades;5. There are four coding errors in this statement. Can you identify them?SELECT employee_id, last_namesal x 12 ANNUAL SALARYFROM employees; TheEMPLOYEES table does not contain a column calledsal. The column is called SALARY. The multiplication operator is *, not x, as shown in line 2. TheANNUAL SALARY alias cannot include spaces. The alias should read ANNUAL_SALARYor be enclosed in double quotation marks. A comma is missing after the column, Show the structure of the DEPARTMENTS table. Select all data from the departmentsSELECT *FROM departments;7.
Label the column REVIEW . Format the dates to appear in the format similar to ... (TO_CHAR(commission_pct), 'No Commission') COMM FROM employees; 12. Create a query that displays the employees’last names and indicates the amounts of their annual ... 13. Using the DECODE function, write a query that displays the grade of all employees based on the
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}