Spatial data in its raw format is ugly. The shapes and places it represents can be very enlightening. Here’s some raw spatial data followed by their visualization. If you worked with spatial data, what would you prefer? You can probably figure out what you’re looking at, but wouldn’t it be nice if you could get a visual confirmation? 165970530068758efdb8287_000002 To see the shapes, just right-click Map View, What’s that? Do you remember the kid’s game,…
Updated Feb 5, 2021 There are two ways you can view your REFCURSOR output from calling PL/SQL stored procedures and functions in Oracle SQL Developer. Using the PRINT command in a SQL Worksheet Using the classic SQL*PLUS PRINT command to view the refcursor output will work in SQL Developer just like it would work in your command line tools. You execute your program, you create a local variable or 3 to ‘catch’ said output, and…
If you’re looking for insight or guidance on XML, XML in the database, or XMLDB – then please keep looking. I have not much to add here. What I am here to talk about is some of the support that SQL Developer offers for XML in the database. You may have heard me say ‘I do not like XML.’ What I mean by that is ‘I do not like poor design decisions, and XML seems…
I’ve already discussed how the Rebel scum go about figuring out what’s wrong with their code. Now I want to get into the nitty-gritty details of how to start a debug session in SQL Developer. There are some prerequisites, but I promise it won’t take but a few moments to setup. Ensure that you have been granted the DEBUG CONNECT SESSION priv you have EXECUTE privs on DBMS_DEBUG_JDWP you have EXECUTE privs on the object…
Here is a 2 second tweak that I recommend for all users of Oracle SQL Developer. Open Tools – Preferences Database – Worksheet – ‘Grid in checkerboard or Zebra pattern’ – toggle ON Now run a query in the worksheet or open a table in the browser If you’re going to be staring at data for hours on end, give your eyes a break and mix it up a bit!
Can you tell us more about the debugger? Can you show us the debugger? What about the debugger? Can you spell ‘debugger’? Why can’t the debugger show X? What is COMPILE WITH DEBUG anyway? Debugger? Skip to Episode V – Starting the Debugger In the past 10 years I have probably heard these questions and countless variations more than any other when it comes to the topic of PL/SQL interactive development environments (IDE.) Debugging seems…
Most third generation language (3GL) IDEs have trained hackers like me to expect the tool to write some of the code for them. Regular internet folks are already used to having search terms and URLs auto-completed in their browsers. I don’t want to get into a debate over whether this makes us lazier AND dumber, but I DO want to give you a quick overview of what SQL Developer can do in this area. If…
Updated 9/28/2018 Writing Code is for Suckers Yes, I’m joking, mostly. But if you’re in a tool, and it can help you save time, then why not? Here’s a simple scenario: building a SELECT statement for one or more tables/views. Dragging and dropping tables to the worksheet is a pretty obvious feature – it copies the object names over for you. But did you know you had the option to get more bang for your…
Want multiple scratch pads for your queries? Have a hundred+ line stored procedure? Then here are two tips for you! Side-by-Side Worksheets To get started you’ll need at least two worksheets open. So something like this Next, you can either click and drag the 2nd worksheet tab to the right or underneath. If you drag right you will get something like this – If you’re having problems getting the panel to drop just as you…
This is turning out to be a bit harder to write than I orginially thought. I generally land in the laissez-faire camp, and I know what you’re thinking: “Jeff, we didn’t come here to read French!” Sorry about that, bad habits picked up from 4 years of public education instruction. In terms of American politics, think of me as the Ron Paul of database security folks. Set a user up to be able to do…