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 meant by truncate in sql?

0 Answers  

---

How is data stored in sql?

0 Answers  

---

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

0 Answers  

---

What are the different types of functions in sql?

0 Answers  

---

What are primary key and foreign key and how they work?

0 Answers  

---

What is having clause in sql?

0 Answers  

---

How do I delete a trigger?

0 Answers  

---

How do you update sql?

0 Answers  

---

difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

4 Answers  

---

What is the execution plan in sql?

0 Answers  

---

what is External tables? explain with examples

2 Answers   TCS,

---