Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Random Numbers generation through SQL

Kam__apexMar 28 2024 — edited Mar 28 2024

Hi Friends,

I have a table named 'allowances' and there is a field LTRS. LTRS contained different numeric values like below.

LTRS Example

400 399

400 401

150 148

150 152

120 118

120 119

120 121

80 79

80 82

I want to generate above LTRS column randomly like Example column (Numbers should be in 1 to 4 change increase or decrease)

Please help how to generate. I will be thankful.

Regards

Kam

This post has been answered by Paulzip on Mar 28 2024
Jump to Answer
Comments
Post Details
Added on Mar 28 2024
2 comments
115 views