Tags » SQL Developer

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

How to Change SQL Developer Default Language ?

To change SQL Developer Language in English Language need to do following think.

Find the path of oracle installation of SQL developer

EX:  C:\app\Client\product\12.1.0\client_1\sqldeveloper\ide\bin\ide.conf

Add/Change following Statement

AddVMOption -Duser.language=en


SQL parse time issue - use "minified hinted outlines"

problem description

Recently I encountered a simple looking query that returned a very small result set, but used to take more than 5 seconds time to execute. 1,945 more words