Oracle APEX | Calculation on IG Columns, Working Tips for IG, PLSQL vs JS Exp. - Urdu/Hindi

In this video we have discussed about the calculation on Interactive Grid columns through PL/SQL Expression and also through JavaScript Expression as well, also we have discussed some tips for Interactive Grid

Content:
* Calculation on columns of Interactive Grid
* PL/SQL Expression vs JavaScript Expression
* Interactive Grid virtual column
* Static ID trick for IG Columns

Oracle APEX Process

Feel free to send email/message regarding any issue in the context

[MrBandhuraj]

Thank you for the detail explanation. Great job

[swapnilarsul]

Much appreciated,
You are not only teaching the valuable topics but also in the correct manner that everyone can understand easily.

The best thing is, you are making it point to point and crisp.

Please do create such videos.

[TekhXpert]

AOA, Many thanks Mr. Muhammad Ismail Rafiq Sb for an outstanding explanation on Interactive Grid.

[asifumersiddiqui]

Sir Ji very very thanks for this topic.its really very helpful for me. All types of calculation in oracle is my goal to achieve maximum knowledge in it. Thank you very very much.

[mrvictor]

Thanks Brother, I will learn Hindi for your great videos and Amitab Batchuan my favorite actor :-)

[irshadsamee]

aoa, very informative video... equipped with vital information. plz how to show summary column and to use its value? pls i need it ....

[TekhXpert]

Please explain about Validations in Interactive Grid that user should not able to save until all validations are passed

[SazidAhmedNassir]

Thank you for the videos. Can you make a video on how i change templates & use my custom template in oracle apex?

[ahmedharoon]

Assalam-o-Alaikum, appreciate your all efforts to guide us. in IG we can set no. of rows per page using : Actions -> Format -> Rows Per Page which are pre-defined 5, 10, 15...
can we set no. of rows per page as per our requirement like 12, 16, 17, 18 etc.? if yes, how to?
or can I give user input to set his/her required no. of rows per page? if yes how to?
please guide us.
regards

[mrt]

Thank you, very good explained, please tutorial on master detail. Detail edit and total summation on master.

[adnanansari]

very helpful video but i have a question if we have 2 interactive grid then what should we to calculate order total value. in case we have items values and also have several type of taxes so I want to create an other interactive grid

[rashidalin]

AOA sir, How can we add totals at the end of the IG. Live Totals. Please guide.

[ilyasawan]

Very Nice and Infromative Video. I have one problem only. When I Save or Reload page TOTAL is not showing, only showing on change event of Quantity or Unit_Price Column. Sir How did you use Source SQL Express on TOTAL column. I cannot validate it without : (Colon). It is not validating SQL Expression nvl(QUANTITY, 0)*nvl(UNIT_PRICE) but when used with : it validates it. In video you did not used : before columns. Kindly guide me how to resolve it.

[Usman_ahmadse]

Assalam o alaikum, When i try this . i face this issue ....anyone help please Interactive Grid Column 'TOTAL' specified for Dynamic Action 'NATIVE_SET_VALUE' does not exist.

[irshadsamee]

respected sir, jb me page ko run krta hu tu total k co;umn me 0 values ati hein... plz guide me...

[irshadsamee]

aoa, ismail bhai aap ne abhi tak koi reply ni kia? me ne apne issue se related ap ko email bhi ki he...
kindly response as soon...