oracle 10g starter

[rithish]

hello iam started taking oracle 10g i have few doubts please clear me for example
create table employee
(ename varchar2(10),salary number(7,2));
what is the use of varchar compared to character???
what is number(7,2) i mean 7,2 i dont understand please explain me

[seslie]

Hello rithish,

what is the use of varchar compared to character???

CHAR and VARCHAR2 types are used to store character string values, although they behave very differently. CHAR stores fixed length character strings while Varchar stores variable length strings.

see this and this

what is number(7,2) i mean 7,2 i dont understand please explain me

Well basically, you defined a column with a datatype 'number' that has a constraint. 7, 2 simply means that 'Allow the user to enter any number, 7 'characters' long and decimal, 2 'characters' long.. so you can have something like this, 1234566.00

[debasisdas]

You need to read this to understand the basics.

[rithish]

i have a doubt if i give commit database files are stored somewhere.where the files r stored?????/

[seslie]

Hey there,

checkout this and this