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

807591
does the program not print "executing cmd" ?
ok, first, what do you think should happen, and second, what is happening really?

you arent doing anything with the input and output streams of your program.. so i dont know what you expect
807591
I should have been thinking about it a little bit longer. After I added a
waitFor()
and redirected the output as it is described in the article I posted the link to, everything worked as it should.
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
57,842 views