About Oracle ?

[Anon]

hello all.
I must use Oracle with my job,but I don't know How to deal with the Function when Insert a new record The ID will automatically add 1 . the same as "auto_increment" on MySQL :
CREATE TABLE demo (
id int(5) DEFAULT '0' NOT NULL auto_increment,
news_conren text,
PRIMARY KEY (id)
);

thanks.

[Anon]

For autonumbering, Oracle uses something called sequences. Initiate a sequence with the following command:

CREATE SEQUENCE seq_name START WITH 1;

the start with 1 is implicit and not required, however, you can have it start with 678 if you like. Now, to get the next value, you do a:

SELECT seq_name.nextval FROM dual;

dual is just a dummy table, and you can use this as a nested select inside of an insert. Hope that helps.

Chris King

[Anon]

I know a little about the Oracle!!!
so I hope you give me a example,OK ? thanks.

create table demo(id varchar2(5),news varchar2(200) );

What should I do now ?