how to retrieve data from different tables ,place this data in different excel worksheets.
- 1 Answers
- 2164 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 |
How to load data from external tables to regular tables?
i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings
Who i will insert 1 lacks record in a Database table
How to drop an index in oracle?
What is difference between a formal and an actual parameter?
How to filter out duplications in the returning rows using oracle?
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
how to find find & delete duplicate rows from two different tables?
How to create lov dynamically at runtime & attach to text field?
Explain do view contain data?
WHAT IS ecc 6.0
How to best split csv strings in oracle 9i?
Oracle General 
