What is the difference between CHAR and VARCHAR2? If
VARCHAR2 serves the uses of CHAR why CHAR is still used and
not been discarded yet?
- 9 Answers
- 16865 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / masthan
create table test(aa char):=by using char create the table with out spicifing the lengh(by default it will create lenth 1)default size is 1 byte
by using varchar2 with out spicifing the lengh we cont able to create the table.There is no default size
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the differences between implicit and explicit cursors?
How do I create an index in word?
Why is partition used in sql?
Which are sql * plus commands?
What do you understand by exception handling in pl/sql?
What is difference between sql function and stored procedure?
Can we insert delete data in view?
What is the use of prepared statement?
How to display the records between two range in Oracle SQL Plus?
How will you distinguish a global variable with a local variable in pl/sql?
How many types of triggers exist in pl/sql?
How insert into statements in sql?
Which is better varchar or nvarchar?
Can we perform dml in function?
What is a scalar value in sql?
