News

Worst case scenario, roll your own PL/SQL split function based on a Java stored procedure using Java string functions to do the splitting.<BR><BR>Oracle could probably capture some serious ...
Procedures for Embedding HTML in PL/SQL. A clear delegation of work exists between the HTML and PL/SQL in your company's Web pages: PL/SQL code fetches and manipulates data from SQL databases, and ...
When you use SELECT in a PL/SQL block, it’s important to make sure that exactly one row will always be returned by your query. If more than one row is returned, the TOO_MANY_ROWS exception occurs.
T-SQL isn't particularly well suited to advanced string manipulation. I have found that small CLR functions that perform string manipulation and substring extraction perform very well in SQL Server.