generate 4 digit number

[kavithared]

I have three columns in table, they are
mobileno,password,status.
table name -- mobile

Here i want to 3 procedures based on this table.

1st proc
mobileno output parameter
password and status inputparameter.

Here my problem is now we are like to send new 4 digit password to users.Previous some of them have alpha numeric
password.

purpose---By using this procedure,When i enter mobileno
If password is 4digit number then display status and password
If password is Not 4 digit number ,then should generate 4 digit number.

I hope any one can help me with example
thanks
kavitha

[SANJAY_G]

Use RANDOM function to generate random number.

http://otn.oracle.com/docs/products/...ra2.htm#999811

Sanjay

[kavithared]

Hiii,Sanjay thanks
Can u give above example.
thanks
kaviths

[marist89]

closing, duplicate post http://www.dbasupport.com/forums/sho...threadid=26441