I have some confusion about this question, Max(sysdate) - Min(sysdate) i think the answer is zero but give some detail description about this.....!

Kalpana Mooraka

 Profile Answers by Kalpana Mooraka Questions by Kalpana Mooraka

• Oct 5th, 2011

SQL> select max(sysdate)-min(sysdate) from dual;

MAX(SYSDATE)-MIN(SYSDATE)
-------------------------
0

SQL>

Ramesh hurakadli

• Oct 3rd, 2011

Result of Max(sysdate)-Min(sysdate),it means, it shows the date which is in between last date n first date of the month according to the system information.

Answer Question  Select Best Answer

shaik shamsheer

• Dec 28th, 2011

In case of varchar it store upto 2000 bytes and in case of varchar2 it stores 4000 bytes
varchar is occupies space for the null value and varchar2 does not occupy space for null values.

venkat

• Dec 4th, 2011

"varchar" allocates memory in dynamic fashion where as "varchar2" also allocates memory in dynamic fashion but it also supports garbage collection.
"varchar" is developed along with SQL where as "varchar2" is developed by Oracle.

Answer Question  Select Best Answer