2013-04-22

ORACLE - How to change your own password

You can execute this command (SQL Developer or command-line):


alter user USERNAME_HERE
identified by NEW_PASSWORD_HERE
replace OLD_PASSWORD_HERE
;

2013-04-20

MySQL - Random number between a given range of integers


This will generate a random number between 180 and 210.

select
floor(
180
+ (
rand()
* (210-180)
)
) as RandomBetween180and210
;