Re: Oracle hints

["LANKE,RAVI-SANKAR (Non-A-Singapore,ex1)" <ravi-sankar_lanke2@NON.HP.COM>]

hi,

could u please be specific and attach the piece of code u are
using and getting bounced with errors.

u can use the distinct clause like the below example

begin-select distinct
col1
col2
from table_name order by col1
end-select

with best regards
ravi

 -----Original Message-----
From: Pietersz Mark x8938 [mailto:mpieters@CITIPOWER.COM.AU]
Sent: Friday, March 31, 2000 12:47 PM
To: SQR-USERS@list.iex.net
Subject: Oracle hints


Guys,

I'm going nuts.  I'm trying to put an oracle ordered hint in a BEGIN-SELECT
DISTINCT statement.  I have tried to look on the sqr users archive list but
the information was not consistent

the two methods suggested by the list are

BEGIN-SELECT --+ORDERED

BEGIN-SELECT /* +ORDERED */

I have also tried

BEGIN-SELECT
  /* +ORDERED */

None works for me.  They all typically produce "Bad param found on
begin-select line".

Also if I wish to use "distinct" with this where does the distinct go ?
"BEGIN-SELECT DISTINCT {HINT}" OR "BEGIN-SELECT {HINT} DISTINCT"

I am using SQRW 4.3.4 on NT 4.0 SP3 accessing Oracle 7.3.4.3.0.  Application
is PeopleSoft

Hope you can help

TIA

Mark Pietersz



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This email message has been swept for the presence of computer viruses.

CitiPower Pty ACN 064 651 056
**********************************************************************