Interested to Buy Any Domain ? << Click Here >> for more details...
can u call user defined functions in select statements
- 2 Answers
- 5447 Views
- I also Faced
- E-Mail Answers
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 |
What is a cursor in oracle?
what is the difference between table and veiw?
How many anonymous blocks can be defined?
Explain the use of inctype option in exp command.
Explain what are the type of synonyms?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?
Give syntax for SQL and ORACLE joins.
How to use fetch statement in a loop?
How would you go about verifying the network name that the local_listener is currently using?
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
Can we create trigger on materialized view in oracle?
Oracle General 
