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;

what is null value?

11 Answers   KITS, Oracle,

---

what is index?

4 Answers  

---

What are the different types of failures that occur in Oracle database?

0 Answers   HCL,

---

How to see the table columns used in an index?

0 Answers  

---

What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?

1 Answers  

---

What is meant by recursive hints in oracle?

0 Answers  

---

without using count(*) and rownum how can we count total record in a table

5 Answers   AC, HP,

---

i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash

2 Answers  

---

Can we store images in oracle database?

0 Answers  

---

What are the type of Synonyms?

1 Answers  

---

difference between truncate and delete ,drop?

3 Answers  

---

what are archived logs?

0 Answers  

---