IN ORACLE MILIEU …

Beyond Knowledge

Daily Archives: March 13, 2008

Using TABLE_TO_COMMA in PLSQL

Some times the situation arises where we want to output the result from the table as a comma separated string. This situation can be answered using many methods. The most efficient method, however, is using TABLE_TO_COMMA procedure of DBMS_UTILITY package. Below is the example that I encountered. set echo on serveroutput on declare cursor c1 [...]

Follow

Get every new post delivered to your Inbox.

Join 130 other followers