ALTER USER 아이디 IDENTIFIED BY 비밀번호

홑따옴표 때문에 쿼리문 실행 오류가 나서 찾아보니 간단했다.

SELECT TBL.TABLE_NAME , TCM.COMMENTS , TBL.TABLESPACE_NAME , TCL.COLUMN_ID , TCL.COLUMN_NAME , 
	CASE WHEN TCL.DATA_TYPE = 'VARCHAR2' OR TCL.DATA_TYPE = 'CHAR' OR TCL.DATA_TYPE = 'NUMBER' 
		THEN TCL.DATA_TYPE || '(' || DATA_LENGTH || ')'
	ELSE TCL.DATA_TYPE END AS DATA_TYPE , CON.KEY , 
		DECODE(NULLABLE , 'N' , 'NOT NULL' , '') AS NOTNULL , DATA_DEFAULT , CCM.COMMENTS	 
FROM USER_TABLES TBL , USER_TAB_COMMENTS TCM , USER_TAB_COLUMNS TCL , USER_COL_COMMENTS CCM , 
	(SELECT CCL.TABLE_NAME , COLUMN_NAME ,
		CASE WHEN SUM(DECODE(CONSTRAINT_TYPE , 'P' , 1 , 0)) > 0 AND  SUM(DECODE(CONSTRAINT_TYPE , 'F' , 1 , 0)) > 0 
		THEN 'PK,FK'
			WHEN SUM(DECODE(CONSTRAINT_TYPE , 'P' , 1 , 0)) > 0
		THEN 'PK'
			WHEN SUM(DECODE(CONSTRAINT_TYPE , 'F' , 1 , 0)) > 0
		THEN 'FK'
	 	ELSE '' END AS KEY ,
		SUM(DECODE(CONSTRAINT_TYPE , 'C' , 0 , 'P' , 0 , 'F' , 0 , 1)) AS CCC			  
	FROM USER_CONS_COLUMNS CCL , USER_CONSTRAINTS CNS
	WHERE CCL.CONSTRAINT_NAME = CNS.CONSTRAINT_NAME
	GROUP BY CCL.TABLE_NAME , COLUMN_NAME ) CON
WHERE TBL.TABLE_NAME = TCM.TABLE_NAME
	AND TBL.TABLE_NAME = TCL.TABLE_NAME 
	AND TCL.TABLE_NAME = CCM.TABLE_NAME AND TCL.COLUMN_NAME = CCM.COLUMN_NAME
	AND TCL.TABLE_NAME = CON.TABLE_NAME(+) AND TCL.COLUMN_NAME = CON.COLUMN_NAME(+)
ORDER BY TBL.TABLE_NAME , COLUMN_ID

출처 : http://pompsky.blog.me/60051648162

UPDATE table1 a
SET a.col1 = (SELECT col1 FROM table2 WHERE col2 = a.col2)
WHERE a.col2 IN (SELECT col2 FROM table2)

UPDATE table1 a
SET ( col1, col2 ) = ( SELECT col1, col2 FROM table2 b WHERE b.col3=a.col3 ) 
WHERE a.col3 IN ( SELECT col3 FROM table2 )

-- string to date
to_date("2013-02-01 13:04:00", 'YYYY-MM-DD HH24:MI:SS')


-- date to string
to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS')


-- unixtime to date
to_date('01-01-1970', 'DD-MM-YYYY')+ (sysdate / ( 60*60*24) - (5/24))
to_date('01-01-1970', 'DD-MM-YYYY')+ (sysdate/1000 / ( 60*60*24) - (5/24)) -- java


-- date to unixtime
round((to_date(sysdate, 'YYYY-MM-DD HH24:MI:SS') - to_date('01-01-1970','DD-mm-YYYY')) * (86400))
round((to_date(sysdate, 'YYYY-MM-DD HH24:MI:SS') - to_date('01-01-1970','DD-mm-YYYY')) * (86400)*1000) -- java