updating char in Oracle 10g
how do you update a char in 10g
Software/Hardware used:
Software/Hardware used:
ASKED:
January 5, 2010 11:37 AM
UPDATED:
January 5, 2010 9:21 PM
Answer Wiki:
To update a CHAR column:
<pre>UPDATE your_table
SET your_char_column = 'X'
WHERE ...;
</pre>
If that's not what you mean, please provide more details.
To see all answers submitted to the Answer Wiki: View Answer History.
SQL> update operator set char_REVOKFLG=’0′ where login like ‘ospprov’;
update operator set char_REVOKFLG=’0′ where login like ‘ospprov’
*
ERROR at line 1:
ORA-00904: “CHAR_REVOKFLG”: invalid identifier
the column Name= REVOKEFLG Type= (char(1) . Please note the above result.
If the column name is REVOKFLG, then you should use that column name and not char_REVOKFLG.