Re: Question about insert and defaut values

Hi,

Within Oracle you simply do not specify the column in the insert statement. oe.

INSERT INTO TABLE ( NAME )
VALUES ( 'Any Name');

Hope this helps,
Andrew

Eugenio Reis wrote:

> Hi,
>
> Maybe this is a FAQ, but I'm coming from SQL Server and have a simple
> question:
>
> How to insert a default value?
>
> Example
>
> NAME VARCHAR2(40) NOT NULL
> AGE NUMBER(2) DEFAULT 0
>
> In SQL Server I could write
>
> INSERT INTO TABLE VALUES ( 'Any name', default )
>
> How can I do the same in Oracle?
>
> Thanks,
>
> Eugenio Reis
> ** Remove the primes to get the real e-mail
Received on Sat Mar 20 1999 - 23:50:39 CST