Monthly Archives: January 2013

Useful onliner to make testing in Oracle SQL*Developer a little bit easier

This little script helps to test subroutines using SQL*Developer Run or Debug command.  Just copy code from “Run PL/SQL” window and run the following onliner in a terminal. It uncomments legacy dbms_ouput code and extends capacity of varchar2 variables from 200 to 32767 chars. Now paste clipboard contents back into SQL Worksheet and run.

cat /dev/clipboard | perl -p -e 's//* Legacy output://g; s/*///g; s/VARCHAR2(200)/VARCHAR2( 32767 char )/g;s/^s+:.*$//g' > /dev/clipboard