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

From: Jeff Jacobs <jmjacobs_at_ix.netcom.com>
Date: 1997/10/13
Message-ID: <344181a4.33406542_at_nntp.ix.netcom.com>#1/1


There isn't any direct way to do this in Designer; it understand "USER" for client side generated code, but the DDL generator doesn't recognize and treat it special.

You'll have to edit the file.

"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

-JJ

Visit our new website at http://www.jeffreyjacobs.com

 Jeffrey Jacobs & Associates
 Oracle Designer/2000 Consulting & Training  951-2 Old Country Road, Suite 119, Belmont, CA 94002  Voice: 650-571-1457, FAX: 800-665-1379
 Email: jmjacobs_at_ix.netcom.com
 Web: http://www.jeffreyjacobs.com

Don't miss the Oracle Development Tools User Group Conference in St. Louis, Nov. 2-5. See http://www.odtug.com for more information. Received on Mon Oct 13 1997 - 00:00:00 CEST

Original text of this message