Parallel Enabled Pipelined Table Functions
In the previous article, I mentioned about pipelined table functions. In this article, I am going to talk about parallel feature of pipelined table functions. At least one […]
More DetailsPipelined Table Functions
Table functions are used in FROM clause of a query as if it were a regular table that return PL/SQL collections. Returning large size of collections can be […]
More DetailsProxy user authentication
Proxy user authentication allows you to access another schema via a different user. In other words, dba can connect on behalf of a specific user without knowing the […]
More DetailsHow to change database log mode to archiving mode
After connect to the database via SQLPLUS. Shutdown the database using the NORMAL, IMMEDIATE, or TRANSACTIONAL option. We can start the database with mount mode. Now, we can alter the […]
More DetailsTrigger parent page when modal closed
In order to trigger parent page, in Apex 5.0, when user close the modal without to click any button. First, you will need to define the following Javascript […]
More DetailsHow to make pritable page in APEX
It can be done with Javascript. The following Javascript code, make the intended part of page as printable. You can create a dynamic action for this.
More DetailsCreate an Access Control List (ACL)
Access control list can be created, amended and deleted by DBMS_NETWORK_ACL_ADMIN package. It is used for network access. For instance, XML transfer etc. The following code can create […]
More DetailsTrigger dialog close event in Apex
In order to trigger dialog close event in APEX 5. You can write the following javascript code in the function and global declaration part of parent page. It […]
More DetailsData encryption and decryption using PL/SQL
Data encryption is the one of the key feature for security. It can be used for several purposes. I used DBMS_CRYPTO package for this. DBMS_CRYPTO.ENCRYPT function requires the […]
More DetailsXPath / XQuery / SQL
In brief, I will compare the equivalence of SQL, XQuery and XPATH. The following XML feed is used for this purpose. Oracle 11g is used. Now, I want […]
More Details