________________ A Practice Solutions ________________

Practice 1: Solutions Part 1 Test your knowledge: 1. The following SELECT statement executes successfully:
SELECT last_name, job_id, salary AS Sal FROM employees;

True/False 2. The following SELECT statement executes successfully:
SELECT * FROM job_grades;

True/False 3. There are four coding errors in this statement. Can you identify them?
SELECT sal x 12 FROM employee_id, last_name ANNUAL SALARY employees;

• • • •

The EMPLOYEES table does not contain a column called sal. The column is called SALARY. The multiplication operator is *, not x, as shown in line 2. The ANNUAL SALARY alias cannot include spaces. The alias should read ANNUAL_SALARY or should be enclosed in double quotation marks. A comma is missing after the LAST_NAME column.

Part 2 Note the following location for the lab files: \home\oracle\labs\SQL1\labs If you are asked to save any lab files, save them at this location. To start Oracle SQL Developer, double-click the SQL Developer desktop icon. Before you begin with the practices, you need a database connection to be able to connect to the database and issue SQL queries.

Oracle Database 10g: SQL Fundamentals I A - 2

Practice 1: Solutions (continued) 4. To create a new database connection in the Connections Navigator, right-click Connections. Select New Connection from the menu. The New/Select Database Connection dialog box appears.

5. Create a database connection using the following information: a. Connection Name: myconnection b. Username: ora1 c. Password: ora1 d. Hostname: localhost e. Port: 1521 f. SID: ORCL g. Ensure that you select the Save Password check box.

Oracle Database 10g: SQL Fundamentals I A - 3

Practice 1: Solutions (continued) You have been hired as a SQL programmer for Acme Corporation. Your first task is to create some reports based on data