--Select all rows that have a punctuation mark in the text1 column
select text1
from test2
where regexp_like(text1,'[[:punct:]]')
/

--Select all rows that have an alphabet in the text1 column
select text1
from test2
where regexp_like(text1,'[[:alpha:]]')
/

--Select all rows that have a digit in the text1 column
select text1
from test2
where regexp_like(text1,'[[:digit:]]')
/

--Select all rows that have alphanumeric (alphabets and numbers) in the text1 column
select text1
from test2
where regexp_like(text1,'[[:alnum:]]')
/

Oracle LazyDBA home page