Help in using select ... where clauses

Please help. I'm a new Oracle user, using personal Oracle 7... I simply want to load values from an existing table to a new table but SQL keeps choking on such basic statements as

        where field1 = 'a_value'

which seems like correct syntax from my reference books. This is my whole structure:

create table t_list
(

p_name	varchar2(80)
p_text	varchar2(80)

P_type is a valid field in the source table, but SQL keeps flagging my = INI value, whether I use single quotes, double quotes, parenthesis or reconstruct the clause with a "like" rather than the "=" statement. These are the error messages I get:

		ORA-00904: invalid column name
		ORA-00911: invalid character

Why doesn't SQL like this code?

I would greatly appreciate any help. email me at choward_at_cdmi.com

                        Carlos Received on Fri Nov 08 1996 - 00:00:00 CET