Question about insert and defaut values

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 - 19:48:05 CST