Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Data Types Question.
Jimmy wrote:
>
> Hello all,
>
> Could anyone tells me what is the differences between data types VARCHAR2, VARCHAR and
> CHAR? Which data type is the best?
>
> And in SQLPLUS, I know that if I delete a record from the table, I need to type commit so
> that the record is actually delete from the table. Is there a option in SQLPLUS such that I don't
> need to type commit? And what will happen if I exit SQLPLUS after the delete statement?
>
> Thanks,
> Jimmy
Hi,
CHAR is a fixedsize datatye (max:255 bytes)
VARCHAR is GOING replace with VARCHAR2 in future (ANSI SQL )
VARCHAR2 is variable size datatype (max:2000 bytes in oracle7 and
4000 bytes in oracle8).I prefer VARCHAR2 over CHAR datatype.
Hope This Helps
AMARENDRA
-- AMARENDRA B NETTEM Oracle Certified DBA (OCP) WHITTMAN-HART INC., CHICAGO Homepage : http://www.iit.edu/~nettama E-mail : anettem_at_whittman-hart.com nettama_at_charlie.cns.iit.eduReceived on Sun Dec 28 1997 - 00:00:00 CST