SQL Cursor limitations?
Darren Reely
darren.reely at latticesemi.com
Wed Aug 17 13:30:43 CDT 2005
Whittall, Conrad wrote:
> PowerHouse uses only ANSI-SQL, not any particular database vendor's
> flavour. The ANSI SQL substring function is SUBSTRING, not SUBSTR. For
> example,
>
> SUBSTRING(x FROM 1 FOR 12)
That is important to understand. Even though SUBSTRING() can't be used
in Oracle's SQLPlus (version 8.1), it does work in Quiz.
Thanks for the tip Conrad, and the timing.
Darren
More information about the powerh-l
mailing list