Category Database
In my previous article I showed you how to use Letsencrypt to secure a production Apex instance. This is specially…
Download the client credentials from your Oracle Cloud account for your Autonomous Data Warehouse Instance. Make sure you note down…
Oracle has been an incumbent to the cloud space having lost a lot of ground to Amazon and Microsoft.But that…
— Replace duplicate values only in consecutive records with NULL [duplicate]– SELECT CASE WHEN lag(tran_id) over(order by NULL) = tran_id…
Linux Version : CentOS 7.5 Oracle Version : 18c (18.3.0.0) 1. Download the Zip file from Oracle Website and create…
While creating a on-premise 18c (18.3) database with DBCA in the silent mode I got the below error dbca -createDatabase…
# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific…
On my test server I have got 2 ORACLE_HOMES 12cR1 (12.1.0.2) and 12cR2 (12.2.0.1) My listener.ora file on my server…
Create a new interactive report based on SQL Query. Make sure the column where image is store is populated in…
# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific…
It is always good practice to lock down password based logins and SSH using keys. We can use pem files…
If you have a public facing APEX instance it would be mandatory to secure it with TLS 1.2 or SSL.…
If you are going to work on Oracle Database in cloud or in environments where X11 client or server is…
This error occurred in my environment when i tried to create a user in MySQL, most likely you have upgraded…
This error you would usually see when you login to phpMyAdmin after an upgrade. This is related to your MySQL…
Oracle has released the latest version of Apex and keeping in line with their naming convention Apex has jumped from…
1. Add Encryption Wallet in sqlnet.ora Location $ORACLE_HOME/network/admin [oracle@localhost admin]$ vi sqlnet.ora ENCRYPTION_WALLET_LOCATION = (SOURCE =(METHOD = FILE)(METHOD_DATA = (DIRECTORY…
Representation State Transfer is the new industry standard of building technology neutral API’s. REST API are essentially web services to…
Mysql is the most popular open database and is the M in the LAMP stack (others being Linux-Apache-PHP) If your…
Oracle Apex is a modern framework to quickly develop and deploy web apps sitting on top of Oracle Database. Apex…
So you have got your Oracle APEX instance up and running and you want to customize your first app. The…