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
- 15726 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 different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
How to display the records between two range in Oracle SQL Plus?
What are the parameter modes supported by pl/sql?
what are all the common sql function? : Sql dba
What is varray in pl sql?
What does 0 mean in sql?
What has stored procedures in sql?
What are the different types of dbms?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
how to create a table index in mysql? : Sql dba
What is union and union all keyword in sql?
What are pl/sql cursor exceptions?
What are the types of variable use in pl sql?
What is not null in sql?
How to run sql*plus commands in sql developer?
