Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what is the difference between implicit conversions and
explicit conversions?

Answers were Sorted based on User's Feedback



what is the difference between implicit conversions and explicit conversions?..

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

what is the difference between implicit conversions and explicit conversions?..

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

Post New Answer

More SQL PLSQL Interview Questions

how would concatenate strings in mysql? : Sql dba

0 Answers  


How do you go back in sql?

0 Answers  


How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  


what are the security recommendations while using mysql? : Sql dba

0 Answers  


What are the two types of exceptions.

0 Answers  






what is a join? : Sql dba

0 Answers  


What is pl/sql table? Why it is used?

0 Answers  


Mention what does plv msg allows you to do?

0 Answers  


What is percent sign in sql?

0 Answers  


what is error ora-03113: end-of-file on communication channel?

0 Answers  


Should I use mbr or gpt?

0 Answers  


How to install oracle sql developer?

0 Answers  






Categories