<<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?

1 Answers   ITC Infotech,

---

Mention what are the benefits of pl/sql packages?

0 Answers  

---

Give the structure of the procedure ?

1 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

Which nosql database is best?

0 Answers  

---

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

0 Answers  

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

0 Answers  

---

what are Dynamic SQL statements?

9 Answers  

---

What is normalization? How many normalization forms are there?

0 Answers  

---

What is clustered and non-clustered indexes?

4 Answers   Microsoft,

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  

---

Why having clause is used in sql?

0 Answers  

---