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   Infosys,

---

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

0 Answers   iFlex,

---

How to use existing values in update statements using oracle?

0 Answers  

---

What are the types of synonyms?

1 Answers  

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

0 Answers   CTS,

---

Explain the use of show option in imp command.

0 Answers  

---

How to get a list of all user accounts in the database?

0 Answers  

---

i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash

2 Answers  

---

What are the different pseudo commands? Explain in general?

0 Answers  

---

How to bring a tablespace offline?

0 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

8. Display the client name and order date for all orders using the natural join keywords.

1 Answers   Wipro,

---