Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve data from different tables ,place this data in different excel worksheets.
- 1 Answers
- 2713 Views
- Gap Inc, I also Faced
- E-Mail Answers
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 |
Whats the benefit of dbms_stats over analyze?
What are various constraints used in SQL?
difference between oracle8i and oracle9i
What is Database Trigger ?
What is an external table?
Why do we need oracle client?
What do you mean by a tablespace?
What is the simplest tool to run commands on oracle servers?
What would you do if a database crashes in production?
What are various joins used while writing SUBQUERIES?
How to create a temporary table in oracle?
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
Oracle General 
