What is difference between CHAR and VARCHAR2?What is the
maximum SIZE allowed for each type?

Answer Posted / thilaga

char 2000 byres, varchar 4000 bytes

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

563


Does sql backup shrink transaction log?

563


What is the main reason behind using an index?

560


How do I create a sql database?

528


How to disable a trigger name update_salary?

680






in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

1649


What is 19 null in sql?

540


How can triggers be used for the table auditing?

598


Write the command to remove all players named sachin from the players table.

748


What is left join example?

506


What is clause?

617


How can you tell the difference between an index and a view?

497


When is a declare statement required?

677


explain commit and rollback in mysql : sql dba

551


When to use inner join and left join?

530