tag:blogger.com,1999:blog-2511702443521701494.post8920873264873569751..comments2024-03-06T10:13:35.368+05:30Comments on PLSQL in 21 Hours: CursorNaveenhttp://www.blogger.com/profile/01892407690516075293noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-2511702443521701494.post-79669196458340360302020-08-12T15:38:07.457+05:302020-08-12T15:38:07.457+05:30good program logic thanks for sharing oracle train...good program logic thanks for sharing <a href="https://infycletechnologies.com/oracle-training-in-chennai" rel="nofollow">oracle training in chennai</a>ramhttps://www.blogger.com/profile/14480656585026611026noreply@blogger.comtag:blogger.com,1999:blog-2511702443521701494.post-77775767832655910772017-05-18T15:18:18.280+05:302017-05-18T15:18:18.280+05:30(IN THIS PROGRAM ONE ERROR IS THERE .WHAT IS ERROR...(IN THIS PROGRAM ONE ERROR IS THERE .WHAT IS ERROR PLZ TELL ME )<br /> declare<br /> cursor lc is<br /> select ename,sal,deptno<br /> from emp<br /> for update;<br /> i lc%rowtype;<br /> begin<br /> display('the emp det are');<br /> display('empname'||''||'salary'||''||'deptnum');<br /> open lc;<br /> loop<br /> fetch lc into i;<br /> exit when lc%notfound;<br /> display(i.ename||''||i.sal||''||i.deptno);<br /> i.deptno=50 then<br /> delete from emp<br /> where current of lc;<br /> end if;<br /> end loop;<br /> close lc;<br /> display('after delete the 50th dept emps');<br /> open lc;<br /> loop;<br /> fetch lc into i;<br /> exit when lc%notfound;<br /> display(i.ename||''||i.sal||''||i.deptno);<br /> end loop;<br /> close lc;<br /> enD;<br />online addahttps://www.blogger.com/profile/09152703347900324053noreply@blogger.comtag:blogger.com,1999:blog-2511702443521701494.post-91964366635003683102015-06-09T17:34:56.827+05:302015-06-09T17:34:56.827+05:30Nice effert...!!!
You can also go through some mo...Nice effert...!!!<br /><br />You can also go through some more simple examples on cursor from below posts.<br />http://www.oracle-tf-world.in/2015/01/cursor-in-plsqlbasic-part-1.html<br />http://www.oracle-tf-world.in/2015/06/cursor-in-plsql-part-2.htmlAnonymoushttps://www.blogger.com/profile/06479877592557611172noreply@blogger.com