| Post |
Topics |
| 1 |
Introduction
Database |
| 2 |
SQL*PLUS |
| 3 |
How
to execute sqlcommands |
| 4 |
SQL*
Plus commands |
| 5 |
SQL
command categories |
| 6 |
Objects
and schema in Oracle |
| 7 |
Data
Types in Oracle |
| 8 |
Operators
in Oracle |
| 9 |
Database
Tables |
| 10 |
SELECT
with WHERE clause |
| 11 |
SELECT
with ORDER BY Clause |
| 12 |
Aggregate
functions or Group by functions |
| 13 |
SELECT
with GROUP BY clause |
| 14 |
SELECT
with HAVING clause |
| 15 |
UPDATE
Statement |
| 16 |
DELETE
Statement |
| 17 |
TRUNCATE
TABLE Statement |
| 18 |
Built-in
Functions - Arithmetic |
| 19 |
Built-in
Functions - Character types |
| 20 |
Constraints |
| 21 |
Sequences |
| 22 |
SYNONYMS
and PUBLIC SYNONYMS |
| 23 |
VIEW |
| 24 |
Union,
Union all, Intersect and Minus |
| 25 |
Date
Functions |
| 26 |
SAVEPOINT |
| 27 |
Rollback |
| 28 |
Indexes |
| 29 |
ROLLUP
option in SELECT |
| 30 |
Pseudocolumn
- ROWID |
| 31 |
CUBE
in SELECT |
| 32 |
Virtual
Columns |
| 33 |
Global
temporary tables (GTT) |
| 34 |
GRANT
and REVOKE |
| 35 |
COMMENT
Statement |
| 36 |
Pseudocolumn
- ORA_ROWSCN |
| 37 |
Pseudocolumn
- ROWNUM |
| 38 |
Roles |
| 39 |
Important
system viewes |
| 40 |
How
to change password |
| 41 |
Oracle
Reserved Words |
| 42 |
LOCK
Table |
| 43 |
TEMPORARY
TABLE |
| 44 |
SELECT
with ANY |
| 45 |
Subquery |
| 46 |
What
is Recycle Bin ? |
| 47 |
Oracle
Clusterware and RAC |
| 48 |
Single
Instance vs RAC |
| 49 |
Advantages
of RAC |
| 50 |
OracleRAC
Software Components |
| 51 |
What
is OCR in Oracle RAC ? |
| 52 |
What
is Voting Disk in Oracle RAC ? |
| 53 |
What
does Oracle Clusterware do ? |
| 54 |
What is Oracle ASM ? |
| 55 |
ASM
Benefits |
| 56 |
ASM
vs Databases |
| 57 |
ASM
Disks |
| 58 |
ASM
Disk Group |
| 59 |
ASM
files |
| 60 |
Disk
Group Redundancy |
| 61 |
Groups
& Privileges for ASM |
| 62 |
What
is Service in RAC |
| 63 |
Service
Types in RAC |
| 64 |
What
is TAF ? |
| 65 |
TRASESS |
| 66 |
What
is FAN ? |
|
|
| Topics to come…. |
|
Bind Variables |
|
Create Directory Statement |
|
Cursors |
|
Data Dictionary |
|
Data Pump |
|
Database Links |
|
Special functions |
|
DBMS JOBS |
|
Decode |
|
Exceptions |
|
Explain Plan |
|
External Table |
|
Flashback |
|
FOR loop |
|
HINT |
|
IF statement |
|
Index Organised tables |
|
Interview Questions on PL/SQL |
|
Interview Questions on SQL |
|
JAVA in Oracle |
|
Joins |
|
Materialised Views |
|
Merge |
|
Nested Tables |
|
OOPS in Oracle |
|
Packages |
|
PL/SQL |
|
Pseudocolumns |
|
Roles |
|
Set Transactions |
|
SQL Loader |
|
SQL queires using functions |
|
SQL Trace |
|
SQL Tuning |
|
Stored function |
|
Stored procedure |
|
Subquries |
|
Temporary tables |
|
Triggers |
|
User defined Data types |
|
|
|
and more…… |
|
|
No comments:
Post a Comment