Re: Display all the records from table using cursor
Posted by:
kaji Pasa
Date: September 25, 2017 02:00PM
master table is repository to make the mapping (match) of such incorrect records we know that will happen,and consider those to be match.so in master table if i have dog=cat and master.cc=0
What i am trying to say is ,
if b.title_sci=b.title, then we get cc=0
if b.title_sci<>b.title
then we have to see the master
if in master this m.title_sci is dog and for the same row m.title= cat then this is match as per the master(a way we say this is match though the column doesnt match in base table ).Hence i need to update cc for this row in the base table to zero which indicates this is a match.
Subject
Views
Written By
Posted
3817
September 22, 2017 06:21PM
760
September 22, 2017 07:46PM
786
September 22, 2017 10:11PM
704
September 25, 2017 09:07AM
704
September 25, 2017 11:17AM
645
September 25, 2017 11:15AM
755
September 25, 2017 12:49PM
600
September 25, 2017 01:18PM
562
September 25, 2017 01:36PM
Re: Display all the records from table using cursor
557
September 25, 2017 02:00PM
549
September 25, 2017 03:51PM
622
September 25, 2017 06:24PM
578
September 26, 2017 01:34PM
592
September 26, 2017 01:56PM
514
September 26, 2017 02:22PM
625
September 26, 2017 03:35PM
592
September 27, 2017 10:28AM
653
September 27, 2017 11:39AM
614
September 26, 2017 12:43PM
586
September 26, 2017 01:27PM
571
September 26, 2017 01:44PM
638
September 25, 2017 01:46PM
694
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.