Explain the use of decode function
Answer / Rekha
"The DECODE function in Oracle is used to perform conditional logic within SQL queries, similar to an IF-THEN-ELSE statement. It takes up to six arguments: the first argument is the value to be evaluated, and the remaining arguments are a series of conditions and corresponding return values separated by commas. If the first argument matches one of the conditions, the corresponding return value is returned; otherwise, the function returns null."n
| Is This Answer Correct ? | 0 Yes | 0 No |
what are savepoint mode and cursor mode properties ?
How do you run ms_batch file in forms?
What is ole automation?
What do you understand by anchoring in reports?
Explain how to convert a report into excel sheet.
Explain the various types of canvas in form.
Explain the method to debug errors in an oracle application.
What is call form stack?
What is the placeholder column?
Have you used lexical parameters in reports?
How I can use srw.run_report in reports6i?
How will you run ms_batch file in forms?