SQL & PL/SQL

Hi All,

I am looking for all records that has one or more whitespace but it should not contain comma.

Example: in the "Test_Tab" it should fetch only 1 record: 'onlyspace '.

Database version: 11.2.0.4.0

Script:

create table test_tab (col1 varchar2(100));

insert into test_Tab values ('onlycommma,');
insert into test_tab values ('onlyspace ');
insert into test_tab values ('both ,');

I did this using INSTR like

select * from test_tab
where instr(col1,',') = 0 and instr(col1,' ') > 0;

But I am trying to accomplish this using regular expression. I tried to do the same but unable to write multiple conditions within REGEXP_LIKE.

Please help.

Thanks in advance.

Regards

Vikram