Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table test1(Prod_Name varchar(30))
insert into test1 values('CHANNEL')
1 rows affected

insert into test1 values('SHELL')
1 rows affected

insert into test1 values('_DISTRIBUTOR BELT')
1 rows affected

select * from test1 order by prod_name asc

PROD_NAME

CHANNEL

SHELL

_DISTRIBUTOR BELT

select * from test1 order by nlssort(prod_name, 'nls_sort = punctuation')

PROD_NAME

_DISTRIBUTOR BELT

CHANNEL

SHELL