Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
2 7578Post New Oracle General Questions
List the parts of a database trigger.
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What are the execution control statements?
How to use in conditions in oracle?
How to use like conditions in oracle?
What is a nested table?
What do you mean by merge in oracle and how can you merge two tables?
How to use subqueries in the from clause in oracle?
How to rename a column in an existing table?
What is difference between truncate and delete?
What is key preserved table?
What happens to the indexes if a table is recovered?
How remove data files before opening a database?
What are the types of partitions in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?