Answer Posted / john bershan

select to_char(column_name,'dd-mon-yyyy') from <table_name>;

When is the update_statistics command used?

572

---

what is timestamp in mysql? : Sql dba

568

---

What is execution plan in sql?

550

---

Mention what is the plv (pl/vision) package offers?

641

---

how can we know the count/number of elements of an array? : Sql dba

576

---

---

What is an invalid partition table?

566

---

how to use like conditions? : Sql dba

576

---

What is difference between inner join and cross join?

522

---

What are the datatypes available in pl/sql ?

614

---

Why is a trigger used?

529

---

What is the difference between inner join and outer join?

532

---

Define select, insert, create, delete, update, drop keywords

600

---

What is varchar sql?

620

---

how is myisam table stored? : Sql dba

607

---

Which one is better subquery or joins?

557

---