Answer Posted / 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;

Can we protect our pl/sql source code?

1028

---

Explain the function of optimizer in oracle?

1103

---

What is a connect identifier?

1025

---

What is a oracle database?

1034

---

Give the various rollback segment states.

1031

---

What is bulk load in oracle?

1051

---

How to convert dates to characters in oracle?

1019

---

Can we write insert statement in function in oracle?

1070

---

How to set up autotrace for a user account?

1032

---

How does oracle handle read consistency?

1076

---

Why cursor variables are easier to use than cursors?

1068

---

Why does Oracle not permit the use of PCTUSED with indexes?

2408

---

What is the difference between hot backup and cold backup in oracle?

999

---

What is meant by a deadlock situation?

1092

---

What is a proxy object?

1042

---