CASE
|
DECODE
|
1.CASE expression complies with ANSI
SQL
|
1. DECODE is specific to Database
vendors (like Oracle, SQL Server)
|
2. Case can compare discrete as well
as Range value
|
2. DECODE compare discrete values not
Range
|
3. CASE can work with logical
operators, predicates and searchable subqueries.
|
3. DECODE can work with only scaler
values
|
4. CASE is a statement.
|
4. DECODE is a function.
|
5. CASE expects datatype consistency.
|
5. DECODE does not expects datatype consistency.
|
This blog will help you to know the basic of oracle DataBase and some important clause of Data Base Objects.
No comments:
Post a Comment