Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Oracle DISCOVERER question
This is a multi-part message in MIME format.
------=_NextPart_000_0011_01C05E29.B2158A00 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Dear All !
Sorry for this off-topic , just have nobody else to ask .
2 things :
break on REGISTRATION_DATE
select to_char(REGISTRATION_DATE,'DD-MON-YY'), REGISTRATION_STATUS ,
count(REGISTRATION_STATUS )
from THE_TAB
group by to_char(REGISTRATION_DATE,'DD-MON-YY'), REGISTRATION_STATUS ;
Could U please tell me how can i do that .
TIA . Andrey .
------=_NextPart_000_0011_01C05E29.B2158A00 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D286172417-04122000>Dear =
All=20
!</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D286172417-04122000>Sorry =
for this=20
off-topic , just have nobody else to ask .</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D286172417-04122000>2 =
things :=20
</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D286172417-04122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D286172417-04122000>1) =
Would U please=20
redirect me to a similar list dealing with Oracle Discoverer stuff =
, so i=20
will not bother this list again :-) </SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D286172417-04122000>2) I have a=20
table THE_TAB with fields REGISTRATION_DATE , REGISTRATION_STATUS=20
.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D286172417-04122000> I need to translate =
the=20
following sqL*Plus report to an Oracle discoverer report=20
:</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D286172417-04122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D286172417-04122000> break on=20
REGISTRATION_DATE </SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D286172417-04122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D286172417-04122000>select =
to_char(REGISTRATION_DATE,'DD-MON-YY'), REGISTRATION_STATUS ,=20
count(REGISTRATION_STATUS )<BR>from THE_TAB </SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D286172417-04122000>group =
by=20
to_char(REGISTRATION_DATE,'DD-MON-YY'), REGISTRATION_STATUS=20
;</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D286172417-04122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D286172417-04122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D286172417-04122000>Could =
U please tell=20
me how can i do that .</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D286172417-04122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D286172417-04122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D286172417-04122000>TIA=20
.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D286172417-04122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D286172417-04122000></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D286172417-04122000>Andrey =
Received on Mon Dec 04 2000 - 11:37:54 CST
![]() |
![]() |