Print/echo statement (1) Like python or other programming language, Print in PHP or echo in PHP does the same job i.e printing the statement on the screen Example <?php print “This is php script”; echo ” This is php script”; ?> This is php script This is php script So it is obvious from the […]
how to recover standby database from a missing archive log
A Physical Standby database relies on continuous application of archive logs from a Primary Database to be in sync with it. In Oracle Database versions prior to 10g in the event of an archivelog gone missing or corrupt you had to rebuild the standby database from scratch.From 10g you can use an incremental backup from […]
Virtualization : Types of Hypervisor, Benefits
What is virtualization Virtualization is the process of creating multiple virtual machines /operating system from one physical hardware box Each machine works independently from each other and have their own Operating system Each Virtual machine has the Virtual hardware Virtual CPU – it is the physical CPU which is allocated to virtual machine Virtual storage […]
RANK, DENSE_RANK and ROW_NUMBER functions in Oracle
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 […]
LEAD and LAG Analytic Functions
Lead function in oracle LEAD Function in Oracle is a Analytic function which 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 functions in oracle (Over Partition by Keyword)
This post is part of Oracle SQL tutorial and we would be discussing Analytic functions in oracle(Over by partition) with examples, detailed explanation . We have already studied about Oracle Aggregate function like avg ,sum ,count. Lets take an example First lets create the sample data CREATE TABLE “DEPT” ( “DEPTNO” NUMBER(2,0), “DNAME” VARCHAR2(14), “LOC” […]
