Tags » SQL Developer

SQL Developer : Add Custom SQL Query as Template.

Daily for SQL plan reading and analysis, using below command quite often from SQL Developer Tool.

explain plan for statement_id = '';
select * from gv$sql where sql_text like '%%';
185 more words

Helper SQL

Install SQL Developer on Ubuntu 16.04 or Elementary OS Loki

Install jdk


Download the necessary jdk for your flavor of linux 32 or 64 bit.  You can use alien to convert the rpm to a deb installer or just download the .tar.gz file and follow the steps below. 519 more words

Elementary OS

That Time the Parens "Almost" Got Me

As a developer, there are days when you pat yourself on the back for the cool, innovative code you wrote, and smile at how clever you are. 454 more words


Reshaping Parse Trees


Parsing and internal parse structures — trees — are not something that development tools readily expose. It is assumed that most users are comfortable with numerous features that depend on parsing, such as formatting, code block collapsing/expanding, code advisors and so on, but aren’t really interested learning the formal code structure. 616 more words

SQL Developer

OOW16: Day 0 - Something Wicked This Way Comes

I’m calling today “Day 0”, as it’s the day before OOW and nothing is really planned for Saturday. Exhibitor booths get built, conference goers check in, and OOW begins to really descend upon the city. 645 more words


How to set SQL Developer to get desired output

SET linesize -1

SET long 80

SET pagesize 125

SET sqlformat ansiconsole

SET trimout ON

SET wrap OFF

Parmit Singh Dhurandhar

Getting started with SQL

I often get accosted by friends and colleagues who are struggling to understand the Structured Query Language popularly known as SQL and they look at me with horror when I say it is the easiest language to learn and code. 676 more words

Business Intelligence