Explain the difference between a procedure and a function? What do you understand by those terms?
No Answer is Posted For this Question
Be the First to Post Answer
What is program global area (pga) in oracle?
How to assign data of the deleted row to variables?
What are the general rules on data consistency?
What is the meaning of recursive hints in oracle?
What are the commands youd issue to show the explain plan for select
How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
What are cursor?where are they used?
When a form is invoked with call_form, Does oracle forms issues a save point ?
How do we create privileges in oracle?
what are different types of locks?
What is a nested table and how is it different from a normal table?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));