PL/SQL IF loop question   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 July 23, 2007PL/SQL IF loop question Previous Next

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

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3143
Registered: 06-2004
Posted From: 65.196.167.82

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

Posted on Wednesday, July 18, 2007 - 3:23 pm:Edit PostDelete PostView Post/Check IP

bayata 80$ di 15$ ki vasthadi
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3142
Registered: 06-2004
Posted From: 65.196.167.82

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

Posted on Wednesday, July 18, 2007 - 3:22 pm:Edit PostDelete PostView Post/Check IP

maa office lo sale untundi lee
Top of pagePrevious messageNext messageBottom of pageLink to this message

Indiainfo
Celebrity Bewarse
Username: Indiainfo

Post Number: 13406
Registered: 03-2004
Posted From: 198.204.133.208

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

Posted on Wednesday, July 18, 2007 - 3:21 pm:Edit PostDelete PostView Post/Check IP

//madhyahnam edo kontaniki q lo nunchunte VP gadochi edo cheppi chesava annadu. //

ekkada q lo nunchunnavu...aa q daggareke mee VP vachada?
kothi ki kobbarikaya...pd chetiki MOD padavi..karma ra babu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Indiainfo
Celebrity Bewarse
Username: Indiainfo

Post Number: 13405
Registered: 03-2004
Posted From: 198.204.133.208

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

Posted on Wednesday, July 18, 2007 - 3:20 pm:Edit PostDelete PostView Post/Check IP

//ammani ani ucha kaarayi.gaba gaba adi sesaa. //


kothi ki kobbarikaya...pd chetiki MOD padavi..karma ra babu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3141
Registered: 06-2004
Posted From: 65.196.167.82

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

Posted on Wednesday, July 18, 2007 - 3:19 pm:Edit PostDelete PostView Post/Check IP

inkoka pedda twist entante aadu adigaka edo anukoni idena nuvvu adigindi ani adugudam ani aadi room daggaraki velthe aadu ledu. 2 times chosina ledu. undi unte naa doola naku theredi. help desk call emi vachindo koda theliyatam leda ani. edo VP and Senior VP level approval hierarchy lu change cheyyamani undi request. nenu chesesa ani cheppaka evadanna submit chesi undalsindi. doola mamuluga theri undedi kadu.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3140
Registered: 06-2004
Posted From: 65.196.167.82

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

Posted on Wednesday, July 18, 2007 - 3:13 pm:Edit PostDelete PostView Post/Check IP

ammani antha cinema unda, nenu already unna code madhyalo if lu peduthunna. elsif vaduthunnadu chivarlo oka endif esadu. correct gane undi kani meeru cheppevaraku aa vishayam theliyady. thanks babu and sok mamalu. ippude meeting nunchi vacha. madhyahnam edo kontaniki q lo nunchunte VP gadochi edo cheppi chesava annadu. enti anna. malla annadu. ardam kaala, bagodu ani chesa anna, ok anesi poyadu. basic ga vachina help desk call open cheyyaledu. ippudu vachi oorie soothe adi. ammani ani ucha kaarayi.gaba gaba adi sesaa.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Babu
Celebrity Bewarse
Username: Babu

Post Number: 12337
Registered: 06-2004
Posted From: 65.208.22.25

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

Posted on Wednesday, July 18, 2007 - 3:06 pm:Edit PostDelete PostView Post/Check IP

naaku adhe anipinchindi pt mama

hemu mama
babu garu
Top of pagePrevious messageNext messageBottom of pageLink to this message

420
Kurra Bewarse
Username: 420

Post Number: 2004
Registered: 12-2006
Posted From: 85.144.112.59

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

Posted on Wednesday, July 18, 2007 - 2:28 pm:Edit PostDelete PostView Post/Check IP

raanu raanu Questions' quality taagi pothundee
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 42799
Registered: 07-2004
Posted From: 162.136.192.1

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

Posted on Wednesday, July 18, 2007 - 2:25 pm:Edit PostDelete PostView Post/Check IP

yooo penkesh,enduku oka saari board oopings,malli kikis
school kelli sadavaledu 123....ninnu choosi nerchukunna 143
Top of pagePrevious messageNext messageBottom of pageLink to this message

420
Kurra Bewarse
Username: 420

Post Number: 2003
Registered: 12-2006
Posted From: 85.144.112.59

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

Posted on Wednesday, July 18, 2007 - 2:23 pm:Edit PostDelete PostView Post/Check IP

KiKi ..
Top of pagePrevious messageNext messageBottom of pageLink to this message

