Practice 1

Practice 1 - date and employee number for each employee,...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
ASSIGNMENT FOR JUNE 2004 AST AND ANT SUBMISSION DATE 22 nd July 2004 Practice 1 1. Initiate a SQL*Plus session using the user ID and password provided by the instructor. 2. SQL*Plus commands access the database. True/False 3. Will the SELECT statement execute successfully? True/False SQL> SELECT ename, job, sal Salary 2 FROM emp; 4. Will the SELECT statement execute successfully? True/False SQL> SELECT * 2 FROM salgrade; 5 . There are three coding errors in this statement. Can you identify them? SQL> SELECT empno, ename 2 salary x 12 ANNUAL SALARY 3 FROM emp; 6 . Show the structure of the DEPT table. Select all data from the DEPT table. 7. Show the structure of the EMP table. Create a query to display the name, job, hire
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: date and employee number for each employee, with employee number appearing first. Save your SQL statement to a file named p1q7.sql . 8. Run your query in the file p1q7.sql . 9. Create a query to display unique jobs from the EMP table. 10. Load p1q7.sql into the SQL buffer. Name the column headings Emp #, Employee, Job, and Hire Date, respectively. Rerun your query. 11. Display the name concatenated with the job, separated by a comma and space, and name the column Employee and Title. 12. Create a query to display all the data from the EMP table. Separate each column by a comma. Name the column THE_OUTPUT....
View Full Document

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Ask a homework question - tutors are online