Calling SQL developers

[bongule]

Naaku oracle lo create table ki ddl rayadam lo help cheyyandi  *<:( *<:(

[htnamus]

[quote author=Nemo link=topic=156607.msg1857129#msg1857129 date=1297889317]
Naaku oracle lo create table ki ddl rayadam lo help cheyyandi  *<:( *<:(
[/quote]
create table veasy e kada baa

create table tablename (varname vartype, ....)

[kiraaaak]

ltt

[bongule]

[quote author=HS link=topic=156607.msg1857141#msg1857141 date=1297889433]
create table veasy e kada baa

create table tablename (varname vartype, ....)
[/quote]
nenu column names and constraint cheptha unta aa rakam gaa aa statement ni modify chey baa...neeku kooda manchi time faas avuthundi...please  sHa_fr1ends sHa_fr1ends sHa_fr1ends

[htnamus]

[quote author=Nemo link=topic=156607.msg1857155#msg1857155 date=1297889496]
nenu column names and constraint cheptha unta aa rakam gaa aa statement ni modify chey baa...neeku kooda manchi time faas avuthundi...please  sHa_fr1ends sHa_fr1ends sHa_fr1ends
[/quote]tuch ledu kaani ivvu try chesta ..actualy ikad post chey ..evaro okalu ans cheptaremo ..

[ramyak]

[quote author=Nemo link=topic=156607.msg1857129#msg1857129 date=1297889317]
Naaku oracle lo create table ki ddl rayadam lo help cheyyandi  *<:( *<:(
[/quote]

[url=http://www.w3schools.com/sql/default.asp]http://www.w3schools.com/sql/default.asp[/url]

[bongule]

[quote author=HS link=topic=156607.msg1857162#msg1857162 date=1297889539]
tuch ledu kaani ivvu try chesta ..actualy ikad post chey ..evaro okalu ans cheptaremo ..
[/quote]
primary key value auto generate cheyyali ante, sequence rasi intial value assign cheyyadam oka methoda aithe, by default ade assign cheyyadaniki emaina methods unnaya

[bongule]

ee query ni konchem modify cheyyali baa help cheyyandi konchem

create table ITEM_TYPES (id number(5) primary key,

                  short_name varchar2(4) not null unique,

                  name varchar2(20) not null unique,

                  description varchar2(200) not null,

                  contains_images  varchar2(1) not null,

                  metadata_store  varchar2(15),

                  deprecation_date date,

          decommission_date date);

[nenuinthe]

[quote author=Nemo link=topic=156607.msg1857181#msg1857181 date=1297889684]
ee query ni konchem modify cheyyali baa help cheyyandi konchem

create table ITEM_TYPES (id number(5) primary key,

                  short_name varchar2(4) not null unique,

                  name varchar2(20) not null unique,

                  description varchar2(200) not null,

                  contains_images  varchar2(1) not null,

                  metadata_store  varchar2(15),

                  deprecation_date date,

          decommission_date date);
[/quote]modify ante em cheyyali  sCo_hmmthink sCo_hmmthink

[canny surya]

*=: *=: *=: *=:

[ramyak]

[quote author=Nemo link=topic=156607.msg1857181#msg1857181 date=1297889684]
ee query ni konchem modify cheyyali baa help cheyyandi konchem

create table ITEM_TYPES (id number(5) primary key,

                  short_name varchar2(4) not null unique,

                  name varchar2(20) not null unique,

                  description varchar2(200) not null,

                  contains_images  varchar2(1) not null,

                  metadata_store  varchar2(15),

                  deprecation_date date,

          decommission_date date);
[/quote]

correst ga ne undiga baa????

[chotu gadu]

vese prathi post ki 10 bucks avuddi...deal ok aithe seppu  #~` #~` #~`

[htnamus]

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

[Ranga_The_Donga]

modification seppu....ela kavali ani anukuntunavuu..... *7*^ *7*^ *7*^

[bongule]

[quote author=BEZAWADA ROWDY link=topic=156607.msg1857195#msg1857195 date=1297889793]
modify ante em cheyyali  sCo_hmmthink sCo_hmmthink
[/quote]
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)