can u call user defined functions in select statements
Answers were Sorted based on User's Feedback
Answer / prasanna
we can call user defined functions in select statements
| Is This Answer Correct ? | 6 Yes | 0 No |
yes, we can call user defined function in SELECT statement.
ex:
select function_name from dual;
| Is This Answer Correct ? | 3 Yes | 1 No |
How to get execution path reports on query statements?
What is hot backup and logical backup?
What is Database Trigger ?
What are the different types of trigger and explain its various uses and functions?
How to view the tablespaces in the current database?
which is the best training centre for learning oracle?
what is normalisation?what are its uses?
Can group functions be mixed with non-group selection fields?
Why use resource manager in Oracle?
you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?