Interested to Buy Any Domain ? << Click Here >> for more details...
can u call user defined functions in select statements
- 2 Answers
- 5299 Views
- I also Faced
- E-Mail Answers
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 connect to the server with user account: sys?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Explain database link?
Differentiate between TRUNCATE and DELETE?
What is a named program unit?
What are the uses of a database trigger?
What is a trigger and what are its types in oracle?
What is forall Statement ?
How to resolve the ORA-39133 error in Oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
The join defined by the default data link is an outer join yes or no ?
How to retrieve the count of updated rows?
Oracle General 
