Interested to Buy Any Domain ? << Click Here >> for more details...
Write the difference between case version and decode version.
- 2 Answers
- 4906 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 |
In which database can extended stored procedures be added?
What is an application role and explain a scenario when you would use one?
Explain about network model?
What are the constraints on severity level in raiseerror?
How to replace not in with not exist?
what is difference between primary key and unique key ?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
Can you have a nested transaction?
I have a few records all are same structures data, I want to store data in multiple targets how
0 Answers CTR, Infosys, Polaris,
Which four data types cannot be used as a return type from a user-defined function?
Explain about normal forms?
What are the three types of database design?
-
Oracle (3253) - 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)
