Sky IT Solutions Posts - TopicsExpress

Deciding When to Write EQUI-JOINS and OUTER-JOINS: Assume you
Deciding When to Write EQUI-JOINS and OUTER-JOINS: Assume you have table Dept with 10 Rows and EMP with 50 Rows. And if the relationship between the...

OCR (Oracle Cluster Registry) - This is an ASM diskgroup (one or
OCR (Oracle Cluster Registry) - This is an ASM diskgroup (one or more ASM DISKS) that needs to be provided when installing GRID in 11g and Clusterware...

PLSQL- Question: to delete the records I have execute immediate
PLSQL- Question: to delete the records I have execute immediate (Delete from sden where sden_pidm= ||vc_pidm); sden_cnt:= SQL%ROWCOUNT; sdenDeletednu...

What is Oracle RAC (Real Application Clustering)? Generally when
What is Oracle RAC (Real Application Clustering)? Generally when you create a Oracle database you will have an instance (Memory (sga) + Background pr...

Oracle 12c Rel 1 New Features : Some useful points to remember
Oracle 12c Rel 1 New Features : Some useful points to remember about Container and Pluggable Database: 1) You will have only one instance for all the ...

Oracle Redolog groups/file? Oracle Redo file stores all the
Oracle Redolog groups/file? Oracle Redo file stores all the changes (meaning DDL, DML and DCL changes) happening within Oracle database by default. ...