OraFAQ Forum: Reports & Discoverer » Very interesting query which uses LONG datatype column in the query

Home » Developer & Programmer » Reports & Discoverer » Very interesting query which uses LONG datatype column in the query

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

Very interesting query which uses LONG datatype column in the query [message #171874]

Thu, 11 May 2006 23:26

amankhan
Messages: 69
Registered: December 2005
Location: Texas

Member

Hi guys,

Heres an interesting query. This query uses a column which is of LONG datatype. The query works fine. But the query returns duplicate values. So I tried to use DISTINCT or GROUP BY to supress the duplicate values. it gives an error saying ILLEGAL USE OF LONG COLUMN.....

Heres the query:

select alerts.ALERT_NAME, usr.USER_NAME, action.SUBJECT,
alerts.ENABLED_FLAG, action.TO_RECIPIENTS, action.CC_RECIPIENTS, alerts.SQL_STATEMENT_TEXT
from ALR_ACTIONS action, alr_alerts alerts, fnd_user usr
where action.ALERT_ID = alerts.ALERT_ID
and alerts.LAST_UPDATED_BY = usr.USER_ID
and (alerts.LAST_UPDATE_DATE > trunc(sysdate) - 30 or action.LAST_UPDATE_DATE > trunc(sysdate) - 30)

SQL_STATEMENT_TEXT is a LONG datatype.

Help Appreciated. How can i supress duplicates rows from this query.

Thanks

I need to create a report which should not display duplicate rows.

Report message to a moderator

Previous Topic:	Discoverer software for self-study CDs
Next Topic:	report6i in arabic

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 02:23:28 CDT 2024