Select jenis_kelamin decode (l,laki-laki,p,perempuan,other).apa itu yg di maksud??.jadi ketika di dapati jenis kelamin l maka akan mencetak laki-laki,kalo p mencetak perempuan selain itu mencetak other??? Sent from my BlackBerry® smartphone from Sinyal Bagus XL, Nyambung Teruuusss...!
-----Original Message----- From: [email protected] Date: 18 Jul 2010 10:51:11 To: <[email protected]> Reply-To: "No Reply"<[email protected]> Subject: [indo-oracle] Digest Number 3218 Indonesia Oracle User Group Indonesia Oracle User Group <http://groups.yahoo.com/group/indo-oracle;_ylc=X3oDMTJkaDZzZm01BF9TAzk3MzU5NzE1BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNoZHIEc2xrA2hwaARzdGltZQMxMjc5NDUwMjY3> Messages In This Digest (1 Message) 1a. Re: Loop dalam SELECT From: Henry View All Topics <http://groups.yahoo.com/group/indo-oracle/messages;_ylc=X3oDMTJmZTRkZ3IyBF9TAzk3MzU5NzE1BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNkbXNnBHNsawNhdHBjBHN0aW1lAzEyNzk0NTAyNzE-?xm=1&m=p&tidx=1> | Create New Topic <http://groups.yahoo.com/group/indo-oracle/post;_ylc=X3oDMTJmOTZwMTgyBF9TAzk3MzU5NzE1BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNkbXNnBHNsawNudHBjBHN0aW1lAzEyNzk0NTAyNzE-> Message 1a. Re: Loop dalam SELECT <http://groups.yahoo.com/group/indo-oracle/message/24154;_ylc=X3oDMTJyaHE5dWRiBF9TAzk3MzU5NzE1BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBG1zZ0lkAzI0MTU0BHNlYwNkbXNnBHNsawN2bXNnBHN0aW1lAzEyNzk0NTAyNzE-> Posted by: "Henry" [email protected] <mailto:[email protected]?subject= Re%3A%20Loop%20dalam%20SELECT> Sat Jul 17, 2010 1:15 pm (PDT) Kenapa harus pakai Loop. dan kira2 mau ngapain nich? Ibaratnya ada cara cepet kenapa mikirin cara lama. thanks Agus Vinus wrote: > > Dear Suhu, > > Maaf saya masih newbie mo tanya, apa bisa sintak LOOP dimasukkan > didalam SELECT > seperti WHEN CASE, klo bisa kira2 bagaimana cara penulisannya?? > > Salam, > Agus V. > > [Non-text portions of this message have been removed] > > > > > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 9.0.839 / Virus Database: 271.1.1/3009 - Release Date: 07/16/10 > 02:35:00 > > Back to top Reply to sender <mailto:[email protected]?subject=re%3a%20loop%20dalam%20select> | Reply to group <mailto:[email protected]?subject= Re%3A%20Loop%20dalam%20SELECT> | Reply via web post <http://groups.yahoo.com/group/indo-oracle/post;_ylc=X3oDMTJyamJobG9mBF9TAzk3MzU5NzE1BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBG1zZ0lkAzI0MTU0BHNlYwNkbXNnBHNsawNycGx5BHN0aW1lAzEyNzk0NTAyNzE-?act=reply&messageNum=24154> Messages in this topic <http://groups.yahoo.com/group/indo-oracle/message/24153;_ylc=X3oDMTM3cGUxbWJiBF9TAzk3MzU5NzE1BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBG1zZ0lkAzI0MTU0BHNlYwNkbXNnBHNsawN2dHBjBHN0aW1lAzEyNzk0NTAyNzEEdHBjSWQDMjQxNTM-> (2) Recent Activity * 9 New Members <http://groups.yahoo.com/group/indo-oracle/members;_ylc=X3oDMTJmZ2ZlcmdlBF9TAzk3MzU5NzE1BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwN2dGwEc2xrA3ZtYnJzBHN0aW1lAzEyNzk0NTAyNzE-?o=6> Visit Your Group <http://groups.yahoo.com/group/indo-oracle;_ylc=X3oDMTJlNHQ2cnY0BF9TAzk3MzU5NzE1BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTI3OTQ1MDI3MQ--> Give Back Yahoo! for Good <http://us.lrd.yahoo.com/_ylc=X3oDMTJta2FmZmhoBF9TAzk3MzU5NzE1BF9wAzEEZ3JwSWQDMzIxMzIyNQRncnBzcElkAzE3MDUwMDcxODMEc2VjA25jbW9kBHNsawNicmFuZARzdGltZQMxMjc5NDUwMjY3;_ylg=1/SIG=11314uv3k/**http%3A//brand.yahoo.com/forgood> Get inspired by a good cause. Y! Toolbar Get it Free! <http://us.lrd.yahoo.com/_ylc=X3oDMTJvdXNjOHRkBF9TAzk3MzU5NzE1BF9wAzIEZ3JwSWQDMzIxMzIyNQRncnBzcElkAzE3MDUwMDcxODMEc2VjA25jbW9kBHNsawN0b29sYmFyBHN0aW1lAzEyNzk0NTAyNjc-;_ylg=1/SIG=11c6dvmk9/**http%3A//toolbar.yahoo.com/%3F.cpdl=ygrps> easy 1-click access to your groups. Yahoo! Groups Start a group <http://groups.yahoo.com/start;_ylc=X3oDMTJvOGhoaHBmBF9TAzk3MzU5NzE1BF9wAzMEZ3JwSWQDMzIxMzIyNQRncnBzcElkAzE3MDUwMDcxODMEc2VjA25jbW9kBHNsawNncm91cHMyBHN0aW1lAzEyNzk0NTAyNjc-> in 3 easy steps. Connect with others. Need to Reply? Click one of the "Reply" links to respond to a specific message in the Daily Digest. Create New Topic <http://groups.yahoo.com/group/indo-oracle/post;_ylc=X3oDMTJldDluanVwBF9TAzk3MzU5NzE1BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNmdHIEc2xrA250cGMEc3RpbWUDMTI3OTQ1MDI3MQ--> | Visit Your Group on the Web <http://groups.yahoo.com/group/indo-oracle;_ylc=X3oDMTJjYmduOGRvBF9TAzk3MzU5NzE1BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNmdHIEc2xrA2hwBHN0aW1lAzEyNzk0NTAyNzE-> Messages <http://groups.yahoo.com/group/indo-oracle/messages;_ylc=X3oDMTJlOGhuc2xvBF9TAzk3MzU5NzE1BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNmdHIEc2xrA21zZ3MEc3RpbWUDMTI3OTQ1MDI3MQ--> | Files <http://groups.yahoo.com/group/indo-oracle/files;_ylc=X3oDMTJmOGFobnM1BF9TAzk3MzU5NzE1BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNmdHIEc2xrA2ZpbGVzBHN0aW1lAzEyNzk0NTAyNzE-> | Photos <http://groups.yahoo.com/group/indo-oracle/photos;_ylc=X3oDMTJlczNmZHZjBF9TAzk3MzU5NzE1BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNmdHIEc2xrA3Bob3QEc3RpbWUDMTI3OTQ1MDI3MQ--> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com <http://groups.yahoo.com/;_ylc=X3oDMTJkb3RoNGxsBF9TAzk3MzU5NzE1BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMjc5NDUwMjcx> Change settings via the Web <http://groups.yahoo.com/group/indo-oracle/join;_ylc=X3oDMTJmMDR2M3ZzBF9TAzk3MzU5NzE1BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNmdHIEc2xrA3N0bmdzBHN0aW1lAzEyNzk0NTAyNzE-> (Yahoo! ID required) Change settings via email: Switch delivery to Individual <mailto:[email protected]?subject=email Delivery: Indiviual Email> | Switch format to Traditional <mailto:[email protected]?subject=change Delivery Format: Traditional> Visit Your Group <http://groups.yahoo.com/group/indo-oracle;_ylc=X3oDMTJkc3Q1MDRiBF9TAzk3MzU5NzE1BGdycElkAzMyMTMyMjUEZ3Jwc3BJZAMxNzA1MDA3MTgzBHNlYwNmdHIEc2xrA2hwZgRzdGltZQMxMjc5NDUwMjcx> | Yahoo! Groups Terms of Use <http://docs.yahoo.com/info/terms/> | Unsubscribe <mailto:[email protected]?subject=unsubscribe> <http://geo.yahoo.com/serv?s=97359715/grpId=3213225/grpspId=1705007183/msgId=3218/stime=1279450267/nc1=1/nc2=2/nc3=3> [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
