Interested to Buy Any Domain ? << Click Here >> for more details...
Write the difference between case version and decode version.
- 2 Answers
- 4917 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 |
What is the database development process?
What are the constraints on severity level in raiseerror?
Explain about normal forms?
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
What is dbms explain in brief?
Given an employee table, how would you find out the second highest salary?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
explain detail about ftp in datastage?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
How would you design a database for an online site, which would average a million hits a day?
Who are end users in dbms?
-
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)
