Home » SQL & PL/SQL » SQL & PL/SQL » Convert Value to Percentage?
icon6.gif  Convert Value to Percentage? [message #184249] Tue, 25 July 2006 21:35 Go to next message
aimy
Messages: 209
Registered: June 2006
Senior Member
Hi all..

I have a table like this:

SNO TY TIMING
----- -- ----------
1001 01 10
1001 02 50
1001 03 30
1002 02 20
1002 03 60
1002 05 40
1003 05 50


What I want to do is that to select all those columns but for the timing column I want it to be displayed as a % of each SNO.

Meaning that, I have to sum all the timing by SNO and use that value to calculate the percentage.

i.e. (timing/sum(timing)) * 100

So how am I going to put this in a single SQL select statement?

Would that be possible??

Select SNO, TY, TIMING/SUM(TIMING)*100 "TIME_PCT"
from CUS_TEST;


As you can see, the problem is that I want the results as per TY but I need to sum the timing per SNO as well.. Sad

Please help me!!

The result should be like this:


SNO TY TIMING PCT
----- -- ---------- -----
1001 01 10 11.11
1001 02 50 55.56
1001 03 30 33.33
1002 02 20 16.67
1002 03 60 50.00
1002 05 40 33.33
1003 05 50 100.00


Thank you so much.. http://planet.time.net.my/KLCC/freekey/smilies/tq.gif

[Updated on: Tue, 25 July 2006 21:48]

Report message to a moderator

Re: Convert Value to Percentage? [message #184254 is a reply to message #184249] Tue, 25 July 2006 22:34 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Search the board for analytic functions, or check the Oracle doco for same.

Ross Leishman
Re: Convert Value to Percentage? [message #184270 is a reply to message #184254] Tue, 25 July 2006 23:43 Go to previous messageGo to next message
aimy
Messages: 209
Registered: June 2006
Senior Member
rleishman wrote on Wed, 26 July 2006 11:34

Search the board for analytic functions, or check the Oracle doco for same.

Ross Leishman

But which analytic function should I use??

I haven't found one.. Sad

Tq.
Re: Convert Value to Percentage? [message #184283 is a reply to message #184270] Wed, 26 July 2006 00:46 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Where did you search ???
It is the most commonly used analytic function .
Make better search before asking the next question. Evil or Very Mad

@ rleishman ,

Quote:

sorry , One more spoonfeeding ..


SQL> select * from test1;

       SNO TY     TIMING
---------- -- ----------
      1001 01         10
      1001 02         50
      1001 03         30
      1002 02         20
      1002 03         60
      1002 05         40
      1003 05         50

7 rows selected.

SQL> SELECT  SNO, TY, TIMING ,
  2  ROUND(
  3  TIMING/SUM(timing) OVER (PARTITION BY SNO ORDER BY NULL) *100,2
  4  ) pct
  5   FROM test1;

       SNO TY     TIMING        PCT
---------- -- ---------- ----------
      1001 01         10      11.11
      1001 02         50      55.56
      1001 03         30      33.33
      1002 02         20      16.67
      1002 03         60         50
      1002 05         40      33.33
      1003 05         50        100

7 rows selected.

SQL>


Rajuvan.

[Updated on: Wed, 26 July 2006 00:46]

Report message to a moderator

Re: Convert Value to Percentage? [message #184302 is a reply to message #184283] Wed, 26 July 2006 01:45 Go to previous messageGo to next message
aimy
Messages: 209
Registered: June 2006
Senior Member
rajavu1 wrote on Wed, 26 July 2006 13:46

Where did you search ???
It is the most commonly used analytic function .
Make better search before asking the next question. Evil or Very Mad

@ rleishman ,

Quote:

sorry , One more spoonfeeding ..



Rajuvan.

Hi Raju, Wink

1st of all, thanks a lot!!! It really works!! http://planet.time.net.my/KLCC/freekey/smilies/thumbsup.gifhttp://planet.time.net.my/KLCC/freekey/smilies/ok.gif

And secondly, I am so sorry for not be able to find the answer by myself.. Sad

Anyway, for your info.. I've came across to that function ROUND, OVER and PARTITION BY but I've never been taught about all this function before. So I really don't know how to manipulate those function in accordance to my case.

I've also tried the function RATIO_TO_REPORT since it seems to suit my needs but I just failed.. http://planet.time.net.my/KLCC/freekey/smilies/sad4.gif

SQL> select service_no, call_type, timing, ratio_to_report(timing) over (service_no) as test
from cus_test
group by service_no;
2 3 select service_no, call_type, timing, ratio_to_report(timing) over (service_no) as test
*
ERROR at line 1:
ORA-00907: missing right parenthesis


So I really hope you can understand.

Thanks again for helping. I really appreciate it. http://planet.time.net.my/KLCC/freekey/smilies/tq.gif

[Updated on: Wed, 26 July 2006 01:55]

Report message to a moderator

Re: Convert Value to Percentage? [message #184328 is a reply to message #184302] Wed, 26 July 2006 03:14 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Kudos to you for actually having a stab at another solution youself. You got the gist of the solution with Ratio_To_Report, but mised out the 'partition by' clause (See Analytic Functions here.

You also don't need to use a GROUP BY clause with Analytics - partition by perfoms a similar-ish role to group by, but onl applies to that function.

The solution you were looking for with Ratio_To_Report would look a lot like:

SQL> create table temp_timing (sno  number(4), ty  varchar(2), timing number(4));

Table created.

SQL> insert into temp_timing values(1001, '01', 10);
1 row created.
SQL> insert into temp_timing values(1001, '02', 50);
1 row created.
SQL> insert into temp_timing values(1001, '03', 30);
1 row created.
SQL> insert into temp_timing values(1002, '02', 20);
1 row created.
SQL> insert into temp_timing values(1002, '03', 60);
1 row created.
SQL> insert into temp_timing values(1002, '05', 40);
1 row created.
SQL> insert into temp_timing values(1003, '05', 50);
1 row created.

SQL> select sno
           ,ty
           ,round(ratio_to_report(timing) over (partition by sno),2) ratio_to_report
  2  from   temp_timing;

       SNO TY RATIO_TO_REPORT
---------- -- ---------------
      1001 01             .11
      1001 02             .56
      1001 03             .33
      1002 02             .17
      1002 03              .5
      1002 05             .33
      1003 05               1

7 rows selected.
Re: Convert Value to Percentage? [message #185053 is a reply to message #184328] Sun, 30 July 2006 14:10 Go to previous messageGo to next message
grk28
Messages: 38
Registered: June 2006
Member
Hi

Here is another possible way without using analytical functions.

Insert into TIMING
(SNO, QTY, TIMING)
Values
(1001, 1, 10);
Insert into TIMING
(SNO, QTY, TIMING)
Values
(1001, 2, 50);
Insert into TIMING
(SNO, QTY, TIMING)
Values
(1001, 3, 30);
Insert into TIMING
(SNO, QTY, TIMING)
Values
(1002, 2, 20);
Insert into TIMING
(SNO, QTY, TIMING)
Values
(1002, 3, 60);
Insert into TIMING
(SNO, QTY, TIMING)
Values
(1002, 5, 40);
Insert into TIMING
(SNO, QTY, TIMING)
Values
(1003, 5, 50);
COMMIT;

SELECT * FROM TIMING;

SNO QTY TIMING
---------- ---------- ----------
1001 1 10
1001 2 50
1001 3 30
1002 2 20
1002 3 60
1002 5 40
1003 5 50

7 rows selected.

Here is the query.

SELECT sno, qty,
TO_CHAR ((TIMING / (SELECT SUM (TIMING)
FROM TIMING
WHERE sno = a.sno
GROUP BY sno)) * 100, '9990.99') pct
FROM TIMING a

you can use To_Char or round depending on your requirement.


Output is as follows
--------------------------

SNO QTY PCT
---------- ---------- --------
1001 1 11.11
1001 2 55.56
1001 3 33.33
1002 2 16.67
1002 3 50.00
1002 5 33.33
1003 5 100.00

7 rows selected.

Experts please give me your feeback on the above query performance wise.

Thanks in Advance,
GRK



icon5.gif  Re: Convert Value to Percentage? [message #185649 is a reply to message #184249] Wed, 02 August 2006 20:13 Go to previous messageGo to next message
aimy
Messages: 209
Registered: June 2006
Senior Member
Hi again,

As an extension to this question, how do I output the above data to a more meaningful format like this:
	SNO	01	02	03	04	05
	----	-----	-----	-----	-----	------
	1001	11.11	55.56	33.33	0.00	0.00
	1002	0.00	16.67	50.00	0.00	33.33
	1003	0.00	0.00	0.00	0.00	100.00


Note: 01,02,03 etc are actually value of TY

Orginally the data can be extracted into this:
       SNO TY     TIMING        PCT
---------- -- ---------- ----------
      1001 01         10      11.11
      1001 02         50      55.56
      1001 03         30      33.33
      1002 02         20      16.67
      1002 03         60         50
      1002 05         40      33.33
      1003 05         50        100

So, would this be possible?? Please give me some hints and clues. Do I have to make use the DECODE function here?

Thank you so much for your cooperation.
icon9.gif  Re: Convert Value to Percentage? [message #185650 is a reply to message #184249] Wed, 02 August 2006 20:20 Go to previous messageGo to next message
aimy
Messages: 209
Registered: June 2006
Senior Member
I've found similar problem here: http://www.orafaq.com/forum/m/17340/86883/?srch=transform+rows+to+columns#msg_17340

But that one, the solution is to use the PL/SQL. Whereas I only need a script which make full use of the Oracle Reporting features.

Thank you.
icon9.gif  Re: Convert Value to Percentage? [message #185657 is a reply to message #184249] Wed, 02 August 2006 21:58 Go to previous messageGo to next message
aimy
Messages: 209
Registered: June 2006
Senior Member
Why I've got this error message??

S56KJA14:PAM> 
SELECT  service_no,
  2  sum(decode(call_type, '01', nvl(round(ratio_to_report(sum(timing)) over (partition by service_no)*100,2), 0), 0)) "01"
  3  FROM cus_test
  4  group by service_no
  5  order by service_no;
sum(decode(call_type, '01', nvl(round(ratio_to_report(sum(timing)) over (partition by service_no)*100,2), 0), 0)) "01"
                                                      *
ERROR at line 2:
ORA-00935: group function is nested too deeply



Actually my actual case is more complicated than I've posted before.

I will provide you all with the script soon.

Thanks for help.
icon6.gif  Re: Convert Value to Percentage? [message #185658 is a reply to message #184249] Wed, 02 August 2006 22:26 Go to previous messageGo to next message
aimy
Messages: 209
Registered: June 2006
Senior Member
This is the script file.

Tq.
Re: Convert Value to Percentage? [message #185675 is a reply to message #185658] Thu, 03 August 2006 01:03 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

You can try something like. .

SELECT  SERVICE_NO  ,
    NVL(SUM(DECODE(CALL_TYPE,'01', ratio)),0)"01",		
    NVL(SUM(DECODE(CALL_TYPE,'02', ratio)),0)"02",
    NVL(SUM(DECODE(CALL_TYPE,'03', ratio)),0)"03",
    NVL(SUM(DECODE(CALL_TYPE,'04', ratio)),0)"04",
    NVL(SUM(DECODE(CALL_TYPE,'05', ratio)),0)"05"
FROM (		
SELECT  SERVICE_NO ,CALL_TYPE,
		 ROUND(TIMING/SUM(timing) OVER (PARTITION BY SERVICE_NO ORDER BY NULL) *100,2) ratio
    FROM cus_test)
GROUP BY SERVICE_NO  


Thumbs Up
Rajuvan.
icon14.gif  Re: Convert Value to Percentage? [message #185681 is a reply to message #184249] Thu, 03 August 2006 01:46 Go to previous messageGo to next message
aimy
Messages: 209
Registered: June 2006
Senior Member
Thanks rajuvan!

It works! It's just that I wonder why the result is 60.07 for this particular row, sno = 1003, type = 02. It should be 60.08!
SERVI         01         02         03         04         05
----- ---------- ---------- ---------- ---------- ----------
1001          20         56         24          0          0
1002           0      16.67         50          0      33.33
1003           0      60.07          0          0      39.92
1004           0          0          0          0          0
1005       27.47      19.23          0      12.09      41.21

I've modified your script a little bit so that I will not get the ORA-01476: divisor is equal to zero error message.

SELECT SERVICE_NO ,
NVL(SUM(DECODE(CALL_TYPE,'01', ratio)),0)"01",
NVL(SUM(DECODE(CALL_TYPE,'02', ratio)),0)"02",
NVL(SUM(DECODE(CALL_TYPE,'03', ratio)),0)"03",
NVL(SUM(DECODE(CALL_TYPE,'04', ratio)),0)"04",
NVL(SUM(DECODE(CALL_TYPE,'05', ratio)),0)"05"
FROM (
SELECT SERVICE_NO, CALL_TYPE, ROUND(TIMING/SUM(decode(timing,0,NULL,timing)) OVER
(PARTITION BY SERVICE_NO ORDER BY NULL) *100,2) ratio FROM cus_test)
GROUP BY SERVICE_NO;


By the way, for your info I've also tried to get the result the other way around by making use the output of the previous question. I've converted the previous script to a view named bicus_v. So the code is like this

select service_no, 
sum(decode(call_type,'01',pct,0)) "01",
sum(decode(call_type,'02',pct,0)) "02",
sum(decode(call_type,'03',pct,0)) "03",
sum(decode(call_type,'04',pct,0)) "04",
sum(decode(call_type,'05',pct,0)) "05"
from bicus_v
group by service_no
order by service_no;
Re: Convert Value to Percentage? [message #185689 is a reply to message #185681] Thu, 03 August 2006 02:16 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Then Try like ...

SELECT SERVICE_NO ,
NVL(ROUND(SUM(DECODE(CALL_TYPE,'01', ratio)),2),0)"01", 
NVL(ROUND(SUM(DECODE(CALL_TYPE,'02', ratio)),2),0)"02",
NVL(ROUND(SUM(DECODE(CALL_TYPE,'03', ratio)),2),0)"03",
NVL(ROUND(SUM(DECODE(CALL_TYPE,'04', ratio)),2),0)"04",
NVL(ROUND(SUM(DECODE(CALL_TYPE,'05', ratio)),2),0)"05"
FROM (
SELECT SERVICE_NO, CALL_TYPE, TIMING/SUM(DECODE(timing,0,NULL,timing)) OVER 
       (PARTITION BY SERVICE_NO ORDER BY NULL) *100 ratio FROM cus_test)
GROUP BY SERVICE_NO; 


Thumbs Up
Rajuvan.
icon6.gif  Re: Convert Value to Percentage? [message #185691 is a reply to message #185689] Thu, 03 August 2006 02:26 Go to previous messageGo to next message
aimy
Messages: 209
Registered: June 2006
Senior Member
Thanks man!! Wink

Honestly, I don't really understand your script as a whole, it's quite complicated for me. Usually we only select from table but now it is select from (another select statement), http://forum.cari.com.my/images/smilies/stupid.gif

The only thing I know is that previously, the round function is taken care at the divisor level but now, it is executed on the result-side.
icon9.gif  Re: Convert Value to Percentage? [message #185697 is a reply to message #184249] Thu, 03 August 2006 02:51 Go to previous messageGo to next message
aimy
Messages: 209
Registered: June 2006
Senior Member
Rajavu,

I have another problem here.

s21tdi116:CUSPRD>
  1  select 
  2  B.SERVICE_NUM,
  3  sum(decode(A.hour_surr_key, 1, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 01",
  4  sum(decode(A.hour_surr_key, 2, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 02",
  5  sum(decode(A.hour_surr_key, 3, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 03",
  6  sum(decode(A.hour_surr_key, 4, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 04",
  7  sum(decode(A.hour_surr_key, 5, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 05",
  8  sum(decode(A.hour_surr_key, 6, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 06",
  9  sum(decode(A.hour_surr_key, 7, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 07",
 10  sum(decode(A.hour_surr_key, 8, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 08",
 11  sum(decode(A.hour_surr_key, 9, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 09",
 12  sum(decode(A.hour_surr_key, 10, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 10",
 13  sum(decode(A.hour_surr_key, 11, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 11",
 14  sum(decode(A.hour_surr_key, 12, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 12",
 15  sum(decode(A.hour_surr_key, 13, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 13",
 16  sum(decode(A.hour_surr_key, 14, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 14",
 17  sum(decode(A.hour_surr_key, 15, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 15",
 18  sum(decode(A.hour_surr_key, 16, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 16",
 19  sum(decode(A.hour_surr_key, 17, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 17",
 20  sum(decode(A.hour_surr_key, 18, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 18",
 21  sum(decode(A.hour_surr_key, 19, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 19",
 22  sum(decode(A.hour_surr_key, 20, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 20",
 23  sum(decode(A.hour_surr_key, 21, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 21",
 24  sum(decode(A.hour_surr_key, 22, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 22",
 25  sum(decode(A.hour_surr_key, 23, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 23",
 26  sum(decode(A.hour_surr_key, 24, round(sum(A.TOTAL_CALL_SECOND/60),2),0.00)) "Hour 24"
 27  from 
 28  CUS_CALL_USAGE_FACT A, RAS_CUST_HIERARCHY_SERVICE_DIM B 
 29  where
 30  (A.CALLER_CUST_HIERARCHY_SURR_KEY = B.SURR_KEY) AND (A.BILL_PERIOD_YEAR_MONTH = '200601')
 31  group by B.SERVICE_NUM
 32  order by B.SERVICE_NUM;


What's wrong with my query until I get this error:

B.SERVICE_NUM,
*

ERROR at line 2:
ORA-00937: not a single-group group function
Re: Convert Value to Percentage? [message #185703 is a reply to message #185697] Thu, 03 August 2006 03:22 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Try like ...

SELECT 
     B.SERVICE_NUM,
     ROUND(SUM(DECODE(A.hour_surr_key, 1, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 01",
     ROUND(SUM(DECODE(A.hour_surr_key, 2, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 02",
     ROUND(SUM(DECODE(A.hour_surr_key, 3, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 03",
     ROUND(SUM(DECODE(A.hour_surr_key, 4, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 04",
     ROUND(SUM(DECODE(A.hour_surr_key, 5, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 05",
     ROUND(SUM(DECODE(A.hour_surr_key, 6, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 06",
     ROUND(SUM(DECODE(A.hour_surr_key, 7, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 07",
    ROUND(SUM(DECODE(A.hour_surr_key, 8, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 08",
    ROUND(SUM(DECODE(A.hour_surr_key, 9, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 09",
    ROUND(SUM(DECODE(A.hour_surr_key, 10, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 10",
   ROUND(SUM(DECODE(A.hour_surr_key, 11, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 11",
    ROUND(SUM(DECODE(A.hour_surr_key, 12, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 12",
    ROUND(SUM(DECODE(A.hour_surr_key, 13, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 13",
    ROUND(SUM(DECODE(A.hour_surr_key, 14, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 14",
   ROUND(SUM(DECODE(A.hour_surr_key, 15, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 15",
    ROUND(SUM(DECODE(A.hour_surr_key, 16, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 16",
    ROUND(SUM(DECODE(A.hour_surr_key, 17, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 17",
    ROUND(SUM(DECODE(A.hour_surr_key, 18, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 18",
   ROUND(SUM(DECODE(A.hour_surr_key, 19, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 19",
   ROUND(SUM(DECODE(A.hour_surr_key, 20, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 20",
   ROUND(SUM(DECODE(A.hour_surr_key, 21, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 21",
   ROUND(SUM(DECODE(A.hour_surr_key, 22, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 22",
    ROUND(SUM(DECODE(A.hour_surr_key, 23, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 23",
    ROUND(SUM(DECODE(A.hour_surr_key, 24, A.TOTAL_CALL_SECOND/60,0.00)),2) "Hour 24"
    FROM 
   CUS_CALL_USAGE_FACT A, RAS_CUST_HIERARCHY_SERVICE_DIM B 
   WHERE
   (A.CALLER_CUST_HIERARCHY_SURR_KEY = B.SURR_KEY) AND (A.BILL_PERIOD_YEAR_MONTH = '200601')
   GROUP BY B.SERVICE_NUM
    ORDER BY B.SERVICE_NUM;


NB : Untested Code ..

Thumbs Up
Rajuvan.

[Updated on: Thu, 03 August 2006 03:26]

Report message to a moderator

icon14.gif  Re: Convert Value to Percentage? [message #185708 is a reply to message #185703] Thu, 03 August 2006 03:43 Go to previous message
aimy
Messages: 209
Registered: June 2006
Senior Member
It works!!

So many thanks to you Raju!! Cool
Previous Topic: null handling DBMS_XMLGEN
Next Topic: Oracle8i and UTL_HTTP
Goto Forum:
  


Current Time: Thu Dec 08 10:27:14 CST 2016

Total time taken to generate the page: 0.06723 seconds