Post New Oracle General Questions
Why do you create or replace procedures rather that drop and recreate.
Can objects of the same schema reside in different tablespace?
What are the advantages of oracle 12c?
What are the ansi data types supported in oracle?
How to increment dates by 1 in oracle?
What is oracle host variable?
What is null value in oracle?
What is the use of aggregate functions in oracle?
How to find the duplicate rows count from employees table in oracle?
How to define a data field as not null?
What is partitioned table in Oracle?
How to use existing values in update statements using oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What are the differences between primary key and unique key?
How to do a full database export?