CLOB size matters! Mustafa, 2019-07-312020-07-05 Hi, Many developer and DBA has an idea about the storing clobs. Basic rule is “if length of clob is higher tan 4000 then it will be stored in lob segment not in table segment” which is correct but sometimes misinterpreted! if you have a clob column in your table,… Continue Reading
ORA-00942: table or view does not exist and sequences as default value Mustafa, 2019-07-232020-07-05 Hello, after 12c or above we are able to set sequence’s nextval as the default value of an ID column. One of my customer started to complain about the ORA 00942 (table or view does not exist) error even if they have all necessary privileges on the table. After a… Continue Reading
How to Get Your SID? USERENV vs V$MYSTAT! Mustafa, 2019-05-232020-07-05 Hello everyone, This is an easy question. How to find your own session SID and when you ask Google for it, you will find many answers. While reading some documents, I realized that some Gurus are using V$MYSTAT to get current SID: Oracle PL/SQL select sid from v$mystat where rownum=1; 1 select sid from v$mystat where rownum=1; I always prefer USERENV(‘SID’) context to get… Continue Reading