How can use apex collection in oracle apex

[@MrBandhuraj]

Thanks for the demo which is very helpful.
Also, could you kindly add the code to the youtube description that will be easy to copy and paste for your viewers to try out..

[@akishhero5155]

I am your 500 th friend

[@naga5583]

Really Nice video .This gave me a real clear picture and a way out for my problem .Great going .

[@OracleApexTutorials]

Thanks bro.

[@n.ctechnicalteach3392]

now i use apex tnx for video

[@nguyenhaithanh8694]

this is really help me alot, thank you

[@OracleApexTutorials]

Welcome brother.

[@zerinjahan3078]

Thanks for this type of information

[@ব্যাচেলরফরহাদ]

Thnqs for inpormation😍😍😍

[@yeasin0472]

Nice information

[@DevilKing-hp4et]

Go ahead

[@fearless1162]

Thanks for this information

[@adritakhanfashiongallary8642]

Nice

[@dailylifetipsbyanamika6189]

Gd informatin . Hlpful

[@OmarRiyati]

great work
how we can edit the data from collection?

[@OracleApexTutorials]

Thanks for your interest. You can edit collection data. for this, first, you need to move collection data into an editable region and after that, you can send this data into a collection.

[@mdtanjir5831]

Tnx for the info

[@jarnalisstmoni6260]

Good

[@abirhasan510]

nice

[@baizeedrony]

Helpful content

[@OracleApexTutorials]

Thanks Bro.

[@alauddin8593]

good job

[@OracleApexTutorials]

Thanks bro.

[@wizzeico4589]

is really nice of you bro it was amazing thanks a lot for your effort and I appreciated that , I have question if you don't mind can I show image on apex collection suppose the data it return form a table and i will save it to another table ?

[@OracleApexTutorials]

Yes. But why you show image in collection ?you can show image in report.

[@wizzeico4589]

@@OracleApexTutorials I'd like to show temporary for the user before he safe data

[@OracleApexTutorials]

You can see this video. It can help you.
th-cam.com/video/hBDlZYIzIeo/w-d-xo.html

[@AliAkbar-cl1wt]

good job.
Friend how can we delete specific record from collection before save .
for example collection have 3 record .if we want record 2nd from collection before save.
how this would be done ?
thanks in advance

[@OracleApexTutorials]

Thanks bro. You can use apex_collection.delete_member procedure.

[@AliAkbar-cl1wt]

Friend if you tell steps im new .its a v impotent question for all. thanks

[@OracleApexTutorials]

Ok, I will try to make another video about it .

[@AliAkbar-cl1wt]

@@OracleApexTutorials u r nice person.
We are all waiting this video.
Thanks

[@OracleApexTutorials]

Welcome brother.

[@muhammadismailmehtab]

HOW TO DISTINCT AND SUM IN COLLECTION
IN SCENARIO DISTINCT OR GROUP BY (C001 P37_ITEM_ID) AND SUM (C003 QTY)
SELECT C001 P37_ITEM_ID,C002 RATE,C003 QTY,seq_id,C002*C003 TOTAL
FROM APEX_COLLECTIONS WHERE COLLECTION_NAME ='CART'

[@OracleApexTutorials]

It's simple, Just use distinct & sum function. Thank You

[@akhihasan3367]

Oo

[@ব্যাচেলরফরহাদ]

Thnqs for inpormation😍😍😍

[@jeweldeb6558]

Nice