Explain about the analyze command in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
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 are ACID properties in databases?
What are group functions in oracle?
What is a named program unit?
What are the database administrators utilities available?
What is max rowid in oracle?
Explain oracle’s server parameter file.
How to invoke the data pump import utility?
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
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?
What is the sql query to concatenate column values from multiple rows in oracle?
What is an Integrity Constrains ?