In earlier times you were always forced to use DBMS_LOB package. Then in Oracle 10g a feature called “SQL semantics for LOB” was introduced and now you can use the simplified syntax. In CREATETEMPORARY you can specify the duration of the LOB in SQL semantic you cannot. In your case the LOB is freed in … Read more
We had to make a quite similiar decision a few months ago. We were using WinForms, the Microsoft Composite UI Application Block and DevExpress WinForms. For our new application, created new from scratch, we decided to use WPF (without PRISM) and we were especially in need of some grids, so we used DevExpress WPF Controls. … Read more
A CLOB stores character data encoded in the database character set. A NCLOB stores character data encoded in the national character set SELECT parameter, value FROM v$nls_parameters WHERE parameter LIKE ‘%CHARACTERSET’ will show you the database and national character sets of your database.