Oracle varchar2 minimum length

Question

In Oracle db we have a table with varchar2 type of column (for example USERNAME). How can I set a exact (or at least minimum) length for this column? So that all usernames inserted into this table can be only 10 (or have to be at least 10) characters long.

skaffman · Accepted Answer · 2010-07-28 15:05:11Z

11

You could use a check constraint:

CREATE TABLE mytable (
  mycolumn varchar2(50),
  constraint strlen check (length(mycolumn) > 2)
)

Or something similar. I'm not sure how performant this is, though.

answered Jul 28, 2010 at 15:05

skaffman

405k96 gold badges825 silver badges775 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ShoeLace Over a year ago

i assume you meant to say.. replace the '2' with your minimum size.. yes?

DilanG Over a year ago

@ShoeLace yes you have to

William Robertson · Accepted Answer · 2010-07-28 18:11:28Z

-1

Or just for fun,

CREATE TABLE testit
( mycolumn VARCHAR2(20) CONSTRAINT min_length_chk CHECK (mycolumn LIKE '__%') );

It's less explicit than the LENGTH() approach though so I'm not sure I'm recommending it except as an idea for related issues.

answered Jul 28, 2010 at 18:11

William Robertson

16.1k4 gold badges40 silver badges49 bronze badges

Collectives™ on Stack Overflow

Oracle varchar2 minimum length

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related