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

2 Answers
5339 Views
I also Faced
E-Mail Answers

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

How to assign a table row to a record variable?

1040

What are the restrictions on external table columns?

1052

Which is better Oracle or MS SQL? Why?

6387

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1382

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2555

What are the limitations oracle database 10g xe?

1046

How can you use check constraints for self referential integrity?

970

What is system global area (sga) in oracle?

991

State and explain the different types of data models?

944

What is rowid and rownum in oracle?

1011

How oracle handles dead locks?

1066

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1933

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2325

What is oracle database 10g express edition?

1118

How to create a new table by selecting rows from another table?

1102