1.Create application item name > 'IMAGE_ID',> Session State Protection > Unrestricted.
2.Create Application Processes > 'GETIMAGE',> Process Point > Ajax Callback, > PL/SQL Code >
begin
for c1 in (select * from employee_information
where unique_id = :IMAGE_ID) loop
sys.htp.init;
sys.owa_util.mime_header( c1.MIME_TYPE, FALSE );
sys.htp.p('Content-length: ' || sys.dbms_lob.getlength( c1.PICTURE));
sys.htp.p('Content-Disposition: attachment; filename="' || c1.FILENAME || '"' );
sys.htp.p('Cache-Control: max-age=3600'); -- tell the browser to cache for one hour, adjust as necessary
sys.owa_util.http_header_close;
sys.wpg_docload.download_file( c1.PICTURE);
apex_application.stop_apex_engine;
end loop;
end;
3.Create/Select navigation bar where you want to show image > User Defined Attributes 1.
4. Unlock All Locked User :
select
username,account_status from dba_users where username like 'APEX%'; select username,account_status from dba_users where
username like 'ORDS%'; or
select username,account_status from dba_users where
lock_date is not null and username like 'APEX%'; )
For Oracle Database version 12c or later run the below script:
1. Smart Filters : Smart Filters is a new search component that allows users to quickly narrow data down with filters suggestions or search items. In Smart Filters include -Powerful Search Bar, Search Suggestions, Suggestion Chips.
2.Progressive Web Apps : APEX apps can easily be defined as Progressive Web Apps
(PWAs) to take advantage of advanced caching and improved performance. These
apps can also be installed on smartphone of choice with device-specific
installation instructions. Progressive Web Apps Include- App Performance, Apex Application Instable, Custom Offline Page.
3. Universal Theme & UI Updates : The updated Reference App now provides live Template Option
previews, documented CSS variables, and a new Theme Version menu in the header
to quickly jump to Reference Apps for previous versions of the Universal Theme. New updates are- Greater Flexibility in Page Layouts, Model Dialog Drawers, Accessibility Improvements, Faster Page Rendering.
2. Update Alert and Confirm Dialogs : Customizable Dialogs, Support for Template Directives,Button Confirmation.
5.Geocoding and Map Items : Geocoding your addresses has never been easier, and you can even display a map as a page item . The best part is that you don't need an API key.
6.REST Catalogs and Improvements : 1. Search Catalogs Across Apps. 2. Easy Export and Import. 3.URL-based Updating. 4. Pagination Support for REST Services.
7. Improved Report Downloads, Subscriptions, and Printing : 1. Images in Report Downloads. 2. Download Dialog Improvements. 3.Interactive Report Subscriptions.
8. Developer Experience : 1.Improved Editors :Static File Editor, Improved Breadcrumb Editor, Run Larger SQL in SQL Commands (SQL Commands now supports more than 32k characters).
9. Email and Email Template Enhancements : 1. Email Support in Automations. 2.Copy Email Templates. 3. Inline Email Attachments.
10. Additional Features : 1.Data Packager. 2. Popup LOV Set Display Value. 3. New Date Picker 'Show-On' attribute. 4. New Modal Dialog Event. 5.Copyright Banner in App Exports. 6.New PL/SQL APIs. 7. New JavaScript APIs. 8.Build Apex Apps in 21 additional Language. 9. JavaScript Library Upgrades.
