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 happens if you no create privilege in a database? : Sql dba

938

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1292

---

Can delete statement be rollbacked?

930

---

how can we submit a form without a submit button? : Sql dba

916

---

Is a foreign key always unique?

882

---

What is sql integrity?

1060

---

What is the use of %rowtype?

976

---

how to convert character strings to dates? : Sql dba

982

---

What is the difference between truncate and drop statements?

1083

---

What is cursor in pl sql?

1049

---

What are the 3 modes of parameter?

1099

---

Why do we use subquery?

942

---

How can you select unique records from a table?

991

---

What are string functions in sql?

1170

---

What is the life of an sql statement?

961

---