What is a partition in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
How would you best determine why your MVIEW couldnt FAST REFRESH?
What is Rollback Segment ?
when loggined as SYSTEM,how to display all the users of database using sql query?
How to pass a cursor variable to a procedure?
"primary key=unique+null" is equal,reson?not,reason?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Is there any function in oracle similar like group_concat of mysql?
How do I reset a sequence in oracle?
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
what is the syntax of ALTER command?