Top-N Queries are common in Oracle database. People will often look for the below queries oracle top 100oracle select top 10oracle top 1000 rowsselecting top 10 rows in oraclehow to select top 10 rows These are essentianlly the same queries . They are called Top-N queries Let’s take a look at the different methods in […]
Query to check patch applied in R12.2
We often need to find out what all patches are applied to the EBS instance. Now, this varies as per the EBS instance version. We have different queries for R12.1 and R12.2.Let’s find out the Query to check the patch applied in R12/R12.1 and Query to check patch applied in R12.2 Query for R12/R12.1 ad_bugs […]
How to change/validate TDE Keystore Password
In this post, we will be checking, How to change TDE Keystore Password, How to validate the TDE wallet password How to change TDE Keystore Password Here are the steps to change TDE Keystore Password Rename the auto-login wallet file cwallet.sso in the wallet location $ mv cwallet.sso cwallet.sso_old Close the TDE encryption wallet sqlplus […]
How to check opatch version , apply patch, Upgrade
In this post, we will be discussing opatch , How to check the opatch version, apply the patch, and Upgrade How to check opatch version we can check the opatch version using the below command Log in to the Oracle Database serverSource the Oracle Home$ORACLE_HOME/OPatch/opatch versionOracle Interim Patch Installer version 12.2.0.1.29Copyright (c) 2021, Oracle Corporation. […]
how to check restore point in oracle
In this post, we will discuss, what is restore point in an oracle, how to check restore point in oracle What is a Restore Point in Oracle? A restore point is a name assigned to a system change number (SCN) in Oracle corresponding to the time of the creation of the restore point. A restore […]
Query to check character set in oracle
We have two character set defined for Oracle Database The NLS_CHARACTERSET is used for CHAR, VARCHAR2, LONG and CLOB columnsThe NLS_NCHAR_CHARACTERSET is used for NCHAR, NVARCHAR2 and NCLOB columns Query to check character set in oracle select * from nls_database_parameters where parameter=’NLS_CHARACTERSET’; Example sqlplus / as sysdba select * from nls_database_parameters where parameter=’NLS_CHARACTERSET’; parameter value […]
