Re: MSSQL to ORACLE help

From: <tim.mcconechy_at_runtime.dk>
Date: Thu, 18 Mar 1999 12:01:41 GMT
Message-ID: <7cqpv2$ear$1@nnrp1.dejanews.com>

Maybe something like:
 CREATE TABLE categories (cat_id number(4) NOT NULL,

 has_parent number(1) DEFAULT 0,
 num_children number(4) DEFAULT 0,
 num_topics   number(4) DEFAULT 0,

   last_modified_on date DEFAULT SYSDATE,    cat_name varchar2(60) NOTNULL )

CREATE SEQUENCE categoriesseq start with 1; CREATE UNIQUE INDEX cat_nameidx ON categories ( cat_name);

CREATE CHECK CONSTRAINT...... Then do stuff like...
insert into categories(categoriesseq.nextval,1,2,2,SYSDATE,'ssss')

Skål!

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 18 1999 - 06:01:41 CST