0

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

3
Contributors
4
Replies
5
Views
5 Years
Discussion Span
Last Post by seslie
0

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

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.