Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between implicit conversions and
explicit conversions?
- 2 Answers
- 9228 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
How to fetch alternate records from a table?
How do I view a procedure in sql?
What is a database? Explain
What are predefined functions in sql?
What is Histogram?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
Why is nosql good?
How many types of tables are there?
How to display the current date in sql?
Is t sql a programming language?
what is row? : Sql dba
Can we use two order by clause in query?
What does := mean in pl sql?
What is null in pl/sql?
How many types of indexes are there in sql?
