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!

Pseudo rows generated till 100

694022Apr 1 2009 — edited Apr 2 2009
Hello.

I need your help again (had to sign on new).
MY problem: Whe have a View which is receiving some columns.

Example:

A B
---------
df 1*
df 9*
ddf 1*
ddf 3*
ddf 54*
...

The pseudycolumns for "df" should be


1) 1*
2) blank
3) blank
4) blank
5) blank
6) blank
7) blank
8) blank
9) 9*
10) blank
11) blank
....
100) blank

The pseudycolumns for "ddf" should be


1) blank
2) blank
3) 3*
4) blank
5) blank
6) blank
7) blank
8) blank
9) blank
10) blank
11) blank
54) 54*
....
100) blank

Max row number = 100
Any tipps or tricks... thx Silvester752
This post has been answered by BluShadow on Apr 2 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 30 2009
Added on Apr 1 2009
13 comments
1,461 views