tag:blogger.com,1999:blog-67703449306569552792024-02-08T09:31:02.667-08:00Programming BuzzThis is my first blog which related to programmings,language oriented notes etc.Updates info.of computer oriented languages etc.Payelhttp://www.blogger.com/profile/12689063918080169803noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6770344930656955279.post-27823655449832762482011-04-07T03:31:00.001-07:002011-04-07T03:31:59.181-07:00my first post<div dir="ltr" style="text-align: left;" trbidi="on">this is a trial post</div>Payelhttp://www.blogger.com/profile/12689063918080169803noreply@blogger.com0tag:blogger.com,1999:blog-6770344930656955279.post-31374482546747387932011-03-08T06:24:00.000-08:002011-03-08T06:24:44.581-08:00start demo<div dir="ltr" style="text-align: left;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://lh3.googleusercontent.com/-HlXQoeoBaSI/TXY6x1oFtLI/AAAAAAAAABg/9UkzwB6e4bg/s1600/Pink-Tulips.jpg" imageanchor="1" style="clear: right; cssfloat: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="150" q6="true" src="https://lh3.googleusercontent.com/-HlXQoeoBaSI/TXY6x1oFtLI/AAAAAAAAABg/9UkzwB6e4bg/s200/Pink-Tulips.jpg" width="200" /></a></div><em><span style="color: blue;">This is my first blogging site.Wait and see my post!!!</span></em><br />
<em><span style="color: blue;">first program:</span></em><br />
<div align="center" class="MsoNormal" style="margin: 0in 0in 0pt; text-align: center;"><b style="mso-bidi-font-weight: normal;">4.WRITE <street w:st="on"><address w:st="on">A PL</address></street>/SQL CODE BLOCKTHAT WILL DISPLAY THE SALESMAN NO.NAME,SALARY AMOUNT OF THE FIRST 5 SALESMEN GETTING THE HIGHEST SALARY.</b></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;">SQL> declare</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>2<span style="mso-spacerun: yes;"> </span>cursor s_det is select * from salesman32 where salary=(select max(salary) from salesman32);</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>3<span style="mso-spacerun: yes;"> </span>v_no salesman32.s_no%type;</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>4<span style="mso-spacerun: yes;"> </span>v_name salesman32.s_name%type;</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>5<span style="mso-spacerun: yes;"> </span>v_salary salesman32.salary%type;</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>6<span style="mso-spacerun: yes;"> </span>begin</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>7<span style="mso-spacerun: yes;"> </span>open s_det;</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>8<span style="mso-spacerun: yes;"> </span>if s_det % isopen then</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>9<span style="mso-spacerun: yes;"> </span>loop</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>10<span style="mso-spacerun: yes;"> </span>fetch s_det into v_no,v_name,v_salary;</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>11<span style="mso-spacerun: yes;"> </span>exit when s_det%rowcount>5 or s_det%notfound;</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>12<span style="mso-spacerun: yes;"> </span>dbms_output.put_line(v_no||'<span style="mso-spacerun: yes;"> </span>'||v_name||'<span style="mso-spacerun: yes;"> </span>'||v_salary);</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>13<span style="mso-spacerun: yes;"> </span>end loop;</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>14<span style="mso-spacerun: yes;"> </span>commit;</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>15<span style="mso-spacerun: yes;"> </span>else</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>16<span style="mso-spacerun: yes;"> </span>dbms_output.put_line('Unable to open');</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>17<span style="mso-spacerun: yes;"> </span>end if;</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>18<span style="mso-spacerun: yes;"> </span>close s_det;</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>19<span style="mso-spacerun: yes;"> </span>end;</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><span style="mso-spacerun: yes;"> </span>20<span style="mso-spacerun: yes;"> </span>/</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><b style="mso-bidi-font-weight: normal;"><u>OUTPUT: </u></b></div><div class="MsoNormal" style="margin: 0in 0in 0pt;"><br />
</div><div class="MsoNormal" style="margin: 0in 0in 0pt;">s004<span style="mso-spacerun: yes;"> </span>John<span style="mso-spacerun: yes;"> </span>47000</div><div class="MsoNormal" style="margin: 0in 0in 0pt;">s006<span style="mso-spacerun: yes;"> </span>Tobby<span style="mso-spacerun: yes;"> </span>47000</div><div class="MsoNormal" style="margin: 0in 0in 0pt;">s007<span style="mso-spacerun: yes;"> </span>Andrew<span style="mso-spacerun: yes;"> </span>47000</div><div class="MsoNormal" style="margin: 0in 0in 0pt;">s009 <span style="mso-tab-count: 1;"> </span><span style="mso-spacerun: yes;"> </span>Mac<span style="mso-spacerun: yes;"> </span><span style="mso-tab-count: 1;"> </span><span style="mso-spacerun: yes;"> </span>47000</div><div class="MsoNormal" style="margin: 0in 0in 0pt;">s010<span style="mso-spacerun: yes;"> </span>David<span style="mso-spacerun: yes;"> </span>47000</div></div>Payelhttp://www.blogger.com/profile/12689063918080169803noreply@blogger.com0