All pastes #545336 Raw Edit

Unnamed

public text v1 · immutable
·published 2007-06-06 19:38 UTC
rendered paste body
SQL> describe cop_profile_fields_data;
 Name                                                                          Null?    Type
 ----------------------------------------------------------------------------- -------- ----------------------------------------------------
 USER_ID                                                                       NOT NULL NUMBER(8)
 pf_institution                                                                         VARCHAR2(255)
 pf_inst                                                                                VARCHAR2(255)
 pf_in                                                                                  VARCHAR2(255)

SQL> alter table cop_profile_fields_data drop column pf_in;
alter table cop_profile_fields_data drop column pf_in
                                                *
ERROR at line 1:
ORA-00904: "PF_IN": invalid identifier