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!

SELECT FOR UPDATE and FETCH FIRST in single query

Sanjib SahaMay 25 2020 — edited May 29 2020

Hi, Can you please suggest if 'SELECT FOR UPDATE' and 'FETCH FIRST N ROWS' is compatible or not?

Comments

Jorge Rimblas

Hi Tony,

I think you can do a selector like ".pagination a" if you only have pagination links and ".pagination select" if you have a drop down.

Personally I would probably save to the collection on field changes.  I think it would be a tad easier and better performance even though there would be a lot of chatter back and forth.

Thanks

-Jorge

TexasApexDeveloper

Jorge,

  Glad to hear from you... In regards to this, I coded up a simple dynamic action to try and display an alert when the tabular form pagination control is clicked...

Event: Click

Selection Type: jQuery Selector

jQuery Selector: $(".pagination select")

Alert does not fire....

Thank you,

Tony Miller
LuvMuffin Software
Ruckersville, VA

Jorge Rimblas
Answer

Tony, couple of things.

Since you used a Dynamic action the jQuery Selector should simply be:

.pagination select

Because the $() will be added by the DA.

Also, for the anchors/links you need a click, but for the select you need a "Change" event I think.

Thanks

-Jorge

PS.  if it still doesn't fire... then make sure your template is adding all the pagination stuff with a class of pagination.  It could be using something different.

Marked as Answer by TexasApexDeveloper · Sep 27 2020
TexasApexDeveloper

Changed the selector, and it does allow me to attach to the click..

I MIGHT have lucked out since the client LOVES Excel, they might want to just display all rows instead of doing pagination, depends on the # of rows...

I am REALLY looking forward to APEX 5.1 now....

Thank you,

Tony Miller
LuvMuffin Software
Ruckersville, VA

1 - 4

Post Details

Added on May 25 2020
6 comments
9,170 views