How to delete a column in an existing table?
How can we force the database to use the user specified rollback segment?
How to write a query with an inner join in oracle?
What is an Integrity Constrains ?
Explain what are the different type of segments?
what is data abstraction
What is a user role in oracle?
What are the different types of partitions 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?
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
What is clusters ?
What do you mean by merge in oracle and how can we merge two tables?
How much memory your 10g xe server is using?