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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Aravind_L

This error message usually pops up when the Index cache and Data cache exceed the available memory.

Did you try lowering the data and index cache based on the block and page file size of the cube ?

3877802

Hi 2819644m

We are using Buffered I\O so we are concerned about data file cache.

We set the index cache value based on the size of the index files.

3877802

Hi All,

Oracle suggested us to place below mentioned setting in .cfg file for essbase.

_BYPASSMEMCHECKATDBINIT TRUE

I have updated this setting and tested and i didn't see the issue with index current cache value.

I am not able to find any information about this setting in oracle docs, Please let me know if you guys know more about this setting.

1 person found this helpful
1 - 3

Post Details

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