420
Kurra Bewarse
Username: 420

Post Number: 2002
Registered: 12-2006
Posted From: 85.144.112.59

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

Posted on Wednesday, July 18, 2007 - 2:22 pm:Edit PostDelete PostView Post/Check IP

Top of pagePrevious messageNext messageBottom of pageLink to this message

Symbol_of_king
Pilla Bewarse
Username: Symbol_of_king

Post Number: 320
Registered: 12-2005
Posted From: 198.182.163.125

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

Posted on Wednesday, July 18, 2007 - 2:19 pm:Edit PostDelete PostView Post/Check IP

<<<vaarni,intha swinema undhaaa>>.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 42793
Registered: 07-2004
Posted From: 162.136.192.1

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

Posted on Wednesday, July 18, 2007 - 2:13 pm:Edit PostDelete PostView Post/Check IP

ELSE IF aythe END IF pettali.............ELSIF aythe END IF avasaram ledu

vaarni,intha swinema undhaaa
school kelli sadavaledu 123....ninnu choosi nerchukunna 143
Top of pagePrevious messageNext messageBottom of pageLink to this message

Symbol_of_king
Pilla Bewarse
Username: Symbol_of_king

Post Number: 319
Registered: 12-2005
Posted From: 198.182.163.125

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

Posted on Wednesday, July 18, 2007 - 2:12 pm:Edit PostDelete PostView Post/Check IP

emi ledu manas.....gochi oka sql query cheppi ivala baga helping sesadu.....andukee naku telisindi edo chinnadi gochi confuse avuthuntee cheppataniki kasta paduthunnaaaaaaaa
Top of pagePrevious messageNext messageBottom of pageLink to this message

Maanas
Mudiripoyina Bewarse
Username: Maanas

Post Number: 6265
Registered: 08-2006
Posted From: 203.91.207.30

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

Posted on Wednesday, July 18, 2007 - 2:09 pm:Edit PostDelete PostView Post/Check IP

symbol goru full techinicals andi ee roju
Only Item in THEWORLD that will never hurt u is work.Love ur work,It will never hurt u like ur last girlfriend - churaech
Top of pagePrevious messageNext messageBottom of pageLink to this message

Symbol_of_king
Pilla Bewarse
Username: Symbol_of_king

Post Number: 318
Registered: 12-2005
Posted From: 198.182.163.125

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

Posted on Wednesday, July 18, 2007 - 2:08 pm:Edit PostDelete PostView Post/Check IP

gochi mama akkaddeee nuvvu confuse avuthunnavu.............ELSE IF aythe END IF pettali.............ELSIF aythe END IF avasaram ledu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Babu
Celebrity Bewarse
Username: Babu

Post Number: 12336
Registered: 06-2004
Posted From: 65.208.22.25

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

Posted on Wednesday, July 18, 2007 - 2:06 pm:Edit PostDelete PostView Post/Check IP

gochi mama
if statements untayi
simple if else

so ikkada if .... else....end if

inkoti (if) (else if) (else)
ikkada in between ennaina else if undocchu
final ga default case ki else use chestham

so enni chesina u need to close the whole if group with only endif or end if depending upon the language u use
babu garu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 42792
Registered: 07-2004
Posted From: 162.136.192.1

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

Posted on Wednesday, July 18, 2007 - 2:02 pm:Edit PostDelete PostView Post/Check IP

babu maayya,nuvvicchina nested ifelse lo sivarlo okate 'endif' ettavendi...multiple raava,ante enni elseif's unte anni endif's
school kelli sadavaledu 123....ninnu choosi nerchukunna 143
Top of pagePrevious messageNext messageBottom of pageLink to this message

Babu
Celebrity Bewarse
Username: Babu

Post Number: 12335
Registered: 06-2004
Posted From: 65.208.22.25

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

Posted on Wednesday, July 18, 2007 - 1:59 pm:Edit PostDelete PostView Post/Check IP

simple ee kadha hemu

simple if else ayithe
if cond1 then
statement1
else
statement2
end if;

if elsif else ayithe

if cond1 then
statement1
elsif cond2 then
statement2
elsif cond3 then
statement3
else
statement4
end if;

lopala enni ayina if lu ettuko nee istam
babu garu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Symbol_of_king
Pilla Bewarse
Username: Symbol_of_king

Post Number: 317
Registered: 12-2005
Posted From: 198.182.163.125

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

Posted on Wednesday, July 18, 2007 - 1:59 pm:Edit PostDelete PostView Post/Check IP

