Query to Select the First Day and Last Day of the Current Month select trim(to_date(last_day(sysdate),’DD/MM/YYYY’)) as lastday from dual; select…
The new PL/SQL procedure REDEF_TABLE in Oracle 12c lets you redefine a table online in a single step. It can…
One of the amazing features of Oracle Database 12c is that now you can do a logical restore from…
This is caused by a mismatch between the character set in which the table radm_fptm$ is created and in which…
Every DBA knows that: SQL*Plus is a powerful tool, but its output is often almost unreadable. Do we have to…
Here is a quick tutorial on how to set up LDAP authentication with Oracle Application Express 4.1.1. Let’s assume that…
Oracle 12c TDE on RAC Database with Physical Standby RAC. The Oracle Database Home has Multiple Instances, due to which…
Being a DBA requires us many a times to step outside our role and solve a problem in a smart…