SELECT COLUMN_NAME
, SUBSTR ( REPLACE ( INITCAP ( '1' || COLUMN_NAME ), '_' ), 2)
FROM COLS
WHERE TABLE_NAME = 'tableName';
SELECT COLUMN_NAME
, SUBSTR ( REPLACE ( INITCAP ( '1' || COLUMN_NAME ), '_' ), 2)
FROM COLS
WHERE TABLE_NAME = 'tableName';