Binary Large Objects – otherwise known as BLOBs. You’ve also got large objects which are composed of text – that would be a CLOB. If you hear people talk about LOB storage, they are referring to how the data in these fields are stored – outside the space reserved for the regular segments (table data.) BLOBs are frequently used to store data such as pictures in the database. You can pretty much store anything in…
Updated June 2015, current for version 4.1 There are too many options in our every day lives. We love asking for more options, but I often find myself being overwhelmed by the number of questions I have to answer before I can accomplish very mundane tasks. Do you want your latte ‘skinny’ or your cappuccino ‘wet?’ Waffle House customers are probably familiar with ‘capped, covered, smothered, & covered’ routine. Do you want a receipt with…
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 had to be in there somewhere. This is a pretty basic setting for any word…
Image Left, Text Right It starts out OK, even fine really. Text here, should be up top and from the left, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah,…
If you’re here to read another pro or con Klout rant, then please go somewhere else. I consider Mark Schaefer’s blog series to be the definitive take on the whole Klout business. I like Klout, and I use Klout. If you fall into this camp, please continue. Did you know that Klout has lists? You may have ignored them. And I wouldn’t blame you one bit. See, we’ve been trained to think that lists are…
View – Recent Objects will show you a list of objects you have click into via the explorer. If you need to keep a diary of objects you’ve messed with for the day, then this might do the trick. No, it doesn’t track what you did to the objects, but it does leave some bread crumbs for you to snack on later. You can invoke the object action lists directly from the panel, or if…
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? 68985118369997934adcf0_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…