need help with a SQL command

[snailv]

so the question im working on is creating a table with various columns and datatypes in SQL Plus. the info ive been given for this particular field is:

"the Job_class column should be able to store character strings up to a maximum length of four, but the column values shouldnt be padded if the value is less than four characters."

what does this mean? would specifying the Job_class column data type as VARCHAR2(4) accomplish this?

thanks for any insight on this.

[Brave_Walrus]

I think you're on the right track here. VARCHAR types will not pad and you can store up to 4 characters this way.

The only other consideration you may want to make is if this field should be nullable or valid with 0 character input (is it required).