oracle有没有可以用来保存长字符串的类型，varchar有长度限制

Question

oracle有没有可以用来保存长字符串的类型，varchar有长度限制

Answer 1

可以使用Clob类型，可参考https://blog.csdn.net/jungeCSND/article/details/112567383?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522165916442316782248534346%2522%252C%2522scm%2522%253A%252220140713.130102334..%2522%257D&request_id=165916442316782248534346&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~baidu_landing_v2~default-2-112567383-null-null.142^v35^pc_rank_34&utm_term=cloub&spm=1018.2226.3001.4187