Converting CLOB to VARCHAR2 in SQL

I wanted to convert a CLOB type column in VARCHAR2 and use the same in a query. Below is a simple way using substr and to_char. Using this approach you can use the CLOB type like any VARCHAR2 column.

SELECT to_char(substar(CLOB_COLUMN,1,100)) error FROM table_name
WHERE to_char(substar(CLOB_COLUMN,1,100)) LIKE'%ORA%'