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
Is primary key an index?
How do I run pl sql in sql developer?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What are the usages of sql?
Why is theta join required?
How do you optimize a stored procedure in sql?
what are the advantages of sql ? : Sql dba
How to Execute a Package in PL/SQL.?
Which is faster union or join?
In a distributed database system, can we execute two queries simultaneously?
What are some emotional triggers?
what is the difference difference between procedure and packages
Can you do multiple joins in sql?
What is trigger and types?
How do I tune a sql query?