Re: Question about insert and defaut values

Thank you, but that's not the problem. The table already has the defaults, I just need to know if there's some equivalent to the word 'default' (from SQL Server) in Oracle.

On Mon, 22 Mar 1999 00:28:23 +0100, gorm_larsen_at_jyde.dk (Gorm Larsen) wrote:

>In article <36f44f54.520894_at_news.newsguy.com>, 11eugenio13_at_e-
>net.com.br says...
>> In SQL Server I could write
>>
>> INSERT INTO TABLE VALUES ( 'Any name', default )
>>
>> How can I do the same in Oracle?
>
>Is this what you want ?
>Alter table "scott"."emp" modify("sal", default 5000);
>
>--
>Gorm Larsen
>Hjælp til XAL og AxApta? Abonner på news.tadorna.dk

Eugenio Reis
** Please remove the prime numbers to get my real e-mail Received on Mon Mar 22 1999 - 07:04:01 CST