Informatics Practices
Write one similarity and one difference between CHAR and VARCHAR data types.
SQL Queries
3 Likes
Answer
One similarity between the CHAR and VARCHAR data types in SQL is that both are used to store character data.
One difference between the CHAR and VARCHAR data types in SQL is that the Char datatype specifies a fixed length character string, while the Varchar datatype specifies a variable length string.
Answered By
2 Likes
Related Questions
Write the UPDATE command to increase the commission (Column name : COMM) by 500 of all the Salesmen who have achieved Sales (Column name : SALES) more than 200000. The table's name is COMPANY.
While using SQL pattern matching, what is the difference between '_' (underscore) and '%' wildcard symbols ?
Write SQL statement to display
Today, the date is <current date>Write a command to add a NOT NULL constraint on FEES column of a student table.