Re: Designer/2000 : Column Default USER is interpreted as 'USER'

I seem to remember the "Designer/2000 Handbook" saying to use ''||USER||'' or *something* like that, involving the NULL string (two ' characters) followed by the concatenation operator (||).

On 7 Oct 1997 20:29:37 GMT, "Manish Shah" <manish.shah_at_worldnet.att.net> wrote:
>Hi,
>
>I am using Designer/200 Rel 1.3.2 for Win NT 4.0.
>I am facing following problem
>1) Table Definition Related :
>Creating a table A in designer/2000 RON. Table A contains a column C with
>default value USER. Generate script shows,
>CREATE TABLE A
>( .............
> ..............
> C VARCHAR2(30) 'USER'
>...................
>) ;
>This means every time I ommit the value of column C, it inserts string
>'USER' in it. My requirement that it should generate the script like,
>CREATE TABLE A
>( .............
> ..............
> C VARCHAR2(30) USER
>...................
>) ;
>(No quotes for string USER )
>
>Does anyone know ????????
>
>Thanx in advance.
>
>Cheers,
>
>Manish Shah
Received on Thu Oct 09 1997 - 00:00:00 CEST