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.

Types of joins ?

3 Answers   Digital GlobalSoft, HeadStrong,

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

0 Answers  

---

what is the difference between truncate and drop statements? : Sql dba

0 Answers  

---

What are all different types of collation sensitivity?

0 Answers  

---

What is string join?

0 Answers  

---

What is the difference between joins?

0 Answers  

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

0 Answers  

---

When should I use nosql database?

0 Answers  

---

How global cursor can be declare with dynamic trigger ?

0 Answers  

---

Explain the types of joins in sql?

0 Answers  

---

What are transaction and its controls?

0 Answers  

---

how to get a list of indexes of an existing table? : Sql dba

0 Answers  

---