![240](https://upload.jianshu.io/users/upload_avatars/1080281/14dab04d90a7.jpg?imageMogr2/auto-orient/strip|imageView2/1/w/240/h/240)
IP属地:吉林
select dbms_lob.substr(a.remarks,1,10000) from t00_test a;
参考截图中写的存储过程,利用游标遍历对象,通过中间表过渡。
select * from v$sql_bind_capture a where a.sql_id='aaa';
一、查看索引是否是本地还是全局 dba_part_indexes中LOCALITY字段
select * from bb where regexp_like(id,’^+?[1-9][0-9]*$’);