If you want to restrict file upload by file type/extension/format you can follow the below steps.  Goto File Browser Item --> Advanced --> Custom Attributes  Then pest below code : accept=".pdf,.csv,.xlsx" Here it means only pdf , csv and xlsx file will be acceptable for upload.  If you want to accept only pdf then you have to put like below code as the screenshot given: accept=".pdf" That's it. Now you can go and check.  ..read more

Application users can able to do DML from the frontend side.   1. Create a region and create 7 item like below and a button call Convert    P23_UPDATE_DELETE  P23_COLUMN_NAME  P23_CONDITION  P23_CURRENT_DATE  P23_UPDATE_COLUMN  P23_TARGET_DATE  P23_UPDATE_COUNT    Convert        2. P23_UPDATE_DELETE     will be a radio group with Update-U and Delete-D    ..read more

Step 1:  Create two application items.  Step 2: Create an application process like below IF :AI_CURRENT_PAGE <> :APP_PAGE_ID   THEN   :AI_PREVIOUS_PAGE:=:AI_CURRENT_PAGE;   END IF;  :AI_CURRENT_PAGE:=:APP_PAGE_ID; Step 3: Put the    &AI_PREVIOUS_PAGE.    item into the Back Button target page.   ..read more

SELECT * FROM DBA_SCHEDULER_RUNNING_JOBS ;  SELECT * FROM DBA_SCHEDULER_JOBS WHERE LAST_START_DATE > SYSDATE - 1 ORDER BY CAST(LAST_START_DATE AS DATE) ; SELECT * FROM DBA_SCHEDULER_JOB_LOG WHERE LOG_DATE > SYSDATE - 1 ORDER BY LOG_DATE ; SELECT * FROM DBA_SCHEDULER_JOB_RUN_DETAILS WHERE ACTUAL_START_DATE > SYSDATE - 1 order by ACTUAL_START_DATE ..read more

Step 1:  First, make a class name for the interactive grid. Go to Page Properties >> Appearance >> CSS Classes >> CLASSNAME Step 2:  Goto Page Properties >> CSS Inline >>  .CLASSNAME .a-GV-w-hdr{     overflow-x: auto !important ..read more

BEGIN apex_util.create_user (   p_user_name=> :NEW.USER_NAME, p_first_name=> :NEW.FIRST_NAME, p_last_name=> :NEW.LAST_NAME, p_description=>  :NEW.DESCRIPTION, p_email_address =>:NEW.EMAIL_ADDRESS, p_web_password=>:NEW.TEMP_PASSWORD,--p_group_ids=>set_group_id,  /*--For extra security, this resets the user's access to the APEX_BI schema only---*/ p_allow_access_to_schemas  => 'STARS_DEMO',                 /*--For extra security, this resets the user's default schema to APEX_BI--*/ p_default_schema =>&nbs ..read more

  Whenever we try to call the workspace user to create API from the process we may face the below error.  An API call has been prohibited. Contact your administrator. Details about this incident are available via debug id "108075" Easy Solution: Just follow the below steps ..read more

STEP-1 Begin IF  APEX_COLLECTION.COLLECTION_EXISTS('COLLECTION_TABLE_NAME') THEN     APEX_COLLECTION.TRUNCATE_COLLECTION('COLLECTION_TABLE_NAME'); END IF; IF NOT APEX_COLLECTION.COLLECTION_EXISTS('COLLECTION_TABLE_NAME') THEN     APEX_COLLECTION.CREATE_COLLECTION('COLLECTION_TABLE_NAME'); END IF;  for r1 in (select *  from apex_application_temp_files f, table( apex_data_parser.parse(p_content  => f.blob_content, p_add_headers_row => 'Y', -- p_store_profile_to_collection => 'FILE_PROV_CASH', p_file_name=> f.filename, p_skip_rows => ..read more

Step 1. Create a Classic Report and add a checkbox  ---------------------------------------------- SELECT ID, APEX_ITEM.display_and_save (02,ID)ID, FILE_NAME, FILE_MIMETYPE, FILE_CHARSET, FILE_LASTUPD_DTTM, FILE_UPLOAD_DATE, FILE_UPLOAD_STATUS, apex_item.checkbox(01,'#ROWNUM#') CheckBox FROM TABLE WHERE 1=1 AND ID=:P5_ID; Step 2. Create a process ----------------------------- declare var_zip blob; var number ; begin -- Create/clear the ZIP collection apex_collection.create_or_truncate_collection( p_collection_name => 'ZIP'); if APEX_APPLICATION.G_F01.COUNT < 1 th ..read more

Here we are freezing the first 5 columns from an interactive report in Oracle Apex. Step-1. Copy the below code and pest into Page -> Execute when Page Loads $('.a-IRR-table tr th:nth-child(2), .a-IRR-table tr td:nth-child(2)').css("left",$(".a-IRR-table tr th:nth-child(1)").width()); $('.a-IRR-table tr th:nth-child(3), .a-IRR-table tr td:nth-child(3)').css("left",$(".a-IRR-table tr th:nth-child(1)").width()+$(".a-IRR-table tr th:nth-child(2)").width()); $('.a-IRR-table tr th:nth-child(4), .a-IRR-table tr td:nth-child(4)').css("left",$(".a-IRR-table tr th:nth-child(1)").width()+$(".a-IRR-t ..read more