what is the difference between implicit conversions and
explicit conversions?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / suman
hi here it is, implicit cursor default by database, where
as explicit cursor is defined by user customized.
Is This Answer Correct ? | 2 Yes | 6 No |
How do I run a sql query?
How do u count no of rows in a table?
What is sql scripting?
Is sql the best database?
What is sql in java?
What is a null value?
What is an ndf file?
How does one load ebcdic data? : aql loader
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?
Which is faster count (*) or count 1?
What does a pl/sql package consist of?
we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?