⟩ What is difference between CHAR and VARCHAR2? What is the maximum SIZE allowed for each type?
CHAR pads blank spaces to the maximum length.
VARCHAR2 does not pad blank spaces.
For CHAR the maximum length is 255 and 2000 for VARCHAR2.
Question and Answer:
Home SQL
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
What is the default ordering of an ORDER BY clause in a SELECT statement?
You are joining a local and a remote table, the network manager complains about the traffic involved, how can you reduce the network traffic?
You want to determine the location of identical rows in a table before attempting to place a unique index on the table, how can this be done?
How do you prevent Oracle from giving you informational messages during and after a SQL statement execution?
How do you prevent output from coming to the screen?
How do you generate file output from SQL?
How do you set the number of lines on a page of output? The width?
Tell me what is SQL Server VSS Writer?
Please explain why would you call Update Statistics?
How to start SQL Server in different modes?
