CODEWITHSUNDEEP
sqloracle-database
Photops
Photops

Reputation: 322

Random number in range - sql oracle

I am trying to write a query. It will take employee IDs from a table, and assign random numbers between 1-45 in whole number increments. The data is in Oracle - sql.

Upvotes: 4

Views: 14240

Answers (1)

Photops
Photops

Reputation: 322

Got it:

round(DBMS_RANDOM.VALUE (1, 45))

round helps me get whole numbers.

Upvotes: 6

Related Questions