Split String using Oracle PL/SQL
Oracle PL/SQL provides various string functions, but there is no direct function to split a string into substrings, we need to write a custom code to do this task.
Posts Tagged ‘pl/sql procedure’
File contents into BLOB in Oracle Database, using PL/SQL
Often there will be a requirement for reading .out files generated by Oracle Applications and converting into pdf files and send as mail attachment. Here is a sample PL/SQL procedure which can read a file from a specified location, into a BLOB and returns it. The calling program can convert this blob data [...]
