if i am using dml statement in function.
then i am writing select statement what was the output
Answer Posted / jayashree
DML cant be performed in Function. There would be no change.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
types of indexes and the rationale behind choosing a particular index for a situation.
What are group functions in oracle?
Does oracle partitioning improve performance?
What are the differences between date and timestamp in oracle?
How to speed up webrick?
Describe varray?
How are extents allocated to a segment?
How to use null as conditions in oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Differentiate between pre-select and pre-query?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What is a nvl function? How can it be used?
What privilege is needed for a user to insert rows to tables in another schema?
What is tns service name?
What is Trigger in Oracle?