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

How to create a stored function in oracle?

1156

What is coalesce function?

1146

How to create a new table in your schema?

1129

How to create a stored procedure in oracle?

1150

Why use resource manager in Oracle?

1172

How to assign a tablespace to a users in oracle?

1089

Explain what are clusters?

1156

Explain an integrity constrains?

1191

What is bulk copy or bcp in oracle?

1184

How to convert characters to times in oracle?

1070

When do I need to use a semicolon vs a slash in oracle sql?

1142

What is the difference between sharding and partitioning?

1038

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2423

What is index-organized table in Oracle?

1118

What is oracle data type?

1007