Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Why is long an issue with Oracle?

Why is long an issue with Oracle?

It will be better if some one can tell me what are the issues with using the long data type in oracle? something related to storage?

I was asked this in an interview.

like image 905
Egalitarian Avatar asked Dec 14 '25 21:12

Egalitarian


1 Answers

LONG is archaic and deprecated, and has been superseded by CLOB. There are lots of restrictions with LONGs and they are difficult to manipulate in SQL. So while you may have to deal with them in old databases, you would be unwise to ever use a LONG column in a new table.

like image 50
Tony Andrews Avatar answered Dec 18 '25 09:12

Tony Andrews



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!