Topics

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
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……