clear scr

prompt =========================================================
prompt =========================================================
prompt =====  Export employee Information by Salary  ===========
prompt ==========  to Microsoft Excel Utility  =================
prompt ==========	promptexample2   	================
prompt ============       Version 2.0       ====================
prompt =========================================================
prompt =========================================================
prompt =========================================================

prompt   Please enter the following information:

-- Get the minimum salary
ACCEPT MinSal NUMBER PROMPT "Min Salary :"

-- Get the maximum salary
ACCEPT MaxSal NUMBER PROMPT "Max Salary :"


-- Select the required employee record
SELECT
	TO_CHAR(empno, '009999')         as "ID",
	INITCAP(ename)                   as "Full Name",
	TO_CHAR(hiredate, 'yyyy/mm/dd')  as "Hire On",
	TO_CHAR(sal, '$9999.99')         as "Salary"
FROM 
	emp
WHERE 
	sal BETWEEN &MinSal AND &MaxSal
ORDER BY
	ename;