can u call user defined functions in select statements

Answers were Sorted based on User's Feedback



can u call user defined functions in select statements..

Answer / prasanna

we can call user defined functions in select statements

Is This Answer Correct ?    6 Yes 0 No

can u call user defined functions in select statements..

Answer / 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

More Oracle General Interview Questions

how to get second highest sal of emp table

6 Answers  


what is load balancing and what u have used to do this?(sql loader)

3 Answers  


what is meant by magic query

0 Answers  


State the various uses of dbcc command?

0 Answers  


What is Hash Index?

1 Answers  






Why do we use bulk collect in oracle?

0 Answers  


hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4

1 Answers   CTS,


How remove data files before opening a database?

0 Answers  


How to write a left outer join with the where clause in oracle?

0 Answers  


Explain the difference between a procedure and a function? What do you understand by those terms?

0 Answers  


How to pass a cursor variable to a procedure?

0 Answers  


How do we get field details of a table?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)