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

can u call user defined functions in select statements

Question Posted / tripti gour

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

Please Help Members By Posting Answers For Below Questions

What is a nested table and how is it different from a normal table?

1044

Explain about functional dependency and its relation with table design?

1000

How to name query output columns in oracle?

1175

How a database is related to tablespaces?

1023

Explain view?

1024

How to change program global area (pga) in oracle?

1079

What is a relational database management system?

1112

How to use subqueries in the from clause in oracle?

1098

What is a synonym? What are its various types?

1104

Why do we need integrity constraints in a database?

1013

Can we use bind variables in oracle stored procedure?

942

What is max rowid in oracle?

1017

What is analyze command used for?

1061

Name the various constraints used in oracle?

1011

How to define a record variable to store a table row?

1046