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 are the different tcl commands in sql?

0 Answers  

---

what is single byte over head in oracle..?

0 Answers  

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

0 Answers  

---

What are the dml statements?

0 Answers  

---

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers   Hexaware,

---

if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,

---

Can ddl statements be used in pl/sql?

0 Answers  

---

Can we use threading in pl/sql?

0 Answers  

---

What is the difference between Union and Union all. Which is faster.

0 Answers  

---

What is graph sql?

0 Answers  

---

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,

---

What is a self join ?

6 Answers   BirlaSoft,

---