Oracle World

This blog will help you to know the basic of oracle DataBase and some important clause of Data Base Objects.

Friday, 23 March 2012

Query Village

Posted by Surya Singh at 3/23/2012 09:20:00 pm

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

No comments:

Followers

Blog Archive

► 2016 (6)
- ► 09/11 - 09/18 (1)
- ► 06/12 - 06/19 (1)
- ► 05/29 - 06/05 (3)
- ► 03/13 - 03/20 (1)

► 2015 (1)
- ► 06/07 - 06/14 (1)

► 2014 (4)
- ► 10/05 - 10/12 (1)
- ► 08/31 - 09/07 (1)
- ► 06/22 - 06/29 (2)

▼ 2012 (52)
- ► 11/04 - 11/11 (1)
- ► 09/09 - 09/16 (1)
- ► 07/29 - 08/05 (1)
- ► 05/27 - 06/03 (1)
- ► 04/29 - 05/06 (3)
- ► 04/22 - 04/29 (10)
- ► 03/25 - 04/01 (16)
- ▼ 03/18 - 03/25 (10)
- ► 03/11 - 03/18 (2)
- ► 03/04 - 03/11 (1)
- ► 02/26 - 03/04 (6)

About Me

Surya Singh

View my complete profile

Search This Blog

Popular Posts

Normalization with Example

Why do we need to do normalization? To eliminate redundancy of data i.e. having same information stored at multiple places, which event...
Difference Between ROWID AND ROWNUM

Difference between ROWID and ROWNUM. Row id RowNum 1. P...
Cluster and Non Cluster Index With Example

1. Introduction We all know that data entered in the tables are persisted in the physical drive in the form of database files. Think abo...
Difference between Group By and Partition By.

Group By Clause Partition By Clause Reduces the no. of records No. of records will not be reduced ...
Difference Between JOIN & UNION

Difference between JOIN and UNION Join Union 1. Join the ...
First and Last Row of the TABLE

First row of table SQL>select * from EMP where rownum = 1 order by rowid desc; Last Row of table SQL>select * from EMP wh...
Difference between VIEW and SYNONYM.

Difference between VIEW and SYNONYM. view synonym 1. ...
INTRODUCE YOUR SELF IN Interview

Your self-introduction in an interview is an extremely important part of the entire time, especially if the job will be in IT, mana...
Index, Sequence, Synonym, DCL, TCL,Cluster Index,Pseduo Column,Constraints, Primary key, Unique Key

Data Control Language These commands are used to grant the privileges or take back the granted privileges. Grant Used to grant privi...
Data, Attribute,dataType,functions

Data F Data is a raw fact which has have meaning and no meaning. F Objects & event that have meaning and importance in the u...

Awesome Inc. theme. Powered by Blogger.