Determine whether the following statements are true or false:
1. The following statement is correct:
   DEFINE & p_val = 100
	False
	The correct use of DEFINE is DEFINE p_val=100. The & is used within the SQL code.

2. The DEFINE command is a SQL command.
	
	False
	The DEFINE command is an iSQL*Plus command.

3. Write a script to display the employee last name, job, and hire date for all employees who
   started between a given range. Concatenate the name and job together, separated by a space
   and comma, and label the column Employees. In a separate SQL script file, use the DEFINE
   command to provide the two ranges. Use the format MM/DD/YYYY. Save the script files as
   lab7_3a.sql and lab7_3b.sql.

	-- lab file lab7_3a.sql
	SET ECHO OFF
	SET VERIFY OFF
	DEFINE low_date = 01/01/1998
	DEFINE high_date = 01/01/1999
	-- lab file lab7_3a.sql
	SELECT last_name ||’, ’|| job_id EMPLOYEES, hire_date
	FROM employees
	WHERE hire_date BETWEEN TO_DATE(’&low_date’, ’MM/DD/YYYY’)
	AND TO_DATE(’&high_date’, ’MM/DD/YYYY’)
	/
	UNDEFINE low_date
	UNDEFINE high_date
	SET VERIFY ON
	SET ECHO ON

4. Write a script to display the employee last name, job, and department name for a given location.
   The search condition should allow for case-insensitive searches of the department location. Save
   the script file as lab7_4.sql.
	
	SET ECHO OFF
	SET VERIFY OFF
	COLUMN last_name HEADING "EMPLOYEE NAME"
	COLUMN department_name HEADING "DEPARTMENT NAME”
	SELECT e.last_name, e.job_id, d.department_name
	FROM employees e, departments d, locations l
	WHERE e.department_id = d.department_id
	AND l.location_id = d.location_id
	AND l.city = INITCAP('&p_location')
	/
	COLUMN last_name CLEAR
	COLUMN department_name CLEAR
	SET VERIFY ON
	SET ECHO ON

5. Modify the code in lab7_4.sql to create a report containing the department name, employee
   last name, hire date, salary, and each employee’s annual salary for all employees in a given
   location. Label the columns DEPARTMENT NAME, EMPLOYEE NAME, START DATE,
   SALARY, and ANNUAL SALARY, placing the labels on multiple lines. Resave the script as
   lab7_5.sql and execute the commands in the script.
	
	SET ECHO OFF
	SET FEEDBACK OFF
	SET VERIFY OFF
	BREAK ON department_name
	COLUMN department_name HEADING "DEPARTMENT|NAME"
	COLUMN last_name HEADING "EMPLOYEE|NAME"
	COLUMN hire_date HEADING "START|DATE"
	COLUMN salary HEADING "SALARY" FORMAT $99,990.00
	COLUMN asal HEADING "ANNUAL|SALARY" FORMAT $99,990.00
	SELECT d.department_name, e.last_name, e.hire_date,
	e.salary, e.salary*12 asal
	FROM departments d, employees e, locations l
	WHERE e.department_id = d.department_id
	AND d.location_id = l.location_id
	AND l.city = ’&p_location’
	ORDER BY d.department_name
	/
	COLUMN department_name CLEAR
	COLUMN last_name CLEAR
	COLUMN hire_date CLEAR
	COLUMN salary CLEAR
	COLUMN asal CLEAR
	CLEAR BREAK
	SET VERIFY ON
	SET FEEDBACK ON
	SET ECHO ON