CODEWITHSUNDEEP
oracle11goracle12c
Kishanu Bhattacharya
Kishanu Bhattacharya

Reputation: 97

Converting NUMBER data type to BIT in Oracle

I have a requirement where I need to change the column data type to BIT. As of now its in NUMBER. I know that Oracle does not support BIT data types, just curious to know if there is any alternatives to achieve this.

Thanks ! Kishanu.

Upvotes: 0

Views: 1915

Answers (1)

Kishanu Bhattacharya
Kishanu Bhattacharya

Reputation: 97

Thanks for your suggestions and advises. As I mentioned I tried with CHAR(1) and the application accepted the change for the particular column. I don't know how it worked but now the server is getting started.

Upvotes: 1

Related Questions