auto increment

Unlike MySQL, Oracle has not auto_increament attribute when you create a table. In MySQL, we can create table with auto increament column in simple way like this: [sourcecode lang=”plain”] CREATE TABLE test( id INT primary key auto_increment, name varchar(20) ); [/sourcecode] To insert a row into [cci]test[/cci] table, simply leave Read more…