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 select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How to write numeric literals in oracle?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
Explain the use of grant option in exp command.
What is a sub query and what are the different types of subqueries?
What do you mean by group by clause?
What happens to indexes if you drop a table?
Difference between NO DATA FOUND and %NOTFOUND?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
what r tyhe major differences between oracle 9i & 10g?