Calling SQL developers

[bongule]

[quote author=Pilloduuuuuu link=topic=156607.msg1857469#msg1857469 date=1297892150]
For auto Generated Primary Keys

Unlike most other databases, Oracle does not provide an auto-incrementing datatype that can be used to generate a sequential primary key value. However, the same effect can be achieved with a sequence and a trigger.

see this : [url=http://blog.lishman.com/2009/02/auto-generated-primary-keys-in-oracle.html]http://blog.lishman.com/2009/02/auto-generated-primary-keys-in-oracle.html[/url]
[/quote]
idhi munde choosa baa...anduke adigaanu...so sequence followed by trigger thappadu ga aithe  sHa_fr1ends

[pillabachapk]

[quote author=Nemo link=topic=156607.msg1857496#msg1857496 date=1297892521]
idhi munde choosa baa...anduke adigaanu...so sequence followed by trigger thappadu ga aithe  sHa_fr1ends
[/quote]
tappadu...bcoz oracle doesnt support that keyword constraints...

[bongule]

[quote author=manoghna link=topic=156607.msg1857419#msg1857419 date=1297891620]
hey for the 3 question

try this using CHECK CONSTARINT

ALTER TABLE (table name)
ADD CONSTRAINT (constarint name like cc_metasata_store what ever u like )
CHECK (metadata_store IN ('ETA', 'ETA_LEGACY', 'AIDW'));

hope it will work  sSa_j@il sSa_j@il
[/quote]
ee constraint null value allow chestundha ledha...because that column can have null value also

[nenuinthe]

Sorry for late reply..edo chinna meeting padindi.... nemo baa problem solved a??

[bongule]

[quote author=Ranga_The_Donga link=topic=156607.msg1857464#msg1857464 date=1297892079]
ayina nuvu JAVA kadha... SQL ki eppudu maravu...?? sCo_hmmthink sCo_hmmthink sCo_hmmthink
[/quote]
maa vaadu naakemem panulu istado vaadike eliyadhu baa em chestam  sFun_duh sFun_duh sFun_duh

[nenuinthe]

[quote author=tom cruise link=topic=156607.msg1857365#msg1857365 date=1297891143]
hallo bayya etta unnavv?????????
chala rojula tarvata.............
[/quote]hehe whatsup etta unnav...db ki ram ram cheppesanu baa [img]http://www.gifsoup.com/view2/1900792/8uulk-o.gif[/img]

[kollipara]

Use Identity keyword to autogenarate any column including primary key

[bongule]

[quote author=kollipara link=topic=156607.msg1857526#msg1857526 date=1297893002]
Use Identity keyword to autogenarate any column including primary key
[/quote]
ledhu dude its not working

[pillabachapk]

[quote author=kollipara link=topic=156607.msg1857526#msg1857526 date=1297893002]
Use Identity keyword to autogenarate any column including primary key
[/quote]
Identity SQL Server kada....Oracle lo work avvadu anukunta

[nenuinthe]

[quote author=Nemo link=topic=156607.msg1857546#msg1857546 date=1297893317]
ledhu dude its not working
[/quote]Identity SQL Server lone pani chestadi  sHa_fr1ends

[manoghna]

[quote author=Nemo link=topic=156607.msg1857518#msg1857518 date=1297892898]
ee constraint null value allow chestundha ledha...because that column can have null value also
[/quote] sCo_hmmthink sCo_hmmthink sCo_hmmthink
so a 3 values kakapothe null value tesukovala a column?
ithe default constraint with null kooda add cheyalemo a cloumn ki let me check...

[pillabachapk]

nemo oka solution cheptaa....i donno whether it will work first aa column create cheyiii....tarvata alter table script raayi...NULL allow chestuuu

[manoghna]

[quote author=Pilloduuuuuu link=topic=156607.msg1857571#msg1857571 date=1297893659]
nemo oka solution cheptaa....i donno whether it will work first aa column create cheyiii....tarvata alter table script raayi...NULL allow chestuuu
[/quote]Null allow chesthu how to write,,,NOT NULL ani mention cheyapothe default ga null ye kadha tesukuntadhi  sSa_j@il sSa_j@il

[pillabachapk]

[quote author=manoghna link=topic=156607.msg1857577#msg1857577 date=1297893751]
Null allow chesthu how to write,,,NOT NULL ani mention cheyapothe default ga null ye kadha tesukuntadhi  sSa_j@il sSa_j@il
[/quote]
yeah....but manam mundu only 3 values ichaaam kadaa....tarvata alter looo jus NULL ani pedite emanna workout autundemo anii sSa_j@il sSa_j@il

[bongule]

[quote author=BEZAWADA ROWDY link=topic=156607.msg1857521#msg1857521 date=1297892913]
Sorry for late reply..edo chinna meeting padindi.... nemo baa problem solved a??
[/quote]
trying baa...doubt vaste wil ask u  sHa_fr1ends