Re: How to ensure column names are double quoted while using execute format when building a stored procedure?

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

On 12/16/21 14:11, David G. Johnston wrote:
> On Thu, Dec 16, 2021 at 3:04 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx 
> <mailto:adrian.klaver@xxxxxxxxxxx>> wrote:
>
>
>     This:
>
>     'count of nulls in "UNIQUE_REFERENCE_NUMBER"'
>
>     is just plain incorrect syntax.
>
>
> <single quote>count of nulls in <double 
> quote>UNIQUE_REFRENCE_NUMBER<double quote><single quote>
>
> That is not invalid syntax.  It is just literal single quoted text - the 
> double quotes are simply characters in the string.

Alright I took it to be what followed:

count("""UNIQUE_REFERENCE_NUMBER""").

Now I see it is a tag for the count.

> David J.


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx