ThatJeffSmith

Category: Database Stuff

On SQL Developer and TNSNAMES.ORA

Tnsnames.ora [DOCS] is a configuration file for SQL*Net that describes the network service names for the databases in your organization. Basically, it tells Oracle applications how to find your databases. This post is just a quick overview on how to get SQL Developer to ‘see’ this file and define a connection. There’s only a single […]

Similar Posts by Subject Areas: , , ,

Oracle SQL Developer is for Oracle Database

What is Oracle SQL Developer? Well, according to this document on OTN… What is SQL Developer? Date: May 2014 Oracle SQL Developer is the Oracle Database IDE. A free graphical user interface, Oracle SQL Developer allows database users and administrators to do their database tasks in fewer clicks and keystrokes. A productivity tool, SQL Developer’s […]

Similar Posts by Subject Areas: , , ,

Oracle SQL Developer: Fetching SQL Statement Result Sets

Running queries, browsing tables – you are often faced with many thousands, if not millions, of rows. Most people are happy with looking at the first few rows. But occasionally you need to see more. SQL Developer doesn’t show you all records, all at once. Instead, it brings the records down in ‘chunks,’ or as-needed. […]

Similar Posts by Subject Areas: ,

Migrating Oracle SQL Developer Connections (with Passwords!)

So you just got your brand new machine at work. Party time, excellent*! Amazon.com Widgets And, your friendly neighborhood IT guy even moved over all of your softwares, including SQL Developer. But when you go to use it, none of your connections are there. Or maybe the connections are there, but the connection passwords ARE […]

Similar Posts by Subject Areas: , , , ,

Exporting Multiple BLOBs with Oracle SQL Developer

BLOBs are cool. Optimized such that you can store files basically in the database, with the power of SQL AND no performance hit. That sounds like a pretty good deal. I get asked questions a lot about accessing BLOBs once they’re in the database. And that’s led to quite a few posts here on the […]

Similar Posts by Subject Areas: , ,

Oracle SQL Developer Reporting 101

150 of my closest friends, or some random people on the Internet, joined me today while we talked all about SQL Developer’s reporting feature. Did you miss it? If so, I’m guessing you’re not a member of ODTUG. They put on free webcasts for everyone in the Oracle technology space. If you’re a member, you […]

Similar Posts by Subject Areas: , , ,

Oracle SQL Developer Picture Puzzle: What is that?

Oracle SQL Developer Key Features

Sometimes while I’m demonstrating Oracle SQL Developer, something on the screen catches the eye of someone in the audience, and they just have to know ‘what is that?’ So I put together the image you see above with a few key features highlighted. These might be things you’ve missed because they’re not default preferences or […]

Similar Posts by Subject Areas:

How To Add Custom Actions To Your User Reports

I’ve shown you and more than a few customers how to customize your Monitor Sessions page/report. If you need a refresher, that’s here. But basically it comes down to this: Copy the report from the Database Administration section of the Reports panel Paste it to the User Defined Reports section Edit to your heart’s delight […]

Similar Posts by Subject Areas: , , , ,

How to Preserve System Generated Constraint Names in Oracle SQL Developer Data Modeler

The risk of posting a question here, is that I might take it and turn it into a blog post. And that’s where today’s topic comes from. I imported data dictionary into SQL data modeler and cannot found out how to disable predefined constraint names. Table “T” was created in database without specifying primary key […]

Similar Posts by Subject Areas: ,

SQL Developer Quick Tip: Extended Paste

Someone on the Twitters was lamenting they had accidentally clobbered their code when they ‘copied over it’ in their clipboard. So basically you cut your code – it goes to clipboard, you copy something else, the :new replaces the :old. But. SQL Developer keeps an Extended Clipboard. It’s just what it sounds like. We keep […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , ,