By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE your_table (column_name) AS
SELECT 'Apple' FROM DUAL UNION ALL
SELECT 'apple' FROM DUAL UNION ALL
SELECT 'Banana' FROM DUAL UNION ALL
SELECT 'banana' FROM DUAL UNION ALL
SELECT 'Bananb' FROM DUAL UNION ALL
SELECT 'Grape' FROM DUAL UNION ALL
SELECT 'orange' FROM DUAL UNION ALL
SELECT 'Pineapple' FROM DUAL;
8 rows affected
SELECT column_name
FROM your_table
ORDER BY LOWER(column_name), column_name;
| COLUMN_NAME |
|---|
| Apple |
| apple |
| Banana |
| banana |
| Bananb |
| Grape |
| orange |
| Pineapple |
SELECT column_name
FROM your_table
ORDER BY
NLSSORT(column_name, 'NLS_SORT=BINARY_CI'),
NLSSORT(column_name, 'NLS_SORT=BINARY');
| COLUMN_NAME |
|---|
| Apple |
| apple |
| Banana |
| banana |
| Bananb |
| Grape |
| orange |
| Pineapple |