Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

get not match information and update

959406Oct 4 2016 — edited Oct 4 2016

Hi

i have the scenario that to get the details for not match information and update as well..

can you please

details :

     1.Below mentioned the three table (IDENTIFY,TASK_INFO,PART_INFO) , based on these table to compare IDENTIFY (PART_ORG (COLUMN)
          in  UCTT,URTT Vs  TABLE(PART_INFO ) COLUM(URTT,UCTT) not match values only display below format . below table details information

     2. To update the party_info table based on IDENTIFY table .

input tables:

IDENTIFY
T_SIDPARTYPART_NUMPART_ORG
11100PARTYCSAN42CTT
11100PARTYRRAJ84RTT
11100PARTYSRAJ84STT
11100PARTYCSAN42UCTT
11100PARTYRRAJ84URTT
11101PARTYC1NAR42CTT
11101PARTYR1KUM84RTT
11101PARTYS1KUM84STT
11101PARTYC2GEE42UCTT
11101PARTYR2SUB84URTT
11102PARTYC2GEE42CTT
11102PARTYR2SUB84RTT
11102PARTYS2SUB84STT
11102PARTYC2GEE42UCTT
11102PARTYR2SUB84URTT
11103PARTYC3SAM42CTT
11103PARTYR3CCA84RTT
11103PARTYS3CCA84STT
11103PARTYC3SAM42UCTT
11103PARTYR3CCA84URTT

II -input table

 

TASK_INFO
T_SIDT_IDROW_DATE
111001114-Oct-16
111011114-Oct-16
111021124-Oct-16
111031134-Oct-16

3-Input tables

PART_INFO
T_IDURTTUCTT
111RAJ84SAN42
111KUM84NAR42
112GEE42GEE42
113SAM42SAM42

I-output format

  

OUTPUT   -display
T_IDURTTUCTTT_SIDPART_NUMPART_ORGSTATUS
112GEE42GEE4211102GEE42UCTT
112GEE42GEE4211102SUB84URTTWRONG
113SAM42SAM4211103SAM42UCTT
113SAM42SAM4211103CCA84URTTWRONG

II-output format

Output-Update
PART_INFO
T_IDURTTUCTT
111RAJ84SAN42
111KUM84NAR42
112GEE42SUB84
113SAM42CCA84

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2016
Added on Oct 4 2016
10 comments
365 views