Re: Display all the records from table using cursor
Posted by:
kaji Pasa
Date: September 27, 2017 10:28AM
Here the ID 44 row should not be present as the b.cc>0 is selected to create the table. For suppose this is the case then the requirement will be
if b.cc==0 or b.cc=m.cc then
do nothing
else if
b.cc<> 0 then
set b.cc=m.cc
end if
So the row 53 will be updated as
b.cc=m.cc(i.e after update we get b.cc=3) instead of its current value b.cc=1
my another confusion here is :
The master table is just the same records of base except it can have some variation in m.cc value.
for all the b.cc<>0 we make a temp table and from manual inspection we update or set the value of m.cc. That means if the b.title <> b.title_sci (also corresponding issn from base does not match ) then cc>0 in base so we analyse the title and title_sci in temp table and set the cc to be either 0 or 1 or 2 and push this in master as a repository,So for the next run we use this table to check instead of manual inspection for b.cc<> 0.
My point here is we have all the same rows and same columns for base and master expect cc values. So the join on (title,title_sci,issn1,issn2,issn,eissn ) should give the same number of rows as we have in base report. select count(*) from base_report give 145 rows.
but the join from ur post gives few records.
We have some missing rows from the base_report.
Subject
Views
Written By
Posted
4169
September 22, 2017 06:21PM
936
September 22, 2017 07:46PM
969
September 22, 2017 10:11PM
845
September 25, 2017 09:07AM
824
September 25, 2017 11:17AM
781
September 25, 2017 11:15AM
893
September 25, 2017 12:49PM
810
September 25, 2017 01:18PM
712
September 25, 2017 01:36PM
702
September 25, 2017 02:00PM
705
September 25, 2017 03:51PM
828
September 25, 2017 06:24PM
727
September 26, 2017 01:34PM
781
September 26, 2017 01:56PM
688
September 26, 2017 02:22PM
794
September 26, 2017 03:35PM
Re: Display all the records from table using cursor
728
September 27, 2017 10:28AM
841
September 27, 2017 11:39AM
799
September 26, 2017 12:43PM
764
September 26, 2017 01:27PM
725
September 26, 2017 01:44PM
839
September 25, 2017 01:46PM
838
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.