Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Question about insert and defaut values

Re: Question about insert and defaut values

From: Gorm Larsen <gorm_larsen_at_jyde.dk>
Date: Mon, 22 Mar 1999 00:28:23 +0100
Message-ID: <MPG.115f9f043acb80a39896fe@1RELAX.DK>


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 Received on Sun Mar 21 1999 - 17:28:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US