ORACLE PLSQL Topics that you can find on this blog

ACID

Index

    B Tree Index

 Index the Correct Tables and Columns
Columns That Are Suitable for Indexing
Order Index Columns for Performance
Limit the Number of Indexes for Each Table
Rebuilding an Existing Index
Monitoring Index Usage

    BitMap Index

CLUSTER

SYNONYM

PARTITIONING

TRIGGERS

    Mutating table error

ROWID

ROWNUM

ANALYTICAL Functions

    COUNT

     ROW_NUMBER

     RANK

      DENSE_RANK

      LEAD

      LAG

     FIRST VALUE

     LAST VALUE

     FIRST

     LAST

     LISTAGG

PIVOT

Hierarchical Queries

     CONNECT BY

      LEVEL

      PRIOR

      START WITH

      CONNECT_BY_ISCYCLE

      CONNECT_BY_ROOT

ROW_GENERATOR, Generate table

WITH Clause

MERGE

COLLECTIONS

Index-By Table (Associative Array)
Nested Tables

Perform DML Operation on Nested Table/ Using nested table in sql
VARRAY
Collection Methods

EXIST
COUNT
LIMIT
FIRST
LAST
PRIOR
NEXT
EXTEND
TRIM
DELETE

REF CURSOR

Strong Ref Cursor
Weak Ref Cursor
SYS_REFCURSOR

EXPLAIN PLAN

Query optimization diagram
Executing explain plan
Reading explain plan
Index Unique Scans
Index Range Scans
Index Skip Scans
Index Joins
How the Query Optimizer Chooses an Access Path
How the Query Optimizer Chooses Execution Plans for Joins
Nested Loop Joins
Hash Joins
Sort Merge Joins
Cartesian Joins
Anti Joins

UTL_FILE
UTL_SMTP

DATA DICTIONARY

ORACLE VIEWS

ORACLE 12C NEW FEATURES
ORACLE 11G NEW FEATURES
ORACLE PLSQL 11G NEW FEATURES

ORACLE Functions

INITCAP
INSTR
LPAD
RPAD
LTRIM
RTRIM
TRIM
REPLACE
SUBSTR
REVERSE
TRANSLATE
ABS
CEIL
FLOOR
COUNT
GREATEST
LEAST
MOD
POWER
ROUND
SIGN
TRUNC
ADD_MONTHS
EXTRACT
LAST_DAY
MONTHS_BETWEEN
NEXT_DAY
ROUND DATE
TRUNC DATE
CAST
TO_CHAR
COALESCE

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s