gochi mama nuvvu ichina link lo ELSE.. second 'IF' ki.. so anni END IF lu chivariki vachayyiii...kani hemu ki kavalisindi first IF ki ELSE.... so last lo oka END IF ee vastundi
Top of pagePrevious messageNext messageBottom of pageLink to this message

Symbol_of_king
Pilla Bewarse
Username: Symbol_of_king

Post Number: 316
Registered: 12-2005
Posted From: 198.182.163.125

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

Posted on Wednesday, July 18, 2007 - 1:55 pm:Edit PostDelete PostView Post/Check IP

as far as i understood what hemu wants is...

if..
{

if...
{

}

if...
{

}

}
else if(this if for the opening if)
{

}
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3139
Registered: 06-2004
Posted From: 65.196.167.82

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

Posted on Wednesday, July 18, 2007 - 1:52 pm:Edit PostDelete PostView Post/Check IP

chostha aagu gochi mama :-) nenu anukovatam nenu rasina lopala if ocnditions lopala values satify avvaka program dobbuthundi ani doubt. chostha mama.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3138
Registered: 06-2004
Posted From: 65.196.167.82

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

Posted on Wednesday, July 18, 2007 - 1:51 pm:Edit PostDelete PostView Post/Check IP

petta mama kakapothe ikkada aa final endif pettala endukante ala chala unnayi ani. sare ayiteh naa lopala logic thappu laga undi ayithe. chostha :-)

thanks mamalu.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 42788
Registered: 07-2004
Posted From: 162.136.192.1

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

Posted on Wednesday, July 18, 2007 - 1:50 pm:Edit PostDelete PostView Post/Check IP

emo SOK/Hemu maamas,meeru cheppindi naaku artham kaaledhu...indaaka nenu icchindi simple if else ki example code...eee kinda unna linklo nested If else statements,may be neeku ilaa kaavalemo hemu maama,soosi seppu...

http://www.java2s.com/Code/Oracle/PL-SQL/Usingnest edIFstatements.htm
school kelli sadavaledu 123....ninnu choosi nerchukunna 143
Top of pagePrevious messageNext messageBottom of pageLink to this message

Symbol_of_king
Pilla Bewarse
Username: Symbol_of_king

Post Number: 315
Registered: 12-2005
Posted From: 198.182.163.125

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

Posted on Wednesday, July 18, 2007 - 1:30 pm:Edit PostDelete PostView Post/Check IP

NUVVU RASINDI CORRECT EEE.....

IF or ELSE IF use chesinappudu END IF kavali..

ELSIF use chesinappudu end if avvasaram ledu ....so final ga bayata oka END IF peettu after the ELSIF statment...this END IF is for the opening IF
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3137
Registered: 06-2004
Posted From: 65.196.167.82

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

Posted on Wednesday, July 18, 2007 - 1:26 pm:Edit PostDelete PostView Post/Check IP

sok mama. ayithe nenu rasindi correctenaa??

gochi mama else vaadathanna kani IF lopala else lekunda inkoka if conditions kaavali naku. ante paina if satidfy ayyaka lopala inkonni if lu peduthunna.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Symbol_of_king
Pilla Bewarse
Username: Symbol_of_king

Post Number: 312
Registered: 12-2005
Posted From: 198.182.163.125

Rating:
Votes: 1(Vote!)

Posted on Wednesday, July 18, 2007 - 1:02 pm:Edit PostDelete PostView Post/Check IP

IF x=y and a=b THEN
abc := xyz;
IF loop
hsf := jsfh;
END IF;
IF loop
fjh := hjsf;
END IF;
ELSIF x = z and a = c THEN
......
END IF;
Top of pagePrevious messageNext messageBottom of pageLink to this message

Kodi_nbk
Mudiripoyina Bewarse
Username: Kodi_nbk

Post Number: 6023
Registered: 12-2005
Posted From: 59.93.94.197

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

Posted on Wednesday, July 18, 2007 - 1:01 pm:Edit PostDelete PostView Post/Check IP

--jai pokiri anu, debbaki code automatic ga populate avuthundi-------


ippudu jai athidhi fubar mama
Thretha Yuganiki Sri Ramudu Dvapara Yuganiki Sri Krishnudu Kali Yuganiki Nandamuri Tharaka Ramudu
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 42783
Registered: 07-2004
Posted From: 162.136.192.1

Rating:
Votes: 1(Vote!)

Posted on Wednesday, July 18, 2007 - 12:59 pm:Edit PostDelete PostView Post/Check IP

