--  @E:\fujuSync\exDocsDraft\_nls-Database\thai-sorting.sql
-- alter session set NLS_SORT=THAI_DICTIONARY; 
create table ttsort(
id number(2),
name varchar2(20));

insert into ttsort values(1,'ก็เป็นอย่างนี้');
insert into ttsort values(1,'เสือ');
insert into ttsort values(1,'สู้');
insert into ttsort values(1,'กอด');
insert into ttsort values(1,'เกิดเป็นไทย');
insert into ttsort values(1,'ฮ นก ฮูก มาหลังเกิด');

commit;
select * from ttsort order by name;


SELECT *  FROM ttsort
ORDER BY NLSSORT(name, 'NLS_SORT = THAI_DICTIONARY');
-- no need to set the NLS_SORT session parameter


-- ref 
-- Oracle9i Globalization Support Guide 
-- Release 1 (9.0.1)
-- Part Number A90236-02