Unformatted text preview: first. Save your SQL statement to a file name p1q7.sql 8. Run the 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 and display the output. 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. THE_OUTPUT 7839,KING,PRESEDENT, ,17-NOV-81,5000,,10 …...
View Full Document
This note was uploaded on 01/29/2012 for the course INTERNATIO 101 taught by Professor Mr.johnnash during the Spring '11 term at Symbiosis International University.
- Spring '11