Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 8600 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / poornima
using cursor we find the gap in sequence, but this method
is quite complicated and slow process...
so we use some analyical fuctions such as lead and lag as
{LEAD | LAG} (value_expression, offset, default)
OVER ([PARTITION BY expr] ORDER BY expr)
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
what is a Nested Loop join?
Explain the use of owner option in exp command.
Explain the use of full option in exp command.
What is the relation of a user account and a schema?
What is a trigger oracle?
What is object data modeling?
What is the Tune Query
How to enter a new row into a table interactively?
Explain what are the different type of segments?
query optmization techniques and quwry analyser+projects+ppts
How to rollback the current transaction in oracle?
How oracle handles dead locks?
What is Data Dictionary Cache in Oracle?
 What are the oracle DML commands possible through an update strategy?
