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!

Table type IS TABLE OF

Tricampeon_1981Nov 18 2018 — edited Nov 19 2018

Good afternoon

I would like to ask a question, with your permission ..

you can go through this table with the help of dual from the same type.

TYPE lvT_ClienteTy IS TABLE OF CUSTOMER_ALL%Rowtype INDEX BY PLS_INTEGER; -- Recordtype Cliente

TyP_Cliente    lvT_ClienteTy;

BEGIN

TyP_Cliente(i).CUSTOMER_ID := Cur_Dire.lvN_Customer;

TyP_Cliente(i).CCSEQ       := Cur_Dire.CCSEQ;

TyP_Cliente(i).CCUSER      := Cur_Dire.CCUSER;

TyP_Cliente(i).CCCONTRACT  := Cur_Dire.CCCONTRACT;

TyP_Cliente(i).CCBILL      := Cur_Dire.CCBILL;

---I do not know how to go with dual from here

end

This post has been answered by Paulzip on Nov 18 2018
Jump to Answer
Comments
Post Details
Added on Nov 18 2018
6 comments
1,939 views