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!

Insert Values with loop Statement

MojaboSep 21 2017 — edited Sep 21 2017

Hello,

I need to create a table in PLSQL with Values from 1 to 3 with a loop Statement

In the end the table have 27 Rows.

The table have to look like this:

A B C

1 1 1

1 1 2

1 1 3

1 2 1

1 2 2

1 2 3

1 3 1

1 3 2

1 3 3

2 1 1

2 1 2

2 1 3

2 2 1

2 2 2

....

I hope you can help me

This post has been answered by Nimish Garg on Sep 21 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 19 2017
Added on Sep 21 2017
13 comments
8,673 views