Interested to Buy Any Domain ? << Click Here >> for more details...
Write the difference between case version and decode version.
- 2 Answers
- 4674 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nithya
Decode
1.It’s a function
2.can compare only discrete values
3.pl/sql standards
4.cannot process null
Case
1.It's an Expression
2.can handle range values
3.ANSI Standards
4.Processing time is faster when compared to Decode
5.can process null
| Is This Answer Correct ? | 3 Yes | 0 No |
Explain about xml databases?
What is dbms explain in brief?
Explain the process of the user request and data generating?
Can you have a nested transaction?
What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?
how will I find the duplicate rows count from employees tablein oracle.
Explain about post-relational databases?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
can you give me the syntax of named procedure??
explain detail about ftp in datastage?
Which four data types cannot be used as a return type from a user-defined function?
What are the types of database model?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
