delete 문 만들기 쿼리
WITH TEMP_TABLE AS(SELECT MAX(A.OWNER) AS OWNER , B.TABLE_NAME AS TABLE_NAME , MAX(B.COMMENTS) AS TABLE_COMMENT , LOWER(SUBSTR(B.TABLE_NAME,1,1)) || SUBSTR(REPLACE(INITCAP(REPLACE(B.TABLE_NAME,'_',' ')),' '),2) AS CAMEL_CASE , MAX(LENGTHB(A.COMMENTS)) AS COMMENT_MAX_LENGTH , 150 AS MARGIN , MAX(( SELECT MAX(LENGTHB(X1.COLUMN_NAME)) AS IDX_COLUMN_MAX_LENGTH FROM ALL_IND_COLUMNS X1 WHERE X1.TABLE_..
더보기
insert 문 만들기 쿼리
WITH TEMP_TABLE AS(SELECT MAX(A.OWNER) AS OWNER , B.TABLE_NAME AS TABLE_NAME , MAX(B.COMMENTS) AS TABLE_COMMENT , LOWER(SUBSTR(B.TABLE_NAME,1,1)) || SUBSTR(REPLACE(INITCAP(REPLACE(B.TABLE_NAME,'_',' ')),' '),2) AS CAMEL_CASE , MAX(LENGTHB(A.COMMENTS)) AS COMMENT_MAX_LENGTH , 150 AS MARGIN , MAX(( SELECT MAX(LENGTHB(X1.COLUMN_NAME)) AS IDX_COLUMN_MAX_LENGTH FROM ALL_IND_COLUMNS X1 WHERE X1.TABLE_..
더보기
select 문 만들기 쿼리
SELECT WITH TEMP_TABLE AS(SELECT MAX(A.OWNER) AS OWNER , B.TABLE_NAME AS TABLE_NAME , MAX(B.COMMENTS) AS TABLE_COMMENT , LOWER(SUBSTR(B.TABLE_NAME,1,1)) || SUBSTR(REPLACE(INITCAP(REPLACE(B.TABLE_NAME,'_',' ')),' '),2) AS CAMEL_CASE , MAX(LENGTHB(A.COMMENTS)) AS COMMENT_MAX_LENGTH , 150 AS MARGIN , MAX(( SELECT MAX(LENGTHB(X1.COLUMN_NAME)) AS IDX_COLUMN_MAX_LENGTH FROM ALL_IND_COLUMNS X1 WHERE X1..
더보기
update 문 만들기 쿼리
UPDATE WITH TEMP_TABLE AS ( SELECT MAX(A.OWNER) AS OWNER , B.TABLE_NAME AS TABLE_NAME , MAX(B.COMMENTS) AS TABLE_COMMENT , LOWER(SUBSTR(B.TABLE_NAME,1,1)) || SUBSTR(REPLACE(INITCAP(REPLACE(B.TABLE_NAME,'_',' ')),' '),2) AS CAMEL_CASE , MAX(LENGTHB(A.COMMENTS)) AS COMMENT_MAX_LENGTH , 150 AS MARGIN , MAX(( SELECT MAX(LENGTHB(X1.COLUMN_NAME)) AS IDX_COLUMN_MAX_LENGTH FROM ALL_IND_COLUMNS X1 WHERE ..
더보기