PL/SQL (MOSC)

MOSC Banner

how to remove space in the column while comparing column values

edited Nov 11, 2015 10:03AM in PL/SQL (MOSC) 8 commentsAnswered

Hello,

I am using a query to compare kernel values like below:

select value from MGMT$OS_KERNEL_PARAMS where name='net.ipv4.tcp_wmem' and value not in ('4096    98304   16777216')

The values for this is like below and I want to exclude  net.ipv4.tcp_wmem with values 4096    98304   16777216 but still they are coming with value not condition also.Any way how we can compare a string with spaces in between?

4194304 4194304 4194304

4194304 4194304 4194305

4194304 4194304 4194304

16777216        16777216        16777216

4096    98304   16777216

4096    98304   16777216

4194304 4194304 4194304

4194304 4194304 4194304

16777216        16777216        16777216

16777216        16777216        16777216

4194304 4194304 4194304

4194304 4194304 4194304

4096    98304   16777216

4096    98304   16777216

16777216        16777216        16777216

4194304 4194304 4194305

4096    98304   4194304

4194304 4194304 4194304

4194304 4194304 4194304

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center