ALTER USER 아이디 IDENTIFIED BY 비밀번호

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

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