IF x=y and a=b THEN
abc := xyz;
IF .. THEN
hsf := jsfh;
ENDIF;
IF loop
fjh := hjsf;
ENDIF;
ELSIF x = z and a = c THEN


ilaa seyyakoodadhu,nenichina example lo soodu...

If <condition1>
then <statement1>
else
if <condition2>
then <statement2>
else<statement3>
end if;
end if;
school kelli sadavaledu 123....ninnu choosi nerchukunna 143
Top of pagePrevious messageNext messageBottom of pageLink to this message

Rediff
Mudiripoyina Bewarse
Username: Rediff

Post Number: 7730
Registered: 03-2004
Posted From: 209.12.236.10

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

Posted on Wednesday, July 18, 2007 - 12:59 pm:Edit PostDelete PostView Post/Check IP

>>naaku ENDIF lu ekkada pettalo theliyatam ledu. konchem cheppandi ela rayalo ee IF loop

IF end ayyechota ENDIF pettaali maayya
Drunk-O-Vision PS: updated on 07/15
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3136
Registered: 06-2004
Posted From: 65.196.167.82

Rating:
Votes: 1(Vote!)

Posted on Wednesday, July 18, 2007 - 12:57 pm:Edit PostDelete PostView Post/Check IP

nenu rasindi correcto kaado chodu mama.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 42782
Registered: 07-2004
Posted From: 162.136.192.1

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

Posted on Wednesday, July 18, 2007 - 12:56 pm:Edit PostDelete PostView Post/Check IP

end if's anni sivarloney vasthaayi....enni If Else lu use sesthe anni End If's sivarlo ettukovaali
school kelli sadavaledu 123....ninnu choosi nerchukunna 143
Top of pagePrevious messageNext messageBottom of pageLink to this message

Fubar
Kurra Bewarse
Username: Fubar

Post Number: 1027
Registered: 11-2006
Posted From: 192.44.136.113

Rating:
Votes: 1(Vote!)

Posted on Wednesday, July 18, 2007 - 12:56 pm:Edit PostDelete PostView Post/Check IP

jai pokiri anu, debbaki code automatic ga populate avuthundi
You've got to ask yourself one question: 'Do I feel lucky?' Well, do ya punk?
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3135
Registered: 06-2004
Posted From: 65.196.167.82

Rating:
Votes: 1(Vote!)

Posted on Wednesday, July 18, 2007 - 12:56 pm:Edit PostDelete PostView Post/Check IP

prasthutham naa code ila undi

IF x=y and a=b THEN
abc := xyz;
IF .. THEN
hsf := jsfh;
ENDIF;
IF loop
fjh := hjsf;
ENDIF;
ELSIF x = z and a = c THEN
Top of pagePrevious messageNext messageBottom of pageLink to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 42781
Registered: 07-2004
Posted From: 162.136.192.1

Rating:
Votes: 1(Vote!)

Posted on Wednesday, July 18, 2007 - 12:55 pm:Edit PostDelete PostView Post/Check IP

hemu maama, idigo example...

IF trans_type = 'CR' THEN
UPDATE accounts SET balance = balance + credit WHERE ...
ELSE
IF new_balance >= minimum_balance THEN
UPDATE accounts SET balance = balance - debit WHERE ...
ELSE
RAISE insufficient_funds;
END IF;
END IF;
school kelli sadavaledu 123....ninnu choosi nerchukunna 143
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3134
Registered: 06-2004
Posted From: 65.196.167.82

Rating:
Votes: 1(Vote!)

Posted on Wednesday, July 18, 2007 - 12:50 pm:Edit PostDelete PostView Post/Check IP

spaces icha kaani sarigga pani cheyyaledu ikkada post chesthaniki.

ardamaithe konchem cheppandi.
Top of pagePrevious messageNext messageBottom of pageLink to this message

Ravanabrahma
Yavvanam Kaatesina Bewarse
Username: Ravanabrahma

Post Number: 3133
Registered: 06-2004
Posted From: 65.196.167.82

Rating:
Votes: 1(Vote!)

Posted on Wednesday, July 18, 2007 - 12:49 pm:Edit PostDelete PostView Post/Check IP

naaku IF loop rastham ravatam ledu. evaranna help cheyyandi plz.

ila rayali

IF x=y and a=b THEN
abc := xyz;
ikkada inkoka IF loop
appudu hsf := jsfh;

ikkada inkoka IF loop
appudu fjh := hjsf;
ELSIF x = z and a = c THEN
.....


naaku ENDIF lu ekkada pettalo theliyatam ledu. konchem cheppandi ela rayalo ee IF loop.