Explain implicit cursor.
No Answer is Posted For this Question
Be the First to Post Answer
What is a Data Segment ?
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
how to find full database size
1 Answers BirlaSoft, Consultancy,
What is the difference between substr and instr?
What is the difference between 10g OEM and 11g OEM?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
what is the difference between oracle enterprise edition and oracle express edition?
How to commit the current transaction in oracle?
What are the values that can be specified for OPTIMIZER MODE Parameter ?
How to create a new view in oracle?
How to convert raw data type into text in oracle? Explain
What is SAVE POINT ?