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 use update in sql function?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What is difference between stored procedures and application procedures?
How do I save a sql query?
What are the types of operators available in sql?
How to rename a column in the output of sql query?
Does postgresql run on the cloud?
What is an exception in PL/SQL? What are the two types of exceptions?
What is linq to sql?
what are the t string functions available in tsql? : Transact sql
what is offset-fetch filter in tsql? : Transact sql
What is trigger point?
What is sqlca in db2?
How do I find duplicates in two columns?
What is the difference between union and union all command?