Oracle SQL
SQL
INDEX
Introduction to SQL
Data Definition Language-DDL
- Create
- Alter
- Drop
- Truncate
- Rename
Data Manipulation Language-DML
- Insert
- Update
- Delete
- Marge
Data Retrieval Language-DRL or Data Query Language -DQL
- Select
Transactional Control Language- TCL
- Commit
- Rollback
- Save Point
- Sava Point to
Data Control Languege -DCL
- Grant
- Revoke
DATA TYPES
Number
Character
- Char
- Varchar
- Varchar2
- Long
Date
OPERATORS
- Arithmetic Operator
- Relational Operator
- Logical Operator
Special Operator
In & Not in
Between & Not Between
Is Null & Is Not null
Like & Not Like
Functions
Predefined Functions
Number Functions
- Abs()
- Mod(m,n)
- Round
- Trunc(m,n)
- Gretest
- Ceil & Floor()
- Rollup,Cube
- Upper()
- Lower()
- Initcap()
- Length()
- Substr()
- Instr()
- Lpad()
- Rpad()
- Ltrim()
- Rtrim()
- Trim()
- Translate()
- Replace()
- Concat()
- To_Char()
- To_Date()
Character Functions
Date Functions
Group or Aggregate Functions
- Max()
- Min()
- Avg()
- Sum()
- Count(*)
- Count(column name)
User Defined Functions
Joins
8i Joins
- Equi Join or Inner Join
- Non Equi Join
- Self Join
- Outer Join
- Cross Join
9i Joins & ANSI Joins
- Inner Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Natural Join
Constraints
- Not Null
- Unique
- Primary Key
- Foreign Key
- Check
- Default Clause
- Table Level
- Column Level
- Super Key
- Candidate Key
SubQuery
Non- Correlated Subquery
- Single Row Subquery
- Multiple row subquery
- Multiple column subquery
- inline views or subquery are used in "from "clause
Correlated Subquery
- RowID
- RowNum
Analytical Functions
- Row_number()
- Rank()
- Dense_rank()
- Lag()
- Lead()
View
- Simple View
- Complex View (or) Join View
Materialized View
- Complete refresh materialized View
- Fast refresh materialized view
Synonyms
- Private Synonyms
- Public Synonyms
Sequence
Index
- B-tree Index
- BIT Map Index
- Function Based Index
Set Operators
- Union
- Union all
- Intersect
- Minus
Conversion
- Implicit Conversions
- Explicit conversions
- Decode
- Pivoting
Data type conversion function
- to_number()
- to_char()
- to_date()
Null Value Functions
- NVL()
- NVL2()
- nullif()
- coalesce()
Regular Expressions
- Regexp_like()
- Regexp_instr()
- Regexp_substr()
- Regexp_replace()
- Regexp_count()
- Level
- Start with
- Connect by
Normalization
- First Normal Form
- Second Normal Form
- Third Normal Form
- Boyce-Codd Normal Form(BCNF)
- Fourth Normal Form
- Fifth Normal Form
Clusters
Locking
Row Level Locks
Table Level Locks
- Share Lock
- Exclusive Lock
- Dead Locks
Flashback Query
Partitions
- Range Partition
- List Partition
- Hash Partition
PL/SQL
Index
Plsql Introduction
Cursors
- Implicit Cursor
- Explicit Cursor
Exceptions
- Predefined Exceptions
- User Defined Exceptions
- Unnamed Exceptions
Store Procedure
Store Functions
Packages
Collections Types
- Index By Table
- Nested Table
- Varray
- Refcursor
Bulk Bind & Bulk Collect
UTI_FILE Package
SQL Loader
Triggers
- Row Level
- Statement Level
- Instant of trigger
0 Comments