Welcome, Guest
Please Login or Register.    Lost Password?
SQLDeveloper Support Forums
Oracle Tool
Report bugs - DreamCoder for Oracle

query builder and KEEP (DENSE_RANK LAST ORDER BY
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: query builder and KEEP (DENSE_RANK LAST ORDER BY
#181
query builder and KEEP (DENSE_RANK LAST ORDER BY 1 Year, 5 Months ago Karma: 0  
When using the query builder in version 4.2.6.0 and 5.1

If I use KEEP (DENSE_RANK LAST ORDER BY

example:
Max(ct.ACTCODE) KEEP (DENSE_RANK LAST ORDER BY ct.CDATE, ct.ACTCODE) Max Action

the query builder throws an error, specifically says

Invalid SELECT statement.
Unexpected token "(" at line

this doesn't happen if I run the query in the SQL Editor.

Is there a fix for this?
jenna.booth@tpl.org (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2010/08/26 16:45 By jenna.booth@tpl.org.
The administrator has disabled public write access.
 
Go to topPage: 1
SQLDeveloper Support Forums
Oracle Tool
Report bugs - DreamCoder for Oracle
get the latest posts directly to your desktop

Why DreamCoder

DreamCoder is downloaded over 1 millions time and has accumulated over 10.000 happy customers from over 100 countries in the last 8 years.
Now we are the best database tools availabe 100% free in the world for Oracle , MySQL and PostgreSQL.

Community

SQLDeveloper support forums
Join our Community
and help us create better products
Home
Copyright © 2002-2012 Mentat Technologies Database Solutions, Inc. All rights reserved.