Calling SQL developers

[kiraaaak]

[quote author=Pilloduuuuuu link=topic=156607.msg1857310#msg1857310 date=1297890614]
null allow cheyataaniki condition pettaala??? emi pettakapoina null allow chestundi kadaa
[/quote] @gr33d @gr33d sCo_hmmthink sCo_hmmthink

[pillabachapk]

[quote author=Nemo link=topic=156607.msg1857275#msg1857275 date=1297890349]
primary key okka column kosam kaadhu baa anni columns ki unnai chudu not null unique ani....nenu rasindhi correct ee na
[/quote]
[url=http://www.java2s.com/Tutorial/Oracle/0120__Table/Usethreecolumnsasprimarykey.htm]http://www.java2s.com/Tutorial/Oracle/0120__Table/Usethreecolumnsasprimarykey.htm[/url]

[bongule]

[quote author=BEZAWADA ROWDY link=topic=156607.msg1857299#msg1857299 date=1297890554]
naku Oracle syntax crrct ga teliyadu...sql server lo ithe metadata varchar(20) ani rasavu ga...metadata varchar(20) null ani kuda pettali null allow cheyyataniki....inka constraint add cheyyatam enduku nulls allow cheyyataniki...nenu anukunedi nuvvu anukunedi crrct ena  sCo_hmmthink sCo_hmmthink
[/quote]
emi ivvaka pothe null avuthundi default gaa....naa doubt the value goes into that column should be one of those three or it should null....ee constraint ela add cheyyali ani...


inkoti...nenu unique not null  ki query paina rasanu...dhani syntax correct ee na ani doubt ..meeru confirm cheyyandi

[nenuinthe]

[quote author=Pilloduuuuuu link=topic=156607.msg1857310#msg1857310 date=1297890614]
null allow cheyataaniki condition pettaala??? emi pettakapoina null allow chestundi kadaa
[/quote]yup allow chestadi...

[bongule]

[quote author=Ranga_The_Donga link=topic=156607.msg1857322#msg1857322 date=1297890705]
mooditki primary key combination i vvochu..

ITEM_TYPES (id number(5) primary key,

                  short_name varchar2(4) not null unique,

                  name varchar2(20) not null unique,

auto generated in ORACLE....may b sequence....

MINVALUE 1
START WITH 1
INCREMENT BY 1
[/quote]
AUTO_INCREMENT pani chestundhi ani chepthunnaru gaa baa...so adhi use chesta primay key kosam  sHa_fr1ends

[bevars__babu]

[quote author=BEZAWADA ROWDY link=topic=156607.msg1857330#msg1857330 date=1297890792]
yup allow chestadi...
[/quote]

hallo bayya etta unnavv?????????
chala rojula tarvata.............

[Ranga_The_Donga]

[quote author=Nemo link=topic=156607.msg1857359#msg1857359 date=1297891100]
AUTO_INCREMENT pani chestundhi ani chepthunnaru gaa baa...so adhi use chesta primay key kosam  sHa_fr1ends
[/quote] sHa_fr1ends sHa_fr1ends sHa_fr1ends

[bongule]

[quote author=Ranga_The_Donga link=topic=156607.msg1857387#msg1857387 date=1297891321]
sHa_fr1ends sHa_fr1ends sHa_fr1ends
[/quote] *7*^ *7*^
next two questions ki answer cheppu....easy anukunna...evvaru reply ivvatam ledhu  sCo_hmmthink

[manoghna]

[quote author=Nemo link=topic=156607.msg1857215#msg1857215 date=1297889942]
1..not null and unique rendu undali ante...nenu rasindhi correct eena

2..primay key should be auto generated..dhenni ela cheyyali
I mean sequence rasi cheyyala..leka any other methods unnaya
3. metadata-store column ki ee constraint add cheyyali nullable, one of (ETA, ETA_LEGACY, AIDW)
[/quote]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

[Ranga_The_Donga]

[quote author=Nemo link=topic=156607.msg1857397#msg1857397 date=1297891416]
*7*^ *7*^
next two questions ki answer cheppu....easy anukunna...evvaru reply ivvatam ledhu  sCo_hmmthink
[/quote]

meta data source null allow cheyakudadhu ante...Not null ani rayi..

allow cheyali ante .....just data type rasi vadiley...

not null unique rendu rayanavasaram ledhu anukunta..

vatiki primari ani icheyii.....

[pillabachapk]

[quote author=Nemo link=topic=156607.msg1857397#msg1857397 date=1297891416]
*7*^ *7*^
next two questions ki answer cheppu....easy anukunna...evvaru reply ivvatam ledhu  sCo_hmmthink
[/quote]
aa constraint ki idi add cheyii
CONSTRAINT metadata_name
  CHECK (metadata_name IN ('IBM', 'Microsoft', 'NVIDIA'));

[CheGuevara]

CREATE TABLE table_name
(column1 datatype not null,
column2 datatype not null,
...
CONSTRAINT constraint_name UNIQUE (column1, column2, . column_n)

CHECK (constraint_name IN(.....)
);

[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][quote author=Ranga_The_Donga link=topic=156607.msg1857427#msg1857427 date=1297891702]
meta data source null allow cheyakudadhu ante...Not null ani rayi..

allow cheyali ante .....just data type rasi vadiley...

not null unique rendu rayanavasaram ledhu anukunta..

vatiki primari ani icheyii.....
[/quote][quote author=Pilloduuuuuu link=topic=156607.msg1857429#msg1857429 date=1297891719]
aa constraint ki idi add cheyii
CONSTRAINT metadata_name
  CHECK (metadata_name IN ('IBM', 'Microsoft', 'NVIDIA'));
[/quote] thankyou  sHa_fr1ends sHa_fr1ends

[Ranga_The_Donga]

[quote author=Nemo link=topic=156607.msg1857452#msg1857452 date=1297891956]
thankyou  sHa_fr1ends sHa_fr1ends
[/quote]

ayina nuvu JAVA kadha... SQL ki eppudu maravu...?? sCo_hmmthink sCo_hmmthink sCo_hmmthink

[pillabachapk]

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]