can u call user defined functions in select statements
Answers were Sorted based on User's Feedback
Answer / prasanna
we can call user defined functions in select statements
| Is This Answer Correct ? | 6 Yes | 0 No |
yes, we can call user defined function in SELECT statement.
ex:
select function_name from dual;
| Is This Answer Correct ? | 3 Yes | 1 No |
How to select some rows from a table in oracle?
What is a cursor in oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How many file formats are supported to export data?
How would you extract DDL of a table without using a GUI tool?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
candidate key is subset of super key but not vice-verse explain
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How can you Enforce Referential Integrity in snapshots ?
Difference between varchar and varchar2 data types?