Explain about the analyze command in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
What is oracle used for?
Why do we use coalesce function in oracle?
How to resolve name conflicts between variables and columns?
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What are the different pseudo commands? Explain in general?
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
what is the syntax of UPDATE command?
How to Truncate Table in Oracle
Shall I get Pro*C Compiler in Oracle-10g release ?
Explain the concept of the DUAL table.