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!

compare two columns and print only the difference

RengudiDec 6 2022 — edited Dec 7 2022

Hi Gurus
Good day to you.
I want to compare two column values print only difference of two;

Sample data

SELECT 'bru-ie-03.jocko.com' AS c1, 'bru-ie-03.jocko.com' AS c2 FROM DUAL
UNION ALL
SELECT 'bru-5508-08.jocko.com', 'bsv-6248-2.jocko.com' FROM DUAL
UNION ALL
SELECT 'sjc-ravikara-2-11188.tiny.com', 'sjc-rajkakka-2-11188.tiny.com'
  FROM DUAL
UNION ALL
SELECT 'sjc-tonyleu-1-11187.iopkl.com', 'sjc-hwen-nitro7.iopkl.com' FROM DUAL
UNION ALL
SELECT 'resin.finding.com', 'resin.find ing.com' FROM DUAL;

Expected output:-

SELECT 'bru-ie-03.jocko.com' AS c1,'bru-ie-03.jocko.com' AS c2,'NO Diff' AS Differnce_C1_from_C2,'NO Diff' AS Differnce_C2_from_C1 FROM dual
UNION ALL
SELECT 'bru-5508-08.jocko.com','bsv-6248-2.jocko.com','bru-5508-08','bsv-6248-2' FROM dual
UNION ALL
SELECT 'sjc-ravikara-2-11188.tiny.com','sjc-rajkakka-2-11188.tiny.com','ravikara','rajkakka' FROM dual
UNION ALL
SELECT 'sjc-tonyleu-1-11187.iopkl.com','sjc-hwen-nitro7.iopkl.com','tonyleu-1-11187','hwen-nitro7' FROM dual
UNION ALL
SELECT 'resin.finding.com','resin.find ing.com','finding','find ing' FROM dual;

+-------------------------------+-------------------------------+----------------------+----------------------+
| c1                            | c2                            | Differnce C1 from C2 | Differnce C2 from C1 |
+===============================+===============================+======================+======================+
| bru-ie-03.jocko.com           | bru-ie-03.jocko.com            | NO Diff              | NO Diff              |
+-------------------------------+-------------------------------+----------------------+----------------------+
| bru-5508-08.jocko.com         | bsv-6248-2.jocko.com          | bru-5508-08          | bsv-6248-2           |
+-------------------------------+-------------------------------+----------------------+----------------------+
| sjc-ravikara-2-11188.tiny.com | sjc-rajkakka-2-11188.tiny.com | ravikara             | rajkakka             |
+-------------------------------+-------------------------------+----------------------+----------------------+
| sjc-tonyleu-1-11187.iopkl.com | sjc-hwen-nitro7.iopkl.com     | tonyleu-1-11187      | hwen-nitro7          |
+-------------------------------+-------------------------------+----------------------+----------------------+
| resin.finding.com             | resin.find ing.com            | finding              | find ing             |
+-------------------------------+-------------------------------+----------------------+----------------------+

Comments

Processing

Post Details

Added on Dec 6 2022
#plsql, #sql
10 comments
671 views
4 mentions