Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 18316 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 is composite primary key in sql?
What does varchar include?
Can dml statements be used in pl/sql?
What is foreign key in sql with example?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is record data type?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
what is unique key constraint? : Sql dba
what is data control language? : Sql dba
What are the advantages of pl sql over sql?
What are the most important characteristics of pl/sql?
What are two statement types in sql?
What makes a good primary key?
What is varray in pl sql?
What is difference between pl and sql?
