What to do if the binary spfile is wrong for the default instance?
No Answer is Posted For this Question
Be the First to Post Answer
what are the diffeenes between oracle 9i,oracle 10g
How to execute a stored procedure in oracle?
how many columns can a plsql table have
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.
Explain implicit cursor.
what is RAID technology?which is better RAID 0+1 OR RAID 5?
How to export several tables together?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
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?
How to select an oracle system id (sid)?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?