Answer Posted / johncenzer

In an explicit conversion you tell the database how to do
the converion
ex: Select *
from some_table t...
WHERE t.invoice_date='&&pDate'TO_DATE('&&pDate')

or with format
TO_DATE('&&pDate','DD-MON-YYYY')

An implicit conversion is done by the database itself

ex. Select *
from some_table t...
WHERE t.invoice_date='&&pDate'
Oracle will try to convert the pDate into a date.

What is auto increment feature in sql?

1170

---

what is the difference between delete and truncate statement in sql? : Sql dba

1341

---

What are the operators used in select statements?

1095

---

What is a common use of group by in sql?

1094

---

how is exception handling handled in mysql? : Sql dba

1123

---

What is the difference between partition and index?

1046

---

What are the disadvantages of not performing database normalization?

1212

---

What is the difference between function and procedure in pl/sql?

1134

---

What is difference between stored procedures and application procedures?

1059

---

How many developers work on postgresql?

1037

---

explain advantages of innodb over myisam. : Sql dba

1174

---

Is sql open source?

1021

---

What is a record in a database?

1100

---

What is data profiling in sql?

1130

---

Differentiate between syntax and runtime errors.

1231

---