Vu Pham wrote:
> "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1077659170.312353_at_yasure...
>
>>Vu Pham wrote:
>>
>>
>>>Two of the fields in my table are NAME CHAR(30) and SECTION CHAR(1)
>>>
>>
>>select keyword from v$reserved_words
>>where keyword like 'NA%';
>>
>
>
>
> Thanks, Daniel.
>
> I think you remind me that NAME is an Oracle keyword. Yes I forgot that - To
> be truth, I didn't know that - I am still new to Oracle ( I just learned
> that I need to connect as sysdba to execute the above sql ) .
>
> But here is what I just did on sqlplus
>
> SQL> create table tablea ( name char(30), section char(1), others numeric );
>
> Table created.
>
> SQL> desc tablea;
> Name Null? Type
> ----------------------------------------- -------- ------------------------
> ----
> NAME CHAR(30)
> SECTION CHAR(1)
> OTHERS NUMBER(38)
>
> SQL> insert into tablea values ( 'vu', 'a', 1 );
>
> 1 row created.
>
> SQL> select name,section from tablea;
>
> NAME S
> ------------------------------ -
> vu a
>
>
> But maybe in some SQL sentence that really uses the keyword NAME, then this
> column will cause conflict ? But then I can use TABLEA.NAME instead ?
>
>
> Vu
>
>
Better stop that - learn to create a user that uses it's own tablespace,
not SYSTEM (as "/ as sysdba" would)
--
Regards,
Frank van Bortel
Received on Fri Feb 27 2004 - 03:22:50 CST