Answer / 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.

Answer / suman

hi here it is, implicit cursor default by database, where
as explicit cursor is defined by user customized.

Does truncate remove indexes?

0 Answers  

---

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

8 Answers  

---

Explain how can you save or place your msg in a table?

0 Answers  

---

What is difference between ms sql and mysql?

0 Answers  

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

Can I create table without primary key?

0 Answers  

---

Is left join inner or outer?

0 Answers  

---

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

0 Answers  

---

What are types of exception?

0 Answers  

---

How do I view output in sql developer?

0 Answers  

---

What is before and after trigger?

0 Answers  

---

what are all the different normalizations? : Sql dba

0 Answers  

---