Home/ /Answers
  1. Asked: December 10, 2020

    add line item for interactive grid

    Hi Ratana, 1 - First create one dummy hidden  PAGE_ITEM 2 - Create Dynamic Action    Create a dynamic action Event Type as a Get Focus      Selection Type  Column      Region  Your region name     ( My_Region)      Column    Your column name  (Line_Number)     Client_Side Condition   Item/Column isRead more

    Hi Ratana,

    1 – First create one dummy hidden  PAGE_ITEM

    2 – Create Dynamic Action

    1.    Create a dynamic action Event Type as a Get Focus
    2.      Selection Type  Column
    3.      Region  Your region name     ( My_Region)
    4.      Column    Your column name  (Line_Number)
    5.     Client_Side Condition   Item/Column is null
    6.     Component Type   Column
    7.     Column    (Line_Number)

    (1)  Action

    •     Set Value
    •     PL/SQL Expression  _____  NVL(:P1_DUMMY,0)+1
    •     Item to Submit  ____  P1_DUMMY
    •     Affected Elements 
    •    Selection Type  Column
    •    Column   Line_Number
    •    Fire on Initialization    Yes
    •    Stop Execution On Error  Yes
    •    Wait For Result  Yes

    (2) Action

    •     Set Value
    •     PL/SQL Expression _____  NVL(:P1_DUMMY,0)+1
    •     Items to Submit ____  Null
    •     Affected Elements 
    •    Selection Type
    •     Item(s)  P1_DUMMY
    •    Fire on Initialization    Yes
    •    Stop Execution On Error  Yes
    •    Wait For Result  Yes

     

     

    See less
  2. Asked: December 10, 2020

    add line item for interactive grid

    Can you help to detail "Set_Line_Number"? Event: Get Focus Selection Type: ??? Region: ?? Column: ??   Thanks!

    Can you help to detail “Set_Line_Number”?

    Event: Get Focus

    Selection Type: ???

    Region: ??

    Column: ??

     

    Thanks!

    See less
  3. Asked: December 10, 2020

    add line item for interactive grid

    Please check now

    Please check now

    See less
  4. Asked: December 10, 2020

    add line item for interactive grid

    This answer was edited.

    Please check again

    Please check again

    See less
  5. Asked: December 10, 2020

    add line item for interactive grid

    hi,   image is very low resolution which cannot view the code.

    hi,

     

    image is very low resolution which cannot view the code.

    See less
  6. Asked: December 10, 2020

    add line item for interactive grid

    Hi Ratana, I have done an example like that see above image, for this one we have done dynamic action set value PLSQL Expression use in dummy hidden item      

    Hi

    Ratana,

    I have done an example like that see above image,

    for this one we have done dynamic action set value PLSQL Expression use

    in dummy hidden item

     

     

     

    See less
  7. Asked: December 10, 2020

    Is there any limitation for number of rows that can be displayed in report of APEX?

    No, there is no limit.

    No, there is no limit.

    See less
  8. Asked: December 9, 2020

    How to edit CLOB with Apex 20.0.2

    You simply create a page on the table having a CLOB column. Then specify the Markdown editor for item type and specify the maximum length with a higher value.

    You simply create a page on the table having a CLOB column. Then specify the Markdown editor for item type and specify the maximum length with a higher value.

    See less
  9. Asked: December 7, 2020

    To Set up row level security in APEX Interactive grid

    The table on which the interactive grid is based should have one more field, APPUSER. Now save the Oracle Apex :APP_USER whenever a row is created or edited. Then you can use it in the where clause of the interactive grid to get the records for the current user. For example: appuser = :app_user

    The table on which the interactive grid is based should have one more field, APPUSER. Now save the Oracle Apex :APP_USER whenever a row is created or edited.

    Then you can use it in the where clause of the interactive grid to get the records for the current user. For example:

    appuser = :app_user
    See less
  10. Asked: December 7, 2020

    Schedule Job to logoff all logged users

    To do this, I think you just need to kill all the active sessions. Try the below code: BEGIN FOR r IN (select sid,serial# from v$session) LOOP EXECUTE IMMEDIATE 'alter system kill session ''' || r.sid || ',' || r.serial# || ''' immediate'; END LOOP; END;

    To do this, I think you just need to kill all the active sessions. Try the below code:

    BEGIN
FOR r IN (select sid,serial# from v$session)
LOOP
EXECUTE IMMEDIATE 'alter system kill session ''' || r.sid || ',' 
|| r.serial# || ''' immediate';
END LOOP;
END;
    See less