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.

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

---

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

0 Answers  

---

Write a sql query to get the third highest salary of an employee from employee_table?

0 Answers  

---

Which one is faster ienumerable or iqueryable?

0 Answers  

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

---

Is drop table faster than truncate?

0 Answers  

---

Can there be 2 primary keys in a table?

0 Answers  

---

Why stored procedure is better than query?

0 Answers  

---

Define implicit and explicit cursors.

0 Answers  

---

What is the difference between row level and statement level trigger?

0 Answers  

---

What is the syntax to add a record to a table?

0 Answers  

---

What is secondary key?

0 Answers  

---