Write the difference between case version and decode version.
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 |
Which four data types cannot be used as a return type from a user-defined function?
What are data modelling techniques?
What are the three types of database design?
Write the difference between case version and decode version.
What are the key features of dbms?
What is the system function to get the current user's user id?
Who are naive users?
Explain the process of the user request and data generating?
hi in which phase of mload can i use .FILLER
Explain about network model?
What is the database development process?
What is bit datatype and what's the information that can be stored inside a bit column?
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)