Oracle Developer's Share

oracle form error

try use utl_smtp send through gmail by plsql

create view with parameter pick date without day picker

When we use nvl function for between clause with the date data type. If you may have this question when you execute it in the tools like Toad.

oracle collection array varray by index or nested table.Difference between binary_integer and pls_integer.Varchar2 Char Long ROWID

透過DBMS_LOB將Xml資料匯入，再透過TABLE EXTRACTVALUE的方式去解析，若是巢狀結構，就用XMLTABLE去解析，並解決xmlns xmlnamespaces的問題

Oracle user responsiblity

Oracle

oracle tablespace

Oracle space