Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve data from different tables ,place this data in different excel worksheets.
- 1 Answers
- 2790 Views
- Gap Inc, I also Faced
- E-Mail Answers
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 |
What is the string concatenation operator in oracle?
What is execute immediate in oracle?
What are joins, explain all types of joins?
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
What are the database administrators utilities available?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
How to load a large xml file?
How to list all user accounts in oracle?
what are bitmap indexes? How does they work?
Why do we need oracle client?
What is a subquery in oracle?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Oracle General 
