Re: Data Types Question.

From: Olaf Naumann <onaumann_at_netcologne.de>
Date: 1998/01/02
Message-ID: <01bd17c1$d06eef20$0100007f@lapnau>#1/1

Jimmy <c6635500_at_comp.polyu.edu.hk> schrieb im Beitrag <34A6D834.37F9_at_comp.polyu.edu.hk>...
> Hello all,
>
> Could anyone tells me what is the differences between data types
VARCHAR2, VARCHAR and
> CHAR? Which data type is the best?

you should use varchar2 the other two are only provided for compatibility. the main difference to char is: a VARCHAR(200)-field uses (nearly) 0 bytes if it is empty, a CHAR(200) always uses 200 bytes

>
> 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?
>

if you exit it regularly an implicite commit occurs, if your pc crashes an implicit rollback occurs.

> Thanks,
> Jimmy
>
Received on Fri Jan 02 1998 - 00:00:00 CST