Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between implicit conversions and
explicit conversions?
- 2 Answers
- 9196 Views
- I also Faced
- E-Mail Answers
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 procedure in package be overloaded?
what is commit? : Sql dba
What are the various levels of constraints?
what happens if you no create privilege in a database? : Sql dba
Define the select into statement.
Can we join more than 2 tables in sql?
What is pl sql script?
What does (+) mean in sql joins?
What is pl sql package?
What are database links used for?
What is composite data type in pl sql?
what are the security recommendations while using mysql? : Sql dba
what is meant by urlencode and urldocode? : Sql dba
What are all the different normalizations?
what is the difference between where clause and having clause? : Sql dba
