What is key preserved table?
No Answer is Posted For this Question
Be the First to Post Answer
 How to use an oracle sequence generator in a mapping?
What is a data segment ?
What is a sub query? Describe its types?
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 is RULE-based approach to optimization ?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
What is a oracle database?
can we insert any row to dual table if i got the permission from DBA
how to get the no employee in each department including the dept which has 0 employee
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
Why do we need oracle client?