Interview Q&A
- Interview Q&A for SQL Part-I
- Interview Q&A for SQL Part-II
- Interview Q&A for SQL Part-III
- Interview Q&A for SQL*Loader
- Interview Q&A for PLSQL
- Interview Q&A for Shell Script Part-I
- Interview Q&A for Shell Script Part-II
- Interview Q&A for Shell Script Part-III
- Interview Q&A for Apache Web Server Part-I
- Interview Q&A for Apache Web Server Part-II
Oracle SQL
- SQL Introduction
- SQL Sub Languages
- SQL Data Type
- SQL Create Table
- SQL Alter Table
- SQL Constraint
- SQL Update Statement
- SQL Delete Statement
- SQL Insert Statement
- SQL Dual Table
- SQL Numeric Functions
- SQL String Functions
- SQL Date Functions
- SQL NVL and NVL2 Functions
- SQL Case Function
- SQL Group by Clause
- SQL Having Clause
- SQL Order by Clause
- SQL Null Operations
- SQL Rownum Pseudo Column
- SQL Set Operator
- SQL Synonym
- SQL View
- SQL Inline View
- SQL Sequence
- SQL Database Link
- SQL Join
- SQL Sub-Query
- SQL Cluster Table
- SQL Index
- SQL Sub Language
- SQL Create table from another table
- SQL sysdate
- SQL*Plus Desc Command
Advance SQL
- SQL Analytical Functions
- SQL Merge Statement
- SQL Query Optimization Rules
- SQL Virtual Column
- SQL Global Temporary Table
- Execute SQL file
- Generate HTML report for SQL Query
- SQL Database Link
- SQL Query Processing steps
- SQL*Loader
Oracle PLSQL
- PLSQL Introduction
- PLSQL Data Types
- PLSQL Lexical Unit
- PLSQL Local and Global Variable
- PLSQL Loops
- PLSQL Cursor
- PLSQL Cursor Attribute
- PLSQL Parameterized Cursor
- PLSQL For Loop Cursor
- PLSQL Ref Cursor
- PLSQL Function
- PLSQL Procedure
- PLSQL Bulk collect and Forall
- PLSQL Trigger
- PLSQL Autonomous Transaction
- PLSQL Exception
- PLSQL Package
- PLSQL Utl_File Package
- PLSQL Collection
- PLSQL Collection Examples
- PLSQL Collection Methods
- PLSQL Program Examples
Differences Between
Oracle DBA
- Oracle Architecture
- Pfile and Spfile
- Shutdown Database
- Startup Database
- RMAN Catalog creation
- RMAN Commands
- RMAN Scripts
- Cloning database with RMAN
- Cloning Database without RMAN
- DBMS_STATS Package
- DBMS_METADATA Package
- User Management
- Tablespace Management
- Recyclebin
- DBA Queries
- Partitioning
- Partition Management
- Adding Datafile in ASM Database
- Oracle 11g Installation on Linux (Silent Mode)
- Oracle 11g installation on Linux
- exp Utility
- imp Utility
- Datapump
- Grant and Revoke of Privileges
- Oracle Audit
- Enable Archive log mode
- Disable Archive log mode
- Flashback
- AWR Report Extraction
- Upgrade Oracle 10g to 11g
- Upgrade 11g to 12c
- Oracle 11g Database with ASM grid installation in ...
