Re: Pro*C - "NULLS FIRST" Compilation Error

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 5 Sep 2007 23:10:55 -0800
Message-ID: <46df99ef$1@news.victoria.tc.ca>

jerseycat10_at_gmail.com wrote:
: I am using this version of Pro*C: "Pro*C/C++: Release 10.2.0.1.0"

: When I use the following syntax:

: "ORDER BY t1.RELEASE_REASON ASC NULLS FIRST;"

Is that line supposed to have quotes "" around it? or is that just you quoting it for the post.

Perhaps a different syntax could be used in the sql, something like

order by decode(col, null, ' ', ' '||col)

(assuming a blank is smaller then anything else, otherwise use something else, perhaps chr(1) )

$0.10 Received on Thu Sep 06 2007 - 02:10:55 CDT