Toad World® Forums

Sort on Editor|Data grid disabled


#1

Unable to sort the data grid if SELECT statement contains analitical function which has an ORDER BY tag.

See the following sample:

SELECT owner,
object_name,
object_id,
count (1) OVER (PARTITION BY owner ORDER BY 1) AS sorrend
FROM all_objects


#2

Can someone reproduce the error?


#3

Yes, I can. I can look at it for next release.

On 09/29/2015 01:53 PM, drbubo20 wrote:

RE: Sort on Editor|Data grid disabled

Reply by drbubo20
Can someone reproduce the error?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.


#4

Fixed for first 12.9 beta.

On 09/22/2015 03:02 PM, drbubo20 wrote:

Sort on Editor|Data grid disabled

Thread created by drbubo20
Unable to sort the data grid if SELECT statement contains analitical function which has an ORDER BY tag.

See the following sample:

SELECT owner,

   object_name,

   object_id,

   count (1) OVER (PARTITION BY owner ORDER BY 1) AS sorrend

FROM all_objects

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.