My Oracle Support Banner

How to Generate Numbers 0 to N from a Query without PL/SQL (Doc ID 268624.1)

Last updated on NOVEMBER 12, 2019

Applies to:

SQL*Plus - Version 8.1.7.4 to 9.2.0.5 [Release 8.1.7 to 9.2]
Information in this document applies to any platform.
***Checked for relevance on 13-Dec-2007***

Goal

 How to generate numbers 0 to N from a query without any PL/SQL

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.