INITCAP – The Oracle/PLSQL INITCAP function sets the first character in each word to uppercase and the rest to lowercase. INITCAP(‘tech on the net’); Result: ‘Tech On The Net’ INSTR – The Oracle/PLSQL INSTR function returns the location of a substring in a string. INSTR(‘Tech on the net’, ‘e’, 1, 2) Result: 11 (the… Continue reading ORACLE FUNCTIONS
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
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
ORACLE SQL PLSQL Advanced Tutorial 