How to display the hierarchy of employee and managers
without using connect by prior.
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
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'));
What is the disadvantage of User defind function?
What is a system tablespace and when it is created?
Explain the function of optimizer in oracle?
How to create a testing table in oracle?
how can we store any pdf file in oracle
Can you tell me how to add new column in existing views?how?How is possible?
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
Which is faster join or subquery in oracle?
What is a data dictionary and how can it be created?
What is recovery manager in Oracle?