KEMBAR78
Difference Oracle | PDF | Computers
Scribd
Upload
361 views2 pages

Difference Oracle

This document compares and contrasts several database concepts: 1. ROWID and ROWNUM provide unique identifiers for rows but ROWID provides a permanent identifier while ROWNUM is temporary. 2. ROW_NUMBER is an analytic function that assigns numbers to rows within groups while ROWNUM can be used in the WHERE clause but ROW_NUMBER cannot. 3. Primary keys are referenced by other tables as foreign keys, are not null and unique, and have clustered indexes by default while unique keys cannot be referenced, may allow nulls, and have nonclustered indexes.

Uploaded by

ashish10mca9394
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
361 views2 pages

Difference Oracle

This document compares and contrasts several database concepts: 1. ROWID and ROWNUM provide unique identifiers for rows but ROWID provides a permanent identifier while ROWNUM is temporary. 2. ROW_NUMBER is an analytic function that assigns numbers to rows within groups while ROWNUM can be used in the WHERE clause but ROW_NUMBER cannot. 3. Primary keys are referenced by other tables as foreign keys, are not null and unique, and have clustered indexes by default while unique keys cannot be referenced, may allow nulls, and have nonclustered indexes.

Uploaded by

ashish10mca9394
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 2

ROWID ROWNUM

Physical Address of Row Sequential number


Permanent for each row Temporary
16 bit Hexadecimal Numeric

ROWNUM ROW_NUMBER
Pseudo Column Analytic Function
Assign number to each row return by Assign number to each row according to
query its ordering with in group of rows.
Can be used in where Clause Can be use in select clause not in where
clause

Primary Key Unique Key


Primary key referenced to other table as Unique Key cant reference.
foreign key.

By default have Clustered Index Unique key have non clustered index.

Not Null and Unique May be Null but unique is must

Can be one in Table Can be more than one in Table.

CASE DECODE
Case is statement Function

Work with logical operator Work with equality operator

Faster in Optimizer comparison to Slower in Optimizer comparison to CASE.


DECODE.

Expects datatype inconsistency. Does not expect Datatype Inconsistency.

Work as Parameter to Procedure/Function Decode Cant


Call.
Exec proc1(Decode (;a, Three,3 ,
Exec proc1(Case: A when Three 0));
then 3 else 0 end);
Above statement give error.
Analytic Aggregate
Faster Slower

Group of row on which analytic function Group of row on which analytic function
perform defined by Partition Clause. perform defined as Group By Clause.

You might also like