1

Topic: Synonym NTILE ()

What function replaces NTILE () in ?

2

Re: Synonym NTILE ()

Goofy122 wrote:

What function replaces NTILE () in ?

NTILE
Use search

3

Re: Synonym NTILE ()

Fogel;
In 11c is not present ntile ()

4

Re: Synonym NTILE ()

Goofy122 wrote:

in 11c

That for an animal?

5

Re: Synonym NTILE ()

Goofy122 wrote:

in 11c is not present ntile ()

Hands at someone not from this places grow simply.

6

Re: Synonym NTILE ()

Goofy122 wrote:

Fogel;
In 11c is not present ntile ()

And writes - "here such function is not present"?

7

Re: Synonym NTILE ()

Goofy122 wrote:

Fogel;
In 11c is not present ntile ()

https://docs.oracle.com/cd/B28359_01/se … /ntile.htm
Home / Database / Oracle Database Online Documentation 11 g Release 1 (11.1) / Database Administration
NTILE (expr)
OVER ([query_partition_clause] order_by_clause)
NTILE is an analytic function. It divides an ordered data set into a number of buckets indicated by expr and assigns the appropriate bucket number to each row. The buckets are numbered 1 through expr. The expr value must resolve to a positive constant for each partition. Oracle Database expects an integer, and if expr is a noninteger constant, then Oracle truncates the value to an integer. The return value is NUMBER.
......
stax