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.

Answer / suman

hi here it is, implicit cursor default by database, where
as explicit cursor is defined by user customized.

What is trigger in sql? Explain

0 Answers  

---

Is mariadb a nosql database?

0 Answers  

---

what are date and time data types? : Sql dba

0 Answers  

---

What is the difference between join and natural join?

0 Answers  

---

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  

---

What is magic table?

6 Answers  

---

Define overloaded procedure?

0 Answers  

---

what is the use of HASH, LIST partitions?

1 Answers   ITC Infotech,

---

Can there be 2 primary keys in a table?

0 Answers  

---

What does joining a thread mean?

0 Answers  

---

Are sql views compiled?

1 Answers  

---

What is normalization in a database?

0 Answers  

---