what is the difference between implicit conversions and
explicit conversions?
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.
Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Can we join tables without foreign key?
Is left join inner or outer?
What is server name sql?
Can we create foreign key without primary key?
Why plvtab is considered as the easiest way to access the pl/sql table?
What is a unique key and primary key and foreign key?
What is a common use of group by in sql?
In what condition is it good to disable a trigger?
How do you explain an index?
What are the types of functions in sql?
Explain the components of sql?
What is the best partition size for windows 10?
Why do we use set serveroutput on?
What are string functions in sql?
Can we use insert statement in function?