Skip to Main Content

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

Xavier Ribas

Hi!

Have you tried creating a new profile directly from "Application properties"?

Captura de Pantalla 2019-11-18 a les 9.33.36.png

Captura de Pantalla 2019-11-18 a les 9.33.58.png

On the other hand, do you see any error/warning in the "Message log" window when you try to execute the deployment profile?

1 - 1
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
57,869 views