what is the difference between implicit conversions and explicit conversions?

what is the difference between implicit conversions and
explicit conversions?

Question Posted / swapna

2 Answers
8166 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the difference between implicit conversions and explicit conversions?..

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.

Is This Answer Correct ?

11 Yes

0 No

what is the difference between implicit conversions and explicit conversions?..

Answer / suman

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

Is This Answer Correct ?

2 Yes

6 No

Post New Answer