what happened to the global index when I truncate the data
in one of the partition?
No Answer is Posted For this Question
Be the First to Post Answer
Where do we use decode and case statements?
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
Explain rename?
what is the use of composite key constraint?
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
How to initialize variables with default values?
Query to retrieve record for a many to many relationship ?
What is recovery manager in Oracle?
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
Differentiate between translate and replace?
What is a partition in oracle?
primary key is foreign key for the same table?