Home » SQL & PL/SQL » SQL & PL/SQL » Formatting pl/sql output
Formatting pl/sql output [message #231726] Wed, 18 April 2007 04:52 Go to next message
lilstrum
Messages: 8
Registered: April 2007
Junior Member
Hello,
I've got this script:

set serveroutput on

-------------------------------
-- Declaration of Procedure Retrieve_Mgr
--
CREATE or REPLACE procedure Retrieve_Mgr(MgrId integer, EmpLoc varchar2)
is

var_name scott.emp.ename%Type;
var_loc scott.dept.loc%Type;


begin

select eName, loc into var_Name, var_loc
from scott.emp, scott.dept
where empno = MgrId
and scott.emp.deptno = scott.dept.deptno;



if (var_loc != EmpLoc)
then
dbms_output.put_line('Clerks Managers name is ' || var_name || '
and their Location is ' || var_loc || ' and the Manager is Off-Site');
dbms_output.put_line(chr(0));
else
dbms_output.put_line('Clerks Managers name is ' || var_name || '
and their Location is ' || var_loc || ' and the Manager is On-Site');
dbms_output.put_line(chr(0));
end if;

end;
/

-- End of Procedure Retrieve_Mgr Declaration
--
---------------------------------------------------
-- Declaration of Procedure Bonus
--

CREATE or REPLACE procedure Bonus(SalesmanId int, Salesdeptno int)
is

cursor cEmps is
select ename, sal, hiredate
from scott.emp
where empno <> salesmanId
and deptno = Salesdeptno
and job <> 'SALESMAN';

varHire scott.emp.hiredate%Type;
varSalary scott.emp.sal%Type;
varSalesSalary scott.emp.sal%Type;
varSalesBonus number(7,2);
varOtherBonus number(7,2);
varEmpName scott.emp.ename%Type;

begin


dbms_output.put_line('The Salesmans dept Id is: ' || Salesdeptno );

select HireDate, Sal into varHire, varSalesSalary
from scott.emp
where scott.emp.empno = SalesmanId;

varSalesBonus := ((sysdate - varHire - (2 * varSalesSalary)) *
0.33);
dbms_output.put_line('The Salesmans bonus is: '|| varSalesBonus);


open cEmps;

loop

fetch cEmps into varEmpName, varSalary, varHire;
EXIT WHEN cEmps%NOTFOUND;

varOtherBonus:= ((((sysdate - varHire) - varSalesSalary) -
varSalary) * 0.33);

if (varSalesBonus > varOtherBonus)
then
dbms_output.put_line('Employee ' || varEmpName || '
has a bonus of: ' ||varOtherBonus || ' which is lower than the department salesman');
else
dbms_output.put_line('Employee ' || varEmpName || '
has a bonus of: ' ||varOtherBonus || ' which is higher than the department salesman');
end if;
END LOOP;
CLOSE cEmps;
end;
/

-- End of Procedure Declaration
--
-------------------------------
DECLARE
-- Cursor Declaration
--
CURSOR c1 IS
SELECT a.empno, a.ename, a.mgr, a.deptno, b.loc, a.job
FROM scott.emp a, scott.dept b
WHERE a.deptno=b.deptno
ORDER BY mgr DESC;
--
var_empno1 scott.emp.empno%type;
var_ename1 scott.emp.ename%TYPE;
var_mgr1 scott.emp.mgr%TYPE;
var_deptno1 scott.emp.deptno%TYPE;
var_deptno2 scott.dept.deptno%TYPE;
var_loc2 scott.dept.loc%TYPE;
var_job1 scott.emp.job%type;

---------------------------------------------------
-- Main [or Calling] Program
--

BEGIN

OPEN c1;

LOOP

FETCH c1 INTO var_empno1, var_ename1, var_mgr1, var_deptno1, var_loc2, var_job1;
EXIT WHEN c1%NOTFOUND;


if (var_job1 like 'CLERK')
then
begin
Retrieve_Mgr(var_mgr1,var_loc2) ;
end;
end if;

if (var_job1 like 'SALESMAN')
then
begin
dbms_output.put_line('The Salesmans is: ' || var_ename1);
Bonus(var_empno1,var_deptno1) ;
dbms_output.put_line(chr(0));
end;
end if;

END LOOP;
CLOSE c1;
END;
/


Which gives this output:

Clerks Managers name is MILLER and their Location is NEW YORK and the Manager is Off-Site

Clerks Managers name is MILLER and their Location is NEW YORK and the Manager is Off-Site

Clerks Managers name is FORD and their Location is DALLAS and the Manager is On-Site

Clerks Managers name is SCOTT and their Location is DALLAS and the Manager is On-Site

Clerks Managers name is CLARK and their Location is NEW YORK and the Manager is On-Site

Clerks Managers name is BLAKE and their Location is CHICAGO and the Manager is On-Site

The Salesmans is: TURNER
The Salesmans dept Id is: 30
The Salesmans bonus is: 2096.64
Employee BLAKE has a bonus of: 1694.04 which is lower than the department salesman
Employee JAMES has a bonus of: 2249.76 which is higher than the department salesman
Employee NORRIS has a bonus of: 2148.45 which is higher than the department salesman

The Salesmans is: MARTIN
The Salesmans dept Id is: 30
The Salesmans bonus is: 2255.04
Employee BLAKE has a bonus of: 1776.54 which is lower than the department salesman
Employee JAMES has a bonus of: 2332.26 which is higher than the department salesman
Employee NORRIS has a bonus of: 2230.95 which is lower than the department salesman

The Salesmans is: WARD
The Salesmans dept Id is: 30
The Salesmans bonus is: 2326.98
Employee BLAKE has a bonus of: 1776.54 which is lower than the department salesman
Employee JAMES has a bonus of: 2332.26 which is higher than the department salesman
Employee NORRIS has a bonus of: 2230.95 which is lower than the department salesman

The Salesmans is: ALLEN
The Salesmans dept Id is: 30
The Salesmans bonus is: 2096.64
Employee BLAKE has a bonus of: 1661.04 which is lower than the department salesman
Employee JAMES has a bonus of: 2216.76 which is higher than the department salesman
Employee NORRIS has a bonus of: 2115.45 which is higher than the department salesman
PL/SQL procedure successfully completed.


Is there any way of giving the 2 seperate sections of output a title and also to organise them by managers name and salesmans name respectively?

Thanks for any help
Lilstrum
Re: Formatting pl/sql output [message #231733 is a reply to message #231726] Wed, 18 April 2007 05:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Format your post: read "How to format your posts"
2/ Yes there is a way but it will be clearer if you post an example of what you want
3/ Format the output example
4/ Do you really want to do it in PL/SQL and not SQL?

Regards
Michel
Re: Formatting pl/sql output [message #231750 is a reply to message #231733] Wed, 18 April 2007 05:38 Go to previous messageGo to next message
lilstrum
Messages: 8
Registered: April 2007
Junior Member
1/ Sorry, I saw that just after I posted it


set serveroutput on

-------------------------------
-- Declaration of Procedure Retrieve_Mgr
--
CREATE or REPLACE procedure Retrieve_Mgr(MgrId integer, EmpLoc varchar2)
is

var_name scott.emp.ename%Type;
var_loc scott.dept.loc%Type;


begin

	select eName, loc  into var_Name, var_loc
	from scott.emp, scott.dept
	where empno = MgrId
	and scott.emp.deptno = scott.dept.deptno;

	

	if (var_loc !=  EmpLoc)
        then
		dbms_output.put_line('Clerks Managers name is ' || var_name || '
		and their Location is ' || var_loc || ' and the Manager is Off-Site');
                dbms_output.put_line(chr(0)); 
	else
		dbms_output.put_line('Clerks Managers name is ' || var_name || '
		and their Location is ' || var_loc || ' and the Manager is On-Site');
                dbms_output.put_line(chr(0)); 
	end if;

end;
/

-- End of Procedure Retrieve_Mgr Declaration
--
---------------------------------------------------
-- Declaration of Procedure Bonus
-- 

CREATE or REPLACE procedure Bonus(SalesmanId int, Salesdeptno int)
is

cursor cEmps is
	select ename, sal, hiredate
	from scott.emp
	where empno <> salesmanId
	and deptno = Salesdeptno
	and job <> 'SALESMAN';

varHire scott.emp.hiredate%Type;
varSalary scott.emp.sal%Type;
varSalesSalary scott.emp.sal%Type;
varSalesBonus number(7,2);
varOtherBonus number(7,2);
varEmpName scott.emp.ename%Type;

begin


	dbms_output.put_line('The Salesmans dept Id is: ' || Salesdeptno );

	select HireDate, Sal into varHire, varSalesSalary
	from scott.emp
	where scott.emp.empno = SalesmanId;

	varSalesBonus := ((sysdate - varHire - (2 * varSalesSalary)) *
0.33);
	dbms_output.put_line('The Salesmans bonus is: '|| varSalesBonus);

	
	open cEmps;
		
	loop

		fetch cEmps into varEmpName, varSalary, varHire;
		EXIT WHEN cEmps%NOTFOUND;
	
		varOtherBonus:= ((((sysdate - varHire) - varSalesSalary) -
		varSalary) * 0.33);

		if (varSalesBonus > varOtherBonus)
		then
			dbms_output.put_line('Employee ' || varEmpName || '
			has a bonus of: ' ||varOtherBonus || ' which is lower than the department salesman');
		else
			dbms_output.put_line('Employee ' || varEmpName || '
			has a bonus of: ' ||varOtherBonus || ' which is higher than the department salesman');
		end if;
	END LOOP;
CLOSE cEmps;
end;
/

-- End of Procedure Declaration
--
-------------------------------
DECLARE
-- Cursor Declaration
--
CURSOR c1 IS
   SELECT a.empno, a.ename, a.mgr, a.deptno, b.loc, a.job 
     FROM scott.emp a, scott.dept b
       WHERE a.deptno=b.deptno
	ORDER BY mgr DESC;
--
var_empno1 scott.emp.empno%type;
var_ename1 scott.emp.ename%TYPE;
var_mgr1 scott.emp.mgr%TYPE;
var_deptno1 scott.emp.deptno%TYPE;
var_deptno2 scott.dept.deptno%TYPE;
var_loc2 scott.dept.loc%TYPE;
var_job1 scott.emp.job%type;      	

---------------------------------------------------
-- Main [or Calling] Program
--

BEGIN

OPEN c1;

LOOP
   		
FETCH c1 INTO var_empno1, var_ename1, var_mgr1, var_deptno1, var_loc2, var_job1;
   		EXIT WHEN c1%NOTFOUND;

     
     	if (var_job1 like 'CLERK') 
     	then
               begin
                  Retrieve_Mgr(var_mgr1,var_loc2) ;
               end;
     	end if;

     	if (var_job1 like 'SALESMAN') 
     	then
               begin
                  dbms_output.put_line('The Salesmans is: ' || var_ename1);
	          Bonus(var_empno1,var_deptno1) ;
                  dbms_output.put_line(chr(0));
               end;
     	end if;

END LOOP;
CLOSE c1;
END;
/


3/ Ouput
Clerks Managers name is MILLER and their Location is NEW YORK and the Manager is Off-Site
 
Clerks Managers name is MILLER and their Location is NEW YORK and the Manager is Off-Site
 
Clerks Managers name is FORD and their Location is DALLAS and the Manager is On-Site 

Clerks Managers name is SCOTT and their Location is DALLAS and the Manager is On-Site
 
Clerks Managers name is CLARK and their Location is NEW YORK and the Manager is On-Site
 
Clerks Managers name is BLAKE and their Location is CHICAGO and the Manager is On-Site
 
The Salesmans is: TURNER 
The Salesmans dept Id is: 30 
The Salesmans bonus is: 2096.65 
Employee BLAKE has a bonus of: 1694.05 which is lower than the department salesman 
Employee JAMES has a bonus of: 2249.77 which is higher than the department salesman 
Employee NORRIS has a bonus of: 2148.46 which is higher than the department salesman
 
The Salesmans is: MARTIN 
The Salesmans dept Id is: 30 
The Salesmans bonus is: 2255.05 
Employee BLAKE has a bonus of: 1776.55 which is lower than the department salesman 
Employee JAMES has a bonus of: 2332.27 which is higher than the department salesman 
Employee NORRIS has a bonus of: 2230.96 which is lower than the department salesman
 
The Salesmans is: WARD 
The Salesmans dept Id is: 30 
The Salesmans bonus is: 2326.99 
Employee BLAKE has a bonus of: 1776.55 which is lower than the department salesman 
Employee JAMES has a bonus of: 2332.27 which is higher than the department salesman 
Employee NORRIS has a bonus of: 2230.96 which is lower than the department salesman
 
The Salesmans is: ALLEN 
The Salesmans dept Id is: 30 
The Salesmans bonus is: 2096.65 
Employee BLAKE has a bonus of: 1661.05 which is lower than the department salesman 
Employee JAMES has a bonus of: 2216.77 which is higher than the department salesman 
Employee NORRIS has a bonus of: 2115.46 which is higher than the department salesman 
PL/SQL procedure successfully completed.



2/
I essentially want it to look something along the lines of this this
Question 1 - Clerks manager names and locations

------------------------------------------------------------------------------------------


Clerks Managers name is BLAKE and their Location is CHICAGO and the Manager is On-Site

Clerks Managers name is CLARK and their Location is NEW YORK and the Manager is On-Site

Clerks Managers name is FORD and their Location is DALLAS and the Manager is On-Site

Clerks Managers name is MILLER and their Location is NEW YORK and the Manager is Off-Site
 
Clerks Managers name is MILLER and their Location is NEW YORK and the Manager is Off-Site 

Clerks Managers name is SCOTT and their Location is DALLAS and the Manager is On-Site
 



Question 2 - Bonuses

-----------------------------------------------------------------------------------------
 

The Salesmans is: ALLEN 
The Salesmans dept Id is: 30 
The Salesmans bonus is: 2096.65 
Employee BLAKE has a bonus of: 1661.05 which is lower than the department salesman 
Employee JAMES has a bonus of: 2216.77 which is higher than the department salesman 
Employee NORRIS has a bonus of: 2115.46 which is higher than the department salesman 

The Salesmans is: MARTIN 
The Salesmans dept Id is: 30 
The Salesmans bonus is: 2255.05 
Employee BLAKE has a bonus of: 1776.55 which is lower than the department salesman 
Employee JAMES has a bonus of: 2332.27 which is higher than the department salesman 
Employee NORRIS has a bonus of: 2230.96 which is lower than the department salesman

The Salesmans is: TURNER 
The Salesmans dept Id is: 30 
The Salesmans bonus is: 2096.65 
Employee BLAKE has a bonus of: 1694.05 which is lower than the department salesman 
Employee JAMES has a bonus of: 2249.77 which is higher than the department salesman 
Employee NORRIS has a bonus of: 2148.46 which is higher than the department salesman
  
The Salesmans is: WARD 
The Salesmans dept Id is: 30 
The Salesmans bonus is: 2326.99 
Employee BLAKE has a bonus of: 1776.55 which is lower than the department salesman 
Employee JAMES has a bonus of: 2332.27 which is higher than the department salesman 
Employee NORRIS has a bonus of: 2230.96 which is lower than the department salesman
Re: Formatting pl/sql output [message #231771 is a reply to message #231750] Wed, 18 April 2007 06:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As far I understand, the only difference is titles.
Just add:
dbms_output.put_line('my title');
dbms_output.put_line('--------');

I don't understand the purpose of your "dbms_output.put_line(chr(0));".

Use "BULK COLLECT" operation, you're currently programming like we programmed Oracle7.

Regards
Michel

Re: Formatting pl/sql output [message #231819 is a reply to message #231726] Wed, 18 April 2007 09:01 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
Why do you want to use dbms_output which has a number of limitations. See the following link.

http://download-east.oracle.com/docs/cd/B10501_01/server.920/a90842/ch7.htm#1005594
Re: Formatting pl/sql output [message #232162 is a reply to message #231726] Thu, 19 April 2007 12:28 Go to previous messageGo to next message
lilstrum
Messages: 8
Registered: April 2007
Junior Member
Right lets forget about the formatting.
I've just found out i've got the right answers but have done it completely the wrong way. I now need to create a function to calculate the bonus and then the procedure to use the bonus value. Can anyone help me out?
Thanks for your help
Re: Formatting pl/sql output [message #232164 is a reply to message #232162] Thu, 19 April 2007 12:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you think:
Quote:
create a function to calculate the bonus and then the procedure to use the bonus value

Is a real specification?
You have to tell us:
- What is the input
- What is the output (the bonus)
- What is the algorithm to get the latter from the former.

Regards
Michel
Re: Formatting pl/sql output [message #232165 is a reply to message #231726] Thu, 19 April 2007 12:58 Go to previous messageGo to next message
lilstrum
Messages: 8
Registered: April 2007
Junior Member
Right, so this is what I have to do

----------------------------------------------------------------
Write a macro containing a single anonymous pl/sql block which uses cursor processing to retreive rows from the SCOTT.EMP table, one by one, to perform both tasks as set out below

1/ Each time a ‘CLERK’ is found in a row call a procedure which outputs to the screen the name and office location of that clerk’s manager and indicate whether the manager is on-site or in a different location to the clerk

2/ Each time a ‘SALESMAN’ is encountered, call a different procedure which in turn uses a function to calculate a bonus payable to the salesman in question and everyone who is not a salesman in the same department

The bonus should be a function of 33% of the time of employment in days. Less their salary, less the salesman in question’s salary. A negative number indicates no bonus.

The procedure should print to the screen the employee’s name and bonus, if any; also indicate whether the employee’s bonus is larger or smaller than the salesman in question’s bonus.

----------------------------------------------------------------


Now, I have part 1/ correct but the problem is part 2 where I need to use a function to calculate the bonus as stated above.


Thanks
Lilstrum
Re: Formatting pl/sql output [message #232166 is a reply to message #232165] Thu, 19 April 2007 13:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As always put:
- create table statements
- insert statements
- the results you should have with the data you provided in the previous step (with the reason of these results)
- the Oracle version

Regards
Michel
Re: Formatting pl/sql output [message #232167 is a reply to message #231726] Thu, 19 April 2007 13:23 Go to previous messageGo to next message
lilstrum
Messages: 8
Registered: April 2007
Junior Member
Right, well we didnt create or insert but here are the results of SELECT * FROM for both tables


SCOTT.EMP
EMPNO  ENAME   JOB       MGR     HIREDATE  SAL   COMM  DEPTNO  
7369  SMITH    CLERK     7902   17-DEC-80  800   20  
7499  ALLEN    SALESMAN  7698   20-FEB-81  1600  300    30  
7521  WARD     SALESMAN  7698   22-FEB-81  1250  500    30  
7566  JONES    MANAGER   7839   02-APR-81  2975  500    20  
7654  MARTIN   SALESMAN  7698   28-SEP-81  1250  1400   30  
7698  BLAKE    MANAGER   7839   01-MAY-81  2850  1400   30  
7782  CLARK    MANAGER   7839   09-JUN-81  2450  1400   10  
7788  SCOTT    ANALYST   7566   19-APR-87  3000  1400   20  
7839  KING     PRESIDENT 7566   17-NOV-81  5000  1400   10  
7844  TURNER   SALESMAN  7698   08-SEP-81  1500  30  
7876  ADAMS    CLERK     7788   23-MAY-87  1100  20  
7900  JAMES    CLERK     7698   03-DEC-81  950   30  
7902  FORD     ANALYST   7566   03-DEC-81  3000  20  
7934  MILLER   CLERK     7782   23-JAN-82  1300  10  
7234  JUDGE    CLERK     7934   03-JUL-80  1100  20  
7198  NORRIS   CLERK     7934   21-OCT-81  1300  30  


16 rows selected.


SCOTT.DEPT
DEPTNO  DNAME        LOC  
10      ACCOUNTING   NEW YORK  
20      RESEARCH     DALLAS  
30      SALES        CHICAGO  
40      OPERATIONS   BOSTON  


Technically I am using Oracle 10g but currently am at home so using Isql
Re: Formatting pl/sql output [message #232172 is a reply to message #231726] Thu, 19 April 2007 13:39 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
Just curious, This is homework, isn't it?
Re: Formatting pl/sql output [message #232174 is a reply to message #231726] Thu, 19 April 2007 13:41 Go to previous messageGo to next message
lilstrum
Messages: 8
Registered: April 2007
Junior Member
yes it is a part of one of my units
Re: Formatting pl/sql output [message #232175 is a reply to message #232167] Thu, 19 April 2007 13:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And what would be the result with your data?

Regards
Michel
Re: Formatting pl/sql output [message #232178 is a reply to message #231726] Thu, 19 April 2007 13:48 Go to previous messageGo to next message
lilstrum
Messages: 8
Registered: April 2007
Junior Member
The results for my script as it is at the moment i presume?

Procedure created.

Procedure created.

Clerks Managers name is MILLER and their Location is NEW YORK and the Manager is Off-Site 
Clerks Managers name is MILLER and their Location is NEW YORK and the Manager is Off-Site 
Clerks Managers name is FORD and their Location is DALLAS and the Manager is On-Site 
Clerks Managers name is SCOTT and their Location is DALLAS and the Manager is On-Site 
Clerks Managers name is CLARK and their Location is NEW YORK and the Manager is On-Site 
Clerks Managers name is BLAKE and their Location is CHICAGO and the Manager is On-Site 
The Salesmans is: TURNER 
The Salesmans dept Id is: 30 
The Salesmans bonus is: 2097.09 
Employee BLAKE has a bonus of: 1694.49 which is lower than the department salesman 
Employee JAMES has a bonus of: 2250.21 which is higher than the department salesman 
Employee NORRIS has a bonus of: 2148.9 which is higher than the department salesman 
The Salesmans is: MARTIN 
The Salesmans dept Id is: 30 
The Salesmans bonus is: 2255.49 
Employee BLAKE has a bonus of: 1776.99 which is lower than the department salesman 
Employee JAMES has a bonus of: 2332.71 which is higher than the department salesman 
Employee NORRIS has a bonus of: 2231.4 which is lower than the department salesman 
The Salesmans is: WARD 
The Salesmans dept Id is: 30 
The Salesmans bonus is: 2327.43 
Employee BLAKE has a bonus of: 1776.99 which is lower than the department salesman 
Employee JAMES has a bonus of: 2332.71 which is higher than the department salesman 
Employee NORRIS has a bonus of: 2231.4 which is lower than the department salesman 
The Salesmans is: ALLEN 
The Salesmans dept Id is: 30 
The Salesmans bonus is: 2097.09 
Employee BLAKE has a bonus of: 1661.49 which is lower than the department salesman 
Employee JAMES has a bonus of: 2217.21 which is higher than the department salesman 
Employee NORRIS has a bonus of: 2115.9 which is higher than the department salesman 
PL/SQL procedure successfully completed.


So the first 6 lines are the results for part 1/
Re: Formatting pl/sql output [message #232182 is a reply to message #232178] Thu, 19 April 2007 13:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why MARTIN bonus is 2255.49?
I didn'tt really understand your formula of 33%...
Why BLAKE has multiple bonuses?

Regards
Michel
Re: Formatting pl/sql output [message #232191 is a reply to message #231726] Thu, 19 April 2007 14:40 Go to previous message
lilstrum
Messages: 8
Registered: April 2007
Junior Member
I'm not sure why his salary is that but the calculation needs to be 33% of the days Less their salary, less the salesman in question’s salary. I thought it was right???


varSalesBonus := ((sysdate - varHire - (2 * varSalesSalary)) *
0.33);
		
varOtherBonus:= ((((sysdate - varHire) - varSalesSalary) -
varSalary) * 0.33);


As for the Blake issue, it is not a problem because all the salesmen are in dept no 30 - its not a real business problem, its purely a pl/sql exercise.
Previous Topic: set that init.ora file(utl_file_dir).
Next Topic: Preventing sql statement echo at end of spool file
Goto Forum:
  


Current Time: Wed Dec 07 16:27:27 CST 2016

Total time taken to generate the page: 0.11999 seconds