Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between implicit conversions and
explicit conversions?
- 2 Answers
- 9213 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 there be more than one function with a similar name in a pl/sql block?
Is sql scripting language?
How to Execute a Package in PL/SQL.?
What is dba in sql? : SQL DBA
What steps server process has to take to execute an update statement?
Is a table valued function object?
What is sql and also describe types of sql statements?
How to assign sql query results to pl sql variables?
How would you pass hints to the sql processor?
How to start oracle sql developer?
What does stand for in sql?
What does where 1 1 mean in sql?
How many developers work on postgresql?
What are the indexing methods?
Is sql port 1433 encrypted?
