Vertical tabs are absolute good for big monitors. I think it’s a killer feature for any conmporary IDE, still only few implement it. Unfortunately there’s no option in Oracle SQLDeveloper to switch to vertical tabs. But there’s a feature request for vertical tabs. So please vote for it! It’s pity, but let’s face the truth […]
I’ve already covered the tough question on converting arbitrary query to clob delimited text (Take 1 and Take 2). The resulting function used a code snippet that produced a list of column names and their datatypes in it’s intestines. Based on that snippet here’s a SQLDeveloper user reports that produces a list of column names […]
The best trick learned is to changed default syntax highlighting to more readable one. Read an article here peoplesofttipster.com/sql-developer.
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 […]