what is the difference between truncate and drop statements? : Sql dba

0 Answers  

---

How many null values can be inserted in a coulmn whihc is unique constraint

8 Answers   Flextronics,

---

What is mutating error in pl sql?

0 Answers  

---

What are the two parts of a procedure ?

6 Answers   Hi Caliber IT,

---

Can i possible to see Table Details ? Ex : Table Name Date Time User Emp May/18/2010 12:59pm Scott

3 Answers  

---

is it mandatory to select all the column in a view then what columns should be selected

2 Answers  

---

What is clustered index sql?

0 Answers  

---

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,

---

What are all the different normalizations?

0 Answers  

---

Is not null in sql?

0 Answers  

---

What is the diff between Truncate table / delete <table name> purge

3 Answers   TCS,

---

How to get second highest salary from a table

3 Answers  

---