How to add column with out loosing da...   Independent houses near kukatpally | Apartments in Pragathi Nagar | AndhraVaani.com | Log Out | Topics | Search
Register | Edit Profile

Bewarse TalkArchives - 2007Cine Talk - Reviews, Gossips, Insider Info etc.Archive through August 14, 2007How to add column with out loosing data Previous Next

Author Message
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3805
Registered: 06-2004
Posted From: 68.119.182.67

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 5:31 pm:Edit PostDelete PostView Post/Check IP

Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 44482
Registered: 07-2004
Posted From: 71.234.247.143

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 5:30 pm:Edit PostDelete PostView Post/Check IP

emi server oo ela thelsukovali mama. naadi oracle server


Donate Blood Save Life ! Donate Eyes Live Twice
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3798
Registered: 06-2004
Posted From: 68.119.182.67

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 4:41 pm:Edit PostDelete PostView Post/Check IP



ippudu sesa. kiki.
Top of pagePrevious messageNext messageBottom of pageLink to this message

310
Pilla Bewarse
Username: 310

Post Number: 154
Registered: 12-2006
Posted From: 68.126.255.189

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 4:33 pm:Edit PostDelete PostView Post/Check IP

hemu mayya neevu oracle apps naa mayya table loki column eppudu add cheyyaleda
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3797
Registered: 06-2004
Posted From: 68.119.182.67

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 3:56 pm:Edit PostDelete PostView Post/Check IP

code changes koda chesesaa. inka kotha data vachaka test chesthamee
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3796
Registered: 06-2004
Posted From: 68.119.182.67

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 3:44 pm:Edit PostDelete PostView Post/Check IP

Oracle vaaduthunna kabatti oracle server ani seppa.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Srinu15
Kurra Bewarse
Username: Srinu15

Post Number: 1876
Registered: 08-2005
Posted From: 98.197.141.242

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 3:35 pm:Edit PostDelete PostView Post/Check IP

pda mama..
You never know what you can do, Until you try
Top of pagePrevious messageNext messageBottom of pageLink to this message

Pda
Celebrity Bewarse
Username: Pda

Post Number: 13628
Registered: 06-2006
Posted From: 71.33.42.186

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 3:34 pm:Edit PostDelete PostView Post/Check IP

//emi server oo ela thelsukovali mama. naadi oracle server
bemmam maya
Don't take any decisions when you are angry. Don't make any promises when you are happy.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3795
Registered: 06-2004
Posted From: 68.119.182.67

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 3:29 pm:Edit PostDelete PostView Post/Check IP

vaake mama, chesesaa. :-) ippudu code changes chesthunna :-)
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gotcha
Pilla Bewarse
Username: Gotcha

Post Number: 81
Registered: 01-2007
Posted From: 24.13.179.174

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 3:17 pm:Edit PostDelete PostView Post/Check IP

oracle anavu kada so oracle database ayi untundi. microsoft vadi database ayite "sql server".

so u ahve to use alter table script, easy ee net lo search kottu.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3794
Registered: 06-2004
Posted From: 68.119.182.67

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 3:14 pm:Edit PostDelete PostView Post/Check IP

emi server oo ela thelsukovali mama. naadi oracle server
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gotcha
Pilla Bewarse
Username: Gotcha

Post Number: 80
Registered: 01-2007
Posted From: 24.13.179.174

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 3:09 pm:Edit PostDelete PostView Post/Check IP

sql server ayite idi oka 2 minutes pani. anta UI to ayipotundi.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3793
Registered: 06-2004
Posted From: 68.119.182.67

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 2:46 pm:Edit PostDelete PostView Post/Check IP

ok view drop chesi create chestham emo le.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3792
Registered: 06-2004
Posted From: 68.119.182.67

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 2:45 pm:Edit PostDelete PostView Post/Check IP

view lo ela change cheyyali mama ippdu??
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3791
Registered: 06-2004
Posted From: 68.119.182.67

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 2:35 pm:Edit PostDelete PostView Post/Check IP

work ayyindi mama. kiki. chala thanks mama ila alter cheyyochani theliyadu. naalaga theliyani vallakosame ila thread vesanu nenu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Rediff
Mudiripoyina Bewarse
Username: Rediff

Post Number: 8151
Registered: 03-2004
Posted From: 71.86.125.171

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 2:30 pm:Edit PostDelete PostView Post/Check IP


Obeying SpeedLimit!! PS: updated on 08/11
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3790
Registered: 06-2004
Posted From: 68.119.182.67

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 2:25 pm:Edit PostDelete PostView Post/Check IP

thanks mama
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3789
Registered: 06-2004
Posted From: 68.119.182.67

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 2:24 pm:Edit PostDelete PostView Post/Check IP

yeh sethunna. kiki.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3788
Registered: 06-2004
Posted From: 68.119.182.67

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 2:24 pm:Edit PostDelete PostView Post/Check IP

nuvvu kathi mama. kiki.

alter table table_name add column_name data_type.

Top of pagePrevious messageNext messageBottom of pageLink to this message

Rediff
Mudiripoyina Bewarse
Username: Rediff

Post Number: 8149
Registered: 03-2004
Posted From: 71.86.125.171

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 2:23 pm:Edit PostDelete PostView Post/Check IP

alter table tableName add column columnName datatype;
Obeying SpeedLimit!! PS: updated on 08/11
Top of pagePrevious messageNext messageBottom of pageLink to this message

Rediff
Mudiripoyina Bewarse
Username: Rediff

Post Number: 8148
Registered: 03-2004
Posted From: 71.86.125.171

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 2:22 pm:Edit PostDelete PostView Post/Check IP

non-null ayite ganaka .. either default value option to create chesi next real-values populate cheyadam or new table create chesi data antaa add cheyadam ..
Obeying SpeedLimit!! PS: updated on 08/11
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3787
Registered: 06-2004
Posted From: 68.119.182.67

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 2:22 pm:Edit PostDelete PostView Post/Check IP

alter table anocha ?? aagu sootha
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3786
Registered: 06-2004
Posted From: 68.119.182.67

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 2:21 pm:Edit PostDelete PostView Post/Check IP

nullable mama.

table definision ela cheyyali?? table drop chesaa??
Top of pagePrevious messageNext messageBottom of pageLink to this message

Rediff
Mudiripoyina Bewarse
Username: Rediff

Post Number: 8147
Registered: 03-2004
Posted From: 71.86.125.171

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 2:17 pm:Edit PostDelete PostView Post/Check IP

aa kotha column nullable aa non-nullable aa??

nullable ayite just table definition change chesesi add cheseyochu ..
Obeying SpeedLimit!! PS: updated on 08/11
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3785
Registered: 06-2004
Posted From: 68.119.182.67

Rating:N/A
Votes: 0(Vote!)

Posted on Sunday, August 12, 2007 - 2:12 pm:Edit PostDelete PostView Post/Check IP

oka table ki kotha column add cheyyali, kani andulo unna data pokodadu. elaa??

backup table lo store chesi ee table drop chesi kotha table create chesi backup table lo data ni store cheyyocha??

chesthe elaa??

kotha table lo extra column untundi ga, syntax ela undali aa load ki