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

Temporary segments are created by ORACLE when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segment extents are released to the system for future use.

manish hoiyani

• Sep 14th, 2006

temporary segments are basically used for sort operations in oracle,,when the user tries to execute the query through order by clause. so system needs an space for an sort operation, and system   will use temporary segments  for this query.

manu

• Apr 7th, 2006

  To execute any program in Computer it needs memory area(RAM), Oracle allocates some memeory  for processing SQL statement. After execution this memory is released for future use. This one call Temporary work area.

Answer Question  Select Best Answer