what is acid property in database? : Sql dba

0 Answers  

---

How do I trace sql profiler?

0 Answers  

---

what is the difference between binary_integer and pls_integer

2 Answers   TCS,

---

difference between cursor and procedure in a package

3 Answers   PCS,

---

Define SQL and state the differences between SQL and other conventional programming Languages?

0 Answers  

---

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,

---

What is the difference between clustered and non-clustered index in sql?

0 Answers  

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

0 Answers  

---

How do you remove duplicates without using distinct in sql?

0 Answers  

---

What is the difference between distinct and unique in sql?

0 Answers  

---

How does pl sql work?

0 Answers  

---