how to retrieve data from different tables ,place this data in different excel worksheets.
declare
cursor c1 is select e.empno,e.ename,e.sal,e.deptno,d.deptno dno,d.dname,d.loc from emp e,dept d where e.deptno=d.deptno;
fp utl_file.file_type;
cfilename varchar2(20);
begin
cfilename:='office'||to_char(to_date('2007','yyyy'),'yyyy')||'.xls'; /*specifying filename*/
fp:=utl_file.fopen('DATA_PUMP_DIR',cfilename,'w'); /*DATA_PUMP_DIR is a default directory*/
for i in c1 loop
UTL_FILE.PUT_LINE(fp,i.empno||i.ename||i.sal||i.deptno);
end loop;
utl_file.fclose(fp);
end;
Is This Answer Correct ? | 1 Yes | 0 No |
What is program global area (pga) in oracle?
Is it possible to insert comments into sql statements return in the data model editor ?
Define oracle database
How to upsert (update or insert into a table)?
Can select statements be used on views in oracle?
What are the types of Database Links ?
what is difference between table and view? where to use views? thanks in advance!
Define Normalization with example?
WHAT IS ecc 6.0
How to insert a new row into a table in oracle?
Explain what are synonyms used for?
What is the recommended interval at which to run statspack snapshots, and why?