Answer / mahesh_ch

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;

Respected sir, Please send me technical questions related to oracle apps..

0 Answers  

---

Difference between pre-select and pre-query

0 Answers  

---

what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?

1 Answers   Arrow Electronics,

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

---

What is procedure overloading in oracle?

0 Answers  

---

What are the differences between lov and list item?

0 Answers  

---

How to recover a dropped index?

1 Answers  

---

Explain joins in oracle?

0 Answers  

---

what are the default admin accounts in Oracle 10g ?

0 Answers   MCN Solutions,

---

What would you do with an in-doubt distributed transaction?

0 Answers  

---

Is postgres faster than oracle?

0 Answers  

---

if you ctreate table identity

0 Answers  

---