OraFAQ Forum: Test

Home » Other » Test » testing

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

testing [message #139588]

Wed, 28 September 2005 14:14

Ako1
Messages: 1
Registered: September 2005
Location: Texas (US)

Junior Member

testing!!!

Report message to a moderator

Re: testing [message #182715 is a reply to message #139588]

Mon, 17 July 2006 14:51

shumeric
Messages: 4
Registered: July 2006
Location: Chicago

Junior Member

SELECT rest_key,wrin,proposalamount,storeamount,orderdate

           FROM (SELECT /*+ INDEX(w) */

               	        'R'||LPAD(siteid,5,'0') rest_key,

        LPAD(wrinbase,6,'0')||LPAD(wrinsuffix,3,'0') wrin,

orderdate,
SUM(proposalamount) proposalamount,
SUM(storeamount) storeamount
FROM us_orderproposal_state@weblog
WHERE orderdate < TRUNC(SYSDATE) +1
AND orderdate > TRUNC(SYSDATE) - p_weblog_days_back
GROUP BY 'R'||LPAD(siteid,5,'0'),
LPAD(wrinbase,6,'0')||LPAD(wrinsuffix,3,'0'),orderdate);

Report message to a moderator

Re: testing [message #182716 is a reply to message #139588]

Mon, 17 July 2006 14:52

shumeric
Messages: 4
Registered: July 2006
Location: Chicago

Junior Member

SELECT rest_key,wrin,proposalamount,storeamount,orderdate
           FROM (SELECT /*+ INDEX(w) */ 
               	        'R'||LPAD(siteid,5,'0') rest_key,
               		    LPAD(wrinbase,6,'0')||LPAD(wrinsuffix,3,'0') wrin,
                        orderdate,
               		    SUM(proposalamount) proposalamount,
               		    SUM(storeamount) storeamount
               	 FROM us_orderproposal_state@weblog
           WHERE orderdate < TRUNC(SYSDATE) +1 
           AND   orderdate > TRUNC(SYSDATE) - p_weblog_days_back
           GROUP BY 'R'||LPAD(siteid,5,'0'),
               		LPAD(wrinbase,6,'0')||LPAD(wrinsuffix,3,'0'),orderdate);

Report message to a moderator

Previous Topic:	test post ...
Next Topic:	test

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 14:21:47 CST 2025