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?
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 is pl sql in oracle?
Can we use two order by clause in query?
define sql delete statement ? : Sql dba
Can you inner join the same table?
How to set up sql*plus output format in oracle?
Can you do multiple joins in sql?
What happens when a trigger is associated to a view?
Is grant a ddl statement?
how to write date and time literals? : Sql dba
What are pl/sql packages?
What is the difference between inner join and natural join?
How many types of literals are available in pl sql?
How do you delete data from a table?
What is the use of <> sql?
Explain foreign key in sql?