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 |
what is null value?
what is index?
What are the different types of failures that occur in Oracle database?
How to see the table columns used in an index?
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
What is meant by recursive hints in oracle?
without using count(*) and rownum how can we count total record in a table
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
Can we store images in oracle database?
What are the type of Synonyms?
difference between truncate and delete ,drop?
what are archived logs?