clear scr

prompt =========================================================
prompt =========================================================
prompt =====  Export employee Information by Salary  ===========
prompt ==========  to Microsoft Excel Utility  =================
prompt ==========	promptexample   	================
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
	empno as "ID",
	ename as "Full Name",
	hiredate as "hire On",
	sal as "Sallary"
FROM 
	emp
WHERE 
	sal BETWEEN &MinSal AND &MaxSal
ORDER BY
	ename;

/