Skip to content

Instantly share code, notes, and snippets.

@hearimm

hearimm/UnderScoreToCamelCase.sql

Created August 25, 2017 04:10
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save hearimm/88535a2e6c69aff2cefc8157da06dad9 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save hearimm/88535a2e6c69aff2cefc8157da06dad9 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle TableColumn Underscore to Camelcase
Raw
UnderScoreToCamelCase.sql
SELECT LOWER(SUBSTR(COLUMN_NAME,0,1)) || SUBSTR(REPLACE(INITCAP(COLUMN_NAME),'_',''),2)
FROM ALL_TAB_COLS
WHERE TABLE_NAME = 'ADC_DL_MODEL'
;
--from : HELLO_WORLD
--to : helloWorld
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment