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
- 2761 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 use of Control File ?
How to use like conditions in oracle?
How to convert a date to char in oracle? Give one example.
material view and view disadvantages?
How can I get column names from a table in oracle?
What privilege is needed for a user to create indexes in oracle?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
What happens to the current transaction if the session is killed?
What is the maximum number of CHECK constraints that can be defined on a column ?
what is the syntax of DROP command?
What is an oracle and why it is used?
Oracle General 
