Log Log

# nologin sqlplus /nolog # sys login sqlplus "/as sysdba" # change password after login alter user USERNAME identified by NEW_PW # select * from dba_users https://docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_4174.htm#REFRN23302 DBA_USERS DBA_USERS DBA_USERS describes all users of the database. Related View USER_USERS describes the current user. This view does not display the PASSWORD..

[배경] over() 내 order by 구문으로 결과가 다르게 나타난다 WITH t AS ( SELECT '20150801' dt, 1 id FROM dual UNION ALL SELECT '20150801', 2 FROM dual UNION ALL SELECT '20150801', 1 FROM dual UNION ALL SELECT '20150802', 1 FROM dual UNION ALL SELECT '20150802', 2 FROM dual UNION ALL SELECT '20150802', 2 FROM dual UNION ALL SELECT '20150803', 3 FROM dual UNION ALL SELECT '20150804', 4 FROM dual UNION ALL SELECT '201..