Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts
LEAD has the ability to compute an expression on the next rows (rows which are going to come after the current row) and return the value to the current row. The general syntax of LEAD is shown below: LEAD (<expr>, <offset>, <default>) OVER (<analytic_clause>) <expr> is the expression to compute from the leading row. <offset> is the index of the leading row relative to the … Continue reading LEAD and LAG : Oracle Analytic Functions
Oracle Analytic functions compute an aggregate value based on a group of rows called window which determines the range of rows used to perform the calculations for the current row. Following are most used Analytic functions. – RANK, DENSE_RANK and ROW_NUMBER – LAG and LEAD – FIRST_VALUE and LAST_VALUE I would be discussing about RANK, DENSE_RANK and ROW_NUMBER analytics functions Here is the general syntax … Continue reading RANK, DENSE_RANK and ROW_NUMBER :Oracle Analytic functions
This post is part of SQL tutorial and we would be discussing Analytic function in oracle with examples, detailed explanation . We have already studied about Aggregate function like avg ,sum ,count. Lets take an example select count(*) from EMP; select sum (bytes) from dba_segments where tablespace_name=’TOOLS’; select deptno ,count(*) from emp group by deptno; SQL> desc emp Name Null? Type —————————————– ——– —————————- EMPNO … Continue reading Analytic function in oracle
We already know the general practice to apply application patches to R12.2 through online patching Adop(Ad online patching utility) explained R12.2 R12.2 Online patching cycle Summary Let’s explore the steps on how to apply database patches , weblogic patches , 10.1.2 patches , web-tier patches to the R12.2 tech stack. We can apply the same online patching cycle for the below technology patches a. Weblogic … Continue reading How to apply the technology patches to EBS R12.2
The dissertation is a serious and voluminous scientific work. The list of key requirements for it is very long. And even when you cope with all the questions in the content of the work, it is very easy to get lost in the formatting requirements. So, after you have written everything in your final paper, test it thoroughly. Check once again fit corresponds to all … Continue reading 5 Tests Your Dissertation Must Pass to Be Submitted Finally.
Refreshable PDB is a new features introduced in 12.2 . It builds upon hot clone capability in Oracle Database 12.2. It basically means we can refresh the remote PDB from source PDB on regular intervals by just applying the incremental redo This feature eliminates the need to re-create a cloned environment from scratch and also ensures that a cloned PDB can be periodically synchronized with … Continue reading Refreshable PDB in Oracle Database 12.2
Here are the 4 Top and most common OPATCH issues in Windows server Issue 1 OPatch cannot find a valid oraInst.loc file to locate Central Inventory. OPatch failed with error code = 104 Cause On UNIX-based systems, OPatch uses an oraInst.loc file to determine the location of the central inventory. On Windows, this is done by a registry entry instead: the key is Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\inst_loc. On … Continue reading Top and most common OPATCH issues in Windows server
Last updated on March 22nd, 2019 at 05:38 pmWe often come across the error ORA-28000 the account is locked. Reasons This can happen due to multiple reasons a. Oracle DBA has purposely locked the account alter user <username> account lock; select status from dba_users where username=’&1′; b. Wrong password has been attempted many times resulting in locking. The number of FAILED_LOGIN_ATTEMPTSÂ can be found using … Continue reading How to solve ORA-28000 the account is locked
Recently I encountered a oracle table which has 50 column and I need to analyze the each column for the particular row. It was tough viewing those 50 columns in the rows, So I created below PLSQL block to convert the rows into column. This takes table name as the input and print one rows in column format set serveroutput on declare colname varchar2(100); sql_str … Continue reading How to converts rows into column in a table
Last updated on March 9th, 2019 at 04:07 amWe can use RMAN to backup all the parts of the oracle database. RMAN backup command can be used backs up Oracle database files, copies of database files, archived logs, or backup sets. Here is the general syntax for RMAN backup command Syntax: BACKUP FULL Options BACKUP FULL AS (COPY | BACKUPSET) Options BACKUP INCREMENTAL LEVEL [=] … Continue reading RMAN Backup commands
Last updated on April 11th, 2019 at 05:28 pmRMAN List backup is a useful command to list the backup taken in the system.It shows all the details about the backup taken,what time it was taken, location of the backup. LIST BACKUP List all the backup taken in the system RMAN> LIST BACKUP; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed … Continue reading RMAN List backup commands
All the below scripts are present in $AD_TOP/sql ADZDDBCC.sql This sql is for database compliance checker, shows violations of the database object development standards described later in this document. Warning: this script takes a long time to run. Usage sqlplus apps/<appspass> @$AD_TOP/sql/ADZDDBCC.sql ADZDSHOWED.sql This sql show database editions and current edition. Usage sqlplus apps/<appspass> @$AD_TOP/sql/ADZDSHOWED.sql Edition Name Type Status Current? ————— ——– ——– ——– ORA$BASE … Continue reading Useful Oracle provided sql scripts for R12.2