PL/SQL (MOSC)

MOSC Banner

First single record in for loop

edited Oct 26, 2012 3:43AM in PL/SQL (MOSC) 12 commentsAnswered ✓
Hi,

We have a view with two records and a table with 9 records (not shown all the records).

View slr_vdomain:

Domain                   SequenceNr                          Defaultvalue

Product                              1                                             1

Taste                                  3                                             1

Table slr_domains:

Domain                           Value                         Description                              Sequencenr                                Defaultvalue                       DOS_type                            Norm_value

Product                              S                                    Strong                                             1                                                     1                                    USER                                           OK

Product                              W                                    Wrong                                            2                                                                                           USER                                          NOK

Product                               B                                     Braun                                            3                                                                                                                                              NOK

Taste                                  G                                     Good                                             1                                                                                           USER                                            OK

Taste                                  F                                      Fault                                              2                                                                                           USER                                           NOK

Taste                                  NT                                  Not Taste                                        3                                                     1                                    USER                                           NOK

In a for loop I want first taken the domain "Product", when the loop is ready for this item then I would take the next domain "Taste" and insert the result in a result table.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center