Below you'll find a list of all posts that have been tagged as “ide”
You know how every TV show has to have that Christmas themed episode? No? Well, in the US, it’s pretty common. And as a child of the 80’s television, my brain has been properly warped. So here is your Christmas themed SQL Developer ‘trick.’ Every look under the tree, and your first reaction is to be a little disappointed in …
For some reason I decided to re-join a discussion in the SQL community from way back in 2012. THIS => "tbl_ is a tell for bad database design" via @datachick http://t.co/hq2BH73xic sorry @SQLRockstar — Jeff Smith (@thatjeffsmith) May 28, 2015 Karen started it, Thomas ran with it, and I decided I had to throw my 2 cents into it as …
You may wish to store your PL/SQL code in files with file extensions other than our defaults. We ship with .klr, .pkb, .pkh, .pks, .plb, .pls as associated file types for our PL/SQL editor and for opening said files on your machine with SQL Developer. But maybe at XYZ Incorporated, you keep your package bodies in files of type .bdy …
I’m not sure if I can help with the mind part, but I can definitely add some perspective on the line numbers. Quickly, let’s define just what the ‘gutter’ is in the world of programming and database GUIs. I found a good definition on Quantum Whale, a .NET component developer, and I’m going to quote them: Gutter: The gutter area …
A question that comes up fairly frequently revolves around how to see your errors when working with PL/SQL in SQL Developer. Most folks are probably working in the worksheet – this is the default editor for your connection. Let’s take a look at this sample program CREATE OR REPLACE PROCEDURE do_nothing IS BEGIN dbms_output.put(sysdate); this should probably error OUT, RIGHT? …
Update for version 4.2 and higher. As often happens, my ideas for blog posts are provided by end users asking for help. Sometimes I know the answer, sometimes I don’t. This is one of the latter cases. Chet AKA @oraclenerd asked me: ‘Tell me how to find the preference in sqldev to make a tab 2 spaces?’ I knew it …
I stumbled upon an interesting discussion in the ODTUG group on LinkedIn this weekend. A vendor is doing some research I suppose and wanted to know who enjoyed using what IDE and why. Here’s the original question: In your opinion which is the best IDE for PL/SQL programming and why? e.g. PL/SQL Developer, Toad, Oracle SQL Developer. To participate in …