how to retrieve data from different tables ,place this data in different excel worksheets.
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;
Is This Answer Correct ? | 1 Yes | 0 No |
Explain temporal data types in oracle
What is a user role in oracle?
Differentiate between pre-select and pre-query?
What is a relational database management system?
What is format trigger?
List the parts of a database trigger.
The join defined by the default data link is an outer join yes or no ?
find out first highest salary?
10 Answers Verinon Technology Solutions,
How do you bind variables in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How many categories of data types?
How can we force the database to use the user specified rollback segment?