Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Oracle DISCOVERER question

Oracle DISCOVERER question

From: andrey <bronfin_at_visualtop.com>
Date: Mon, 4 Dec 2000 19:37:54 +0200
Message-Id: <10700.123542@fatcity.com>


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 :

  1. Would U please redirect me to a similar list dealing with Oracle Discoverer stuff , so i will not bother this list again :-)
  2. I have a table THE_TAB with fields REGISTRATION_DATE , REGISTRATION_STATUS . I need to translate the following sqL*Plus report to an Oracle discoverer report :

 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>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D286172417-04122000>1) =
Would U please=20
redirect me to a similar list&nbsp;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)&nbsp; 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>&nbsp;&nbsp;&nbsp;&nbsp; I need to translate = the=20
following sqL*Plus&nbsp;report to an Oracle discoverer report=20 :</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D286172417-04122000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D286172417-04122000>&nbsp;break on=20 REGISTRATION_DATE </SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D286172417-04122000></SPAN></FONT>&nbsp;</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>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D286172417-04122000></SPAN></FONT>&nbsp;</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>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D286172417-04122000></SPAN></FONT>&nbsp;</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>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D286172417-04122000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN class=3D286172417-04122000>Andrey =
Received on Mon Dec 04 2000 - 11:37:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US