Oracle to Excel via Sqlplus
To Generate Excel file for any table , make like this example at SQL*PLUS :-
---------------------------------
SET MARKUP HTML ON
SET TERMOUT OFF
SET FEEDBACK OFF
SPOOL current_employees.xls
SELECT first_name
||' '
||last_name AS "Employee Name",
salary,
hire_date,
NVL(TO_CHAR(commission_pct),'No Commission')
AS "Commission", job_id
FROM employees;
SPOOL OFF
EXIT;
---------------------------------
Posts
0 comments:
Post a Comment