Calling SQL developers

[bongule]

[quote author=chotu gadu link=topic=156607.msg1857208#msg1857208 date=1297889886]
vese prathi post ki 10 bucks avuddi...deal ok aithe seppu  #~` #~` #~`
[/quote] Dr@w@ Dr@w@

[chotu gadu]

[quote author=HS link=topic=156607.msg1857211#msg1857211 date=1297889922]
transferred @3$%
[/quote]post veyaka mundhe transferred aaa  @3$% @3$% @3$%

[chotu gadu]

[quote author=Nemo link=topic=156607.msg1857222#msg1857222 date=1297889974]
Dr@w@ Dr@w@
[/quote]thammudu thammude, pekata pekate...ittanti matters lo asalu thaggaru...eee panikosam mee officelo velaku velu mingatla  @3$% @3$%

[nenuinthe]

[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]sql server lo auto incerement ki identity ani vadochu...Oracle lo em untadi  sCo_hmmthink

[pillabachapk]

[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]
AUTO_INCREMENT ivvu primary key kiii...automatic ga increase autundi....

[bongule]

[quote author=BEZAWADA ROWDY link=topic=156607.msg1857239#msg1857239 date=1297890103]
sql server lo auto incerement ki identity ani vadochu...Oracle lo em untadi  sCo_hmmthink
[/quote][quote author=Pilloduuuuuu link=topic=156607.msg1857241#msg1857241 date=1297890137]
AUTO_INCREMENT ivvu primary key kiii...automatic ga increase autundi....
[/quote] thankyou what abt other 2 questions  sHa_fr1ends

[htnamus]

sql lo aite auto increment pedtunde mari ..oracle lo kuda undemo!!

[pillabachapk]

PRIMARY KEY ani iste automatic ga unique autundi,.....NOT NULL iste not null condition satisfy autunfii....

[Ranga_The_Donga]

not null +unique=Primary,.....

rendu assign chese badhulu....

primary ani dirct ga ivvu....

increment ki i think int IDENTITY() ani ivvochuu......

[bongule]

[quote author=Pilloduuuuuu link=topic=156607.msg1857264#msg1857264 date=1297890288]
PRIMARY KEY ani iste automatic ga unique autundi,.....NOT NULL iste not null condition satisfy autunfii....
[/quote]
primary key okka column kosam kaadhu baa anni columns ki unnai chudu not null unique ani....nenu rasindhi correct ee na

[bongule]

[quote author=Ranga_The_Donga link=topic=156607.msg1857269#msg1857269 date=1297890309]
not null +unique=Primary,.....

rendu assign chese badhulu....

primary ani dirct ga ivvu....

increment ki i think int IDENTITY() ani ivvochuu......
[/quote]
ee table ki okate primay key baa..migilina konni columns...not null as well as unique

[nenuinthe]

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

[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]
not null kavalante NOT NULL....unique kavalante UNIQUE ani ivvatamee

[pillabachapk]

[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]
null allow cheyataaniki condition pettaala??? emi pettakapoina null allow chestundi kadaa

[Ranga_The_Donga]

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