i need to create a table which has number of columns in which one column is varchar2 type.Now the problem is i need to set that particular column should support only alphabets.
I've tried this code but this didn't get work can anybody help me!

thanks in advance!

```
CREATE TABLE test_1
(
  test_id number,
  test_name varchar(50),
  CONSTRAINT name_test
  CHECK (test_name where regexp_like(test_name,'^([aA-zZ])+$'))
);

```