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;

What is the difference between sharding and replication?

1060

---

What is a synonym? What are its various types?

1115

---

Give the various exception types.

997

---

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1113

---

How to bring a tablespace offline?

1070

---

What is meant by raw datatype?

1070

---

What language does oracle use?

1116

---

What is a dynamic performance view in oracle?

1001

---

How to create a single index for multiple columns?

1044

---

What is format trigger?

2077

---

How to handle a single quote in oracle sql?

1062

---

Which is faster join or subquery in oracle?

1000

---

Can we create database in oracle using command line ?

1093

---

How can I introduce multiple conditions in like operator?

993

---

What do you mean by group by clause?

1051

---