How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
No Answer is Posted For this Question
Be the First to Post Answer
How to define Data Block size ?
How to shutdown your 10g xe server?
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?
Please explain the difference between outer join and inner join? With examples would be appreciable..!
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What is instant client oracle?
How to use in conditions in oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
Explain about functional dependency and its relation with table design?
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
How to start an oracle instance?