www.dbatoolz.com › ORACLE DBA Forums › Forum › Topic Id: 2869 | Permalink

generating natural numbers non-divisible by a given natural X

Topic ID: 2869
Created By:	2008-JAN-07 12:29:04 [Vitaliy]
Updated By:	2008-JAN-07 12:29:04 [Vitaliy]
Status:	Open
Severity:	Normal
Read Only:	No

8687

2008-JAN-07 12:29:04

Vitaliy

Moderator

Registered On: Mar 2006

Total Posts: 233

Here's a great discussion on ASKTOM on how to generate natural numbers 
non-divisible by a given natural X, where X>1, ...

QUOTE:

   For any N natural, N + FLOOR( (N-1) / (X-1) ) is not divisible by X.

   Works for integer numbers too.

REFERENCE:
   http://asktom.oracle...D:583100900346444683

Permalink