Re: Display all the records from table using cursor
Posted by:
kaji Pasa
Date: September 22, 2017 10:11PM
I need to update the table A column A.a based on the value of a particular column from another table B column B.a .So i am trying to fetch all the rows from A (but now i am getting only first row), check if the value of the column A.a falls in the condition to update or not. If the column value needs to be updated, the update that column else move to next row.
For this requirement i am trying to create the cursor.
Subject
Views
Written By
Posted
3930
September 22, 2017 06:21PM
808
September 22, 2017 07:46PM
Re: Display all the records from table using cursor
828
September 22, 2017 10:11PM
738
September 25, 2017 09:07AM
736
September 25, 2017 11:17AM
679
September 25, 2017 11:15AM
789
September 25, 2017 12:49PM
655
September 25, 2017 01:18PM
596
September 25, 2017 01:36PM
595
September 25, 2017 02:00PM
595
September 25, 2017 03:51PM
681
September 25, 2017 06:24PM
606
September 26, 2017 01:34PM
625
September 26, 2017 01:56PM
552
September 26, 2017 02:22PM
665
September 26, 2017 03:35PM
622
September 27, 2017 10:28AM
699
September 27, 2017 11:39AM
661
September 26, 2017 12:43PM
638
September 26, 2017 01:27PM
603
September 26, 2017 01:44PM
676
September 25, 2017 01:46PM
728
September 25, 2017 12:56PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.