What are the major difference between truncate and delete?

0 Answers  

---

How to define an anonymous procedure with variables?

0 Answers  

---

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

0 Answers  

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

How to add a new column to an existing table with a default value?

0 Answers  

---

Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE

1 Answers  

---

write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000

4 Answers   TCS,

---

What is recycle bin in Oracle?

0 Answers   MCN Solutions,

---

Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.

1 Answers   IBM,

---

does the query needs a hint to access a materialized view?

1 Answers  

---

Can the default values be assigned to actual parameters?

1 Answers  

---

What privilege is needed for a user to insert rows to tables in another schema?

0 Answers  

---