SQL & PL/SQL

Hi ALL,

I have a table app_news_likee.

Column Name ID Pk Null? Data Type Default Histogram Encryption Alg Salt

TITLE 1 Y VARCHAR2 (2000 Char) Yes
CONTENT 2 Y VARCHAR2 (2000 Byte) Yes
START_DATE 3 Y DATE Yes
END_DATE 4 Y DATE Yes
CREATED_BY 5 Y VARCHAR2 (8 Byte) Yes
CREATED_TS 6 Y DATE Yes
NEWS_LINK 7 Y VARCHAR2 (100 Byte) Yes
NEWS_URL 8 Y VARCHAR2 (256 Byte) Yes
BANNER 9 Y CHAR (1 Byte) Yes


I would like to modify the column BANNER to varchar2(1BYTE) instead of CHAR (1 Byte) without affecting the existing records.

I tried

alter table app_news_likee modify BANNER VARCHAR2(1BYTE) ENABLE NOVALIDATE;

It errored out saying : missing keyword

Am I missing something here?


Appreciate your help!

Thanks in advance!
BM