Answer Posted / ruth

Oracle 9i has a new datatype Timestamp

What is the basic structure of an sql?

573

---

Is it possible to create startup or shutdown trigger for on-schema?

587

---

What is pessimistic concurrency control? : Transact sql

588

---

how to get help information from the server? : Sql dba

528

---

Which operator is used in query for pattern matching?

627

---

---

What is clause in sql?

584

---

What is natural join in sql?

537

---

Are stored procedures faster than dynamic sql?

535

---

how to decrement dates by 1 in mysql? : Sql dba

584

---

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

579

---

Can a table contain multiple primary key’s?

631

---

how can we know the number of days between two given dates using mysql? : Sql dba

546

---

what is the difference between char_length and length? : Sql dba

574

---

Differentiate between syntax and runtime errors.

642

---

Write a unique difference between a function and a stored procedure.

533

---