Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Data Types Question.
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