Sql Help Kaavaali Chaala Simple Jara Ochhi Chusi Answer Cheppunri

[chelsea]

chary garu instr is Pl/sql function slqserver lo char index use cheyyali

[goli soda]

[quote name='lolliman' timestamp='1349374030' post='1302581903']

golikaya etlunnav??
[/quote]
[img]http://lh6.ggpht.com/-DUcF-Vl9sRQ/UGD9ApRDU-I/AAAAAAAAHb8/1Pppqj3ONZM/s150/Brahmi-1.gif[/img] manchigunna kani....kaya endhi vayya.... soda analigani....

[goli soda]

[quote name='chelsea' timestamp='1349375256' post='1302582067']
chary garu instr is Pl/sql function slqserver lo char index use cheyyali
[/quote]
xzactly......

[charygaru]

[quote name='chelsea' timestamp='1349375256' post='1302582067']
chary garu instr is Pl/sql function slqserver lo char index use cheyyali
[/quote]

thanks mama nenu ade pareshaan aythunna ee instr endi ra ayya ani eppudu chudale not that i know everything in sql but i thogut that was something i dint know .

[deals2buy]

[quote name='charygaru' timestamp='1349375632' post='1302582105']
thanks mama nenu ade pareshaan aythunna ee instr endi ra ayya ani eppudu chudale not that i know everything in sql but i thogut that was something i dint know .
[/quote]


exactly naaku bhi ade anipinchindi

[charygaru]

[quote name='padmasri123' timestamp='1349374963' post='1302582032']


instr('ID',0,-1) this gives the POSITION of the 0 in ID and -1 represents the position count starts from last character.

substr('ID',instr('ID',0,-1)) != 0 ---> this gives the value of the instr which not equals to zero.
[/quote]

but mama naaku position of 0 kaadu kaavalansinddhi only last position lo 0 unte aa record eliminate avvali result set nuchi anthe. anduke nee complex query naaku ardham kaale and nenu cheppindi neeku ardham kaale anukunte for being vague

[chelsea]

[quote name='charygaru' timestamp='1349375632' post='1302582105']
thanks mama nenu ade pareshaan aythunna ee instr endi ra ayya ani eppudu chudale not that i know everything in sql but i thogut that was something i dint know .
[/quote]

NP chary garu ayyina meru ippudu BA kada malli Sql DBA job vachinadi meku

[padmasri123]

[quote name='charygaru' timestamp='1349375699' post='1302582113']
but mama naaku position of 0 kaadu kaavalansinddhi only last position lo 0 unte aa record eliminate avvali result set nuchi anthe. anduke nee complex query naaku ardham kaale and nenu cheppindi neeku ardham kaale anukunte for being vague
[/quote]


ade chargaru akkada chesindi last character 0 value kosame -1 use chesanu instr lo...anywayz meeku ans vachindi kada no prob..

[karna11]

CG enti inka raledhaaaa,, koncham itu pm sesukoo raka potheeee

[c3x]

idi use chey Chary work aithadi...

DROP TABLE <Table Name>

[chelsea]

[quote name='padmasri123' timestamp='1349375788' post='1302582124']


ade chargaru akkada chesindi last character 0 value kosame -1 use chesanu instr lo...anywayz meeku ans vachindi kada no prob..
[/quote]


nuvu cheppinadi koda correct kani adi kocham complex ga vunnadi maku anthe

[charygaru]

[quote name='chelsea' timestamp='1349375749' post='1302582117']
NP chary garu ayyina meru ippudu BA kada malli Sql DBA job vachinadi meku
[/quote]

nenu BA ne mama kaani sql lo select statements use cheyyalsi osthundi konni ids kanukoni vaatilo secondry level numbers ni veru chesi raka rakala scenarios test cheyyali aa process lo primary id raakunda chudataniki last lo 0 unde numbers eliminate cheyyali le anduke ee question.

[quote name='padmasri123' timestamp='1349375788' post='1302582124']

ade chargaru akkada chesindi last character 0 value kosame -1 use chesanu instr lo...anywayz meeku ans vachindi kada no prob..
[/quote]

naaku answer ochhinda leda anedi important kadu mama nuvvu cheppina solution nenu adigina question ki saripothada leda annadi naaku telvatam importtant anthe. nuvvu cheppinadi vinnaka naaku em ardham ayyindi ante aa id number lo ekkada 0 unte akkada nuncchi position -1 ki ( imean aa zero mundu ki) osthadi anukunna

[charygaru]

[quote name='karna11' timestamp='1349375872' post='1302582131']
CG enti inka raledhaaaa,, koncham itu pm sesukoo raka potheeee
[/quote]

ochhesindi mama just aa mama ichhina query ni ardham chesukoniki try chesthunna.

[lolliman]

[quote name='goli soda' timestamp='1349375287' post='1302582070']
[img]http://lh6.ggpht.com/-DUcF-Vl9sRQ/UGD9ApRDU-I/AAAAAAAAHb8/1Pppqj3ONZM/s150/Brahmi-1.gif[/img] manchigunna kani....kaya endhi vayya.... soda analigani....
[/quote]

sare uncle [img]http://lh6.ggpht.com/-DUcF-Vl9sRQ/UGD9ApRDU-I/AAAAAAAAHb8/1Pppqj3ONZM/s150/Brahmi-1.gif[/img].... db ki ravalte sarigaaa

[charygaru]

[quote name='c3x' timestamp='1349375874' post='1302582132']
idi use chey Chary work aithadi...

DROP TABLE <Table Name>
[/quote]

claps kottanbiki chethulu kaali lev gaani tarvatha kanipinchu