Re: DEFAULT

From: Tom Best <Tom.Best_at_bentley.com>
Date: Thu, 18 Nov 1999 13:11:06 -0500
Message-ID: <3834413A.510A5BFA@bentley.com>

Put "NOT NULL" clause last.

John Duran wrote:

> What is the correct syntax to enter a default value into a column when
> creating a table? The standard SQL call does not seem to work.
>
> Running Oracle 8.0.5 on Sun SPARC running Solaris 2.6
>
> PAY_METHOD VARCHAR2(2) NOT NULL DEFAULT 'OA' ,
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 18 1999 - 12:11:06 CST