Member Avatar for 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

  • 3 Contributors
  • 4 Replies
  • 167 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by seslie
Member Avatar for 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

Member Avatar for debasisdas

You need to read this to understand the basics.

Member Avatar for rithish

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.