Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multi-Rows from DUAL

Gerd VolbergApr 3 2007 — edited Nov 19 2010
I need an easy select from DUAL, which gives me more than one row.

e.g. 1000 rows or 4500 rows....


I know that one of the best solutions was something with an CONNECT BY PRIOR and a WHERE ROWNUM <= 1000 e.g.


But what was the complete statement?

thx 4 solutions
Gerd

Comments

Sven W.

Is your APEX builder set to english or german? I had some scenarios where that made a difference (it shouldn't thou).

Timo Annemüller

Hi,

the Builder is set to german.

I found something out yesterday:

When i create a form with the wizard the button labels are in english, whats wrong.

When i create a form with interactive report, alle the button labels are in german, what they should be.

Maybe it a problem direct in Apex?

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 17 2010
Added on Apr 3 2007
49 comments
58,227 views