Sql........

[ilovekajal]

nenu oka table meedha sum chesthunnanu kani error ila vasthondhi [b]ORA-01722: invalid number[/b]
[b]sare ani table structutre choosanu and data kooda choosanu data emo number format loney undhi...........sarey anii to_number function use chesi chesanu aina same error[/b]


[b]help pls............ [/b]

[dkchinnari]

[img]http://25.media.tumblr.com/tumblr_m64n5z2XM21qawpudo1_250.gif[/img]

[pinky123]

the column on which you are doing a sum.. are you sure every single value in the column is a number.. even if a single row has none number for that column.. sql will throw this error..

[ilovekajal]

[quote name='pinky123' timestamp='1341410818' post='1302078442']
the column on which you are doing a sum.. are you sure every single value in the column is a number.. even if a single row has none number for that column.. sql will throw this error..
[/quote]

15 k rows unnayi............i think all values are numbers.............

[pinky123]

[quote name='ilovekajal' timestamp='1341411031' post='1302078449']

15 k rows unnayi............i think all values are numbers.............
[/quote]

aa table meeda "DESC" chesi table structure okkasari paste cheyagalava?

[king420]

[quote name='pinky123' timestamp='1341411133' post='1302078454']

aa table meeda "DESC" chesi table structure okkasari paste cheyagalava?
[/quote]
[img]http://www.desigifs.com/sites/default/files/2n1z39c.gif?1290164177[/img]

[king420]

Sum kaakunda ...String format derived column petti concatenation cheyyi avtundi [img]http://25.media.tumblr.com/avatar_6feb8634e3d0_128.png[/img]

[kiraaaak]

nee query inka table DESC paste chey ba oka sari

[Anbe_shivam1]

[quote name='HAPPYNESS' timestamp='1341411575' post='1302078470']
Sum kaakunda ...String format derived column petti concatenation cheyyi avtundi [img]http://25.media.tumblr.com/avatar_6feb8634e3d0_128.png[/img]
[/quote]

substri use chesi concatenation anthe ga vucle

[king420]

[quote name='Anbe_shivam1' timestamp='1341411755' post='1302078480']
substri use chesi concatenation anthe ga vucle
[/quote]
naaku SQL vachu anukuntunnav kada [img]http://25.media.tumblr.com/avatar_6feb8634e3d0_128.png[/img]

[Anbe_shivam1]

[quote name='HAPPYNESS' timestamp='1341411861' post='1302078484']
naaku SQL vachu anukuntunnav kada [img]http://25.media.tumblr.com/avatar_6feb8634e3d0_128.png[/img]
[/quote]

naaku raadu SQL andnduke adigina

[ilovekajal]

aa table data baase lo undi........

[Vivian_afdb]

[Anbe_shivam1]

[quote name='ilovekajal' timestamp='1341412053' post='1302078491']
aa table data baase lo undi........
[/quote]

DESC chesi.. oka sari screen shot teesi ikkada vey mama

[king420]

[quote name='ilovekajal' timestamp='1341412053' post='1302078491']
aa table data baase lo undi........
[/quote]
Table ante Data Base lone untadi.... Kitchen lo Dining Table kaadu