How do I search for underscore? 1

[ModelTrains]

I am using Oracle 8i via SQL Plus on a Windows PC.

I need the following information:
table_name, column_name, nulls?, column_type, length

I am doing a SELECT on dba_tab_columns, but I would like to exclude temporary columns that will be used to convert data from the old system to the new system. These conversion columns start with "C_" as the column_name.

If I select where column_name not like 'C_%', it excludes ALL columns that start with the letter "C", not just "C_".
Also not working: column_name not like 'C\_%'

Here is a sample table. I would only like to list the city_key and name columns.

TABLENAME: CITY
city_key number (8) (primary key)
name varchar2 (30)
c_old_city_cd varchar2 (5)

I have access to the V$ views, but I have never used them before. Thanks in advance for your help!

 

[swampBoogie]

column_name not like 'C\_%' escape '\'

 

[ModelTrains]

It worked! Thanks!