Answer Posted / devi

1.procedure does not return any value whree as functions
return values
2.a procedure can be called independently where as a
function is called inside a procedure

how are mysql timestamps seen to a user? : Sql dba

1117

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

936

---

what is isam? : Sql dba

986

---

What are triggers and its types?

1041

---

How do I remove all records from a table?

1062

---

Which tcp/ip port does sql server run?

989

---

what is dbms? : Sql dba

974

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1004

---

What is a unique constraint?

1060

---

How to avoid using cursors?

1099

---

Why primary key is required?

985

---

What is a design view?

916

---

what is the difference between cluster and non cluster index? : Sql dba

1007

---

What is difference between rank () row_number () and dense_rank () in sql?

1090

---

How to create your own reports in sql developer?

1006

---