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 system tablespace?

0 Answers  

---

What are various constraints used in SQL?

1 Answers   Polaris,

---

25. Display the client number and the value of the highest value order placed by that client.

2 Answers   Wipro,

---

How to assign values to data fields in record variables?

0 Answers  

---

what happened to the global index when I truncate the data in one of the partition?

0 Answers  

---

Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here

2 Answers  

---

What is a relational database management system?

0 Answers  

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

0 Answers  

---

write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.

11 Answers   Wipro,

---

What is user managed backup in Oracle?

0 Answers   MCN Solutions,

---

What happens to the indexes if a table is recovered?

0 Answers  

---

what is Table ?

2 Answers  

---