Geek Answers Handbook

Why is Oracle a problem for a long time?

Why is Oracle a problem for a long time?

Would it be better if someone tells me what are the problems with using a long data type in oracle? something related to storage?

I was asked in an interview.

+1
database oracle storage
source share
2 answers

LONG is archaic and obsolete and is replaced by CLOB. There are many limitations with LONG, and they are difficult to manipulate in SQL. Therefore, although you may have to deal with them in old databases, it would be unwise for you to use the LONG column in the new table.

+2
source share

Unfortunately, sometimes LONG are required. For example, you can read LONG from a remote database, but you cannot read CLOB. (Although you can write CLOB in a remote database.) I assume that is why they are still used everywhere in the data dictionary.

Other than this problem, you should probably always use CLOB.

0
source share

More articles:


All Articles