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;

Explain the difference between replace() and translate() functions in oracle?

0 Answers  

---

What is the use of Redo Log Information ?

2 Answers  

---

What is the difference between SQL, DDL, and DML?

7 Answers   BeBo Technologies, Wipro,

---

What is the difference between truncate & delete command?

0 Answers  

---

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

0 Answers  

---

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers   IBM,

---

Give syntax for SQL and ORACLE joins.

0 Answers   TCS,

---

What is recovery manager in Oracle?

0 Answers   MCN Solutions,

---

A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?

7 Answers   Cognizant, IBM,

---

State any two functions of oracle?

0 Answers   Aricent,

---

What is the data pump export utility?

0 Answers  

---

What is sequence?

0 Answers  

---