Re: Data Types Question.
From: AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu>
Date: 1997/12/28
Message-ID: <34A67A7E.59C0_at_charlie.cns.iit.edu>#1/1
For transaction to commit automatically
SET AUTOCOMMIT ON (by default it is off). If you want to exit the sqlplus without commit, the pending trasaction will be automatically commited.
Date: 1997/12/28
Message-ID: <34A67A7E.59C0_at_charlie.cns.iit.edu>#1/1
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.
For transaction to commit automatically
SET AUTOCOMMIT ON (by default it is off). If you want to exit the sqlplus without commit, the pending trasaction will be automatically commited.
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 CET