20220203 카멜변환

카멜변환QUERY.txt

0.00MB

create or replace FUNCTION FN_GETCAMEL(COLUMN_NAME IN VARCHAR2)

RETURN VARCHAR2

IS

RSLT VARCHAR2(30);

BEGIN

--카멜표기로 변환(SITE_NUM -> siteNum)

SELECT LOWER(SUBSTR(REPLACE(INITCAP(COLUMN_NAME),'_'),1,1))

|| SUBSTR(REPLACE(INITCAP(COLUMN_NAME),'_'),2) INTO RSLT

FROM DUAL;

--리턴

RETURN RSLT;

END;

/

 

--구글 카멜변환(https://heavenly-appear.tistory.com/270)

SELECT COLUMN_NAME

, DATA_TYPE

, CASE WHEN DATA_TYPE='NUMBER' THEN 'private int ' || FN_GETCAMEL(COLUMN_NAME) || ';'

WHEN DATA_TYPE IN('VARCHAR2','CHAR') THEN 'private String ' || FN_GETCAMEL(COLUMN_NAME) || ';'

WHEN DATA_TYPE='DATE' THEN 'private Date ' || FN_GETCAMEL(COLUMN_NAME) || ';'

ELSE 'private String ' || FN_GETCAMEL(COLUMN_NAME) || ';'

END AS CAMEL_CASE

, '' RESULTMAP

FROM ALL_TAB_COLUMNS

WHERE TABLE_NAME = 'GUESTBOOK_MESSAGE'

AND   OWNER = 'JSPEXAM';