How to create Oracle SYS_CONTEXT ? Oracle SYS_CONTEXT holds the value of the parameter associated with context namespace. PrerequisiteDatabase user needs grant to create context. GRANT CREATE ANY CONTEXT TO c##ontoor_dev; Package to set parameter value. Create a context using... Read more
apex.server.process namespace works in async mode, meaning whenever you hit the process it never waits to complete. Let’s take below example. AJAX process name : GET_EMP_DATADescription: This process bring data from ORDS REST API. function get_data(p_url, p_pegination) { return apex.server.process('GET_EMP_DATA', {... Read more
How to create a Custom landing page to Google blogger? Google blogger provides the great feature of redirecting the home page to some other custom page. It is really helpful when you need to show your best content ate the... Read more
What’s coming in Oracle Application Express (APEX 20.1)? There are couple of things being added and removed In APEX 20.1. As per the APEX DEV team. Announcements Enhancements New Interactive Grid PDF generation features We have been struggling in APEX... Read more
Displays a text area supporting markdown input, with text formatting options, support for including images, and a preview option to view the formatted text. The Markdown Editor allows you to write using easy-to-read, easy-to-write plain text, then convert it to... Read more
What’s New in Oracle APEX 19.2? Faceted SearchAPEX dev team introduced in faceted search option in APEX 19.2. As per the DEV team. Introducing Faceted Search, a new component that enables you to quickly search and filter your data like... Read more
APEX user profile utility This plugin is inspired by the APEX workspace user profile option. Steps JSON Configuration Sample Query: Attributes Attribute Name Description Example FIRST_NAME Display First Name in Profile Ashish LAST_NAME Display Last Name in Profile Sahay IMAGE_SRC... Read more
How to Print apex region into PDF format in Oracle APEX? The answer… People typically want to download region into pdf format from a Classic Report, Interactive Report, or PLSQL dynamic content and this plugin will not supportable for... Read more
ORA-00972: identifier is too long. Till Oracle 12 C, the identifier length is 30 characters. Starting from 18 C Oracle increased the length of identifier to 128 character. So now we can define our identifiers till 128 characters if you... Read more