what is the difference between implicit conversions and
explicit conversions?
- 2 Answers
- 8571 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
The select into statement is most often used to create backup copies of tables or for archiving records?
Do foreign keys improve performance?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
How to display the current date in sql?
How long will it take to learn pl sql?
What is pl sql package?
What are commit, rollback, and savepoint?
How to handle bulk data?
What is sql clause?
What are the set operators in sql?
What is the purpose of a secondary key?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What is a unique constraint?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
