can u call user defined functions in select statements

Answer Posted / tripti gour

yes, we can call user defined function in SELECT statement.

ex:
select function_name from dual;

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an oracle and why it is used?

623


What is a table index in oracle?

632


How can windows applications connect to oracle servers?

522


How to store only time; not date and time?

557


Why use resource manager in Oracle?

663






What is catalog in Oracle?

649


What is a proxy class?

559


I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

1974


What is coalesce function?

575


For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1558


How many file formats are supported to export data?

659


I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

1633


How to install oracle odbc drivers?

623


How to do paging with oracle?

574


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1607