smitakaushik

 Profile Answers by smitakaushik 

• Sep 18th, 2007

 

Hi!
    There are two ways to do it.
1. Go to design mode of a table. Click on a column to which you want to make auto genterted In its column Properties u will get Identity Specification. Select yes from here.
2 By query
CREATE TABLE TableNAme
(
   FieldName INT IDENTITY
)

gemini burj

 Profile Answers by gemini burj 

• Oct 23rd, 2007

 

I think this option is not available under oracle 9i database, is this option available avove than this version?

Sant_parkash

 Profile Answers by Sant_parkash Questions by Sant_parkash

• Nov 22nd, 2007

 

Create sequence test

update table1 set empid = test.nextval

mv_sivavardhan

 Profile Answers by mv_sivavardhan 

• Aug 6th, 2008

 

There are two ways to auto generate the values of a column in a table
1) Default value: we can set a default value to column definition
2) Identity value: we can set an identity value with initial value and increment value to column definition.