put Blank in INTEGER Datatype oracle

6.3k Views Asked by At

I have to put blank i.e '' into a column of INTEGER Data type. I do not have to put NULL into it. The requirement is to put blank ''.

1

There are 1 best solutions below

2
On BEST ANSWER

NO, you can not since it's INTEGER datatype. Either it will have numbers (0,1,2,...,n) or NULL. If you want to store string literal then choose a string datatype like VARCHAR.