How to compare dates in oracle sql?

0 Answers  

---

What is the difference between truncate & delete command?

0 Answers  

---

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,

---

what is the syntax of ALTER command?

8 Answers  

---

How can we view last record added to a table?

0 Answers  

---

---

How to run the anonymous block again?

0 Answers  

---

9. Display the client name and order date for all orders using the JOIN . . . USING method.

2 Answers   Wipro,

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

1 Answers  

---

acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account

2 Answers   Polaris,

---

What is oracle database 10g express edition?

0 Answers  

---

Difference between primary key and unique key ?

77 Answers   Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,

---

What are the limitations oracle database 10g xe?

0 Answers  

---