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;

How do I limit the number of oracle database connections generated by weblogic server?

1115

---

What is the difference between sharding and replication?

1135

---

How to change program global area (pga) in oracle?

1146

---

How to run the anonymous block again?

1175

---

How to empty your oracle recycle bin?

1074

---

How to do paging with oracle?

1049

---

In oracle there is column command, how will you explain that?

1137

---

How to delete multiple rows from a table in oracle?

1115

---

How to download oracle database 10g xe?

1066

---

Can group functions be used in the order by clause in oracle?

1043

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

2384

---

Is oracle a relational database?

968

---

How to invoke the data pump export utility?

1251

---

Explain the use of online redo log files in oracle.

1077

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2118

---