ThatJeffSmith

Tag: worksheet

Quick Hit: Number of Rows Returned By a Query

Question: How can I make SQL Developer display the number of rows returned by a query? Answer: Execute the query, and fetch all the rows. But I’m not seeing it! and fetch all the rows. This part is important. Execution using ctrl+enter executes statement, and returns the FIRST ‘fetch’, by default of 50 records. First […]

Continued Improvements to [Code] Completion Insight

A few weeks ago I published a story highlighting all of the different ways SQL Developer can help you with your code. That post generated a lively discussion around this: Pre Version 4.1 Let’s try that again: Version 4.1 Early Adopter 2, specifically We’re also making sure to sort the local schema objects ALWAYS to […]

Oracle SQL Developer: Code on Demand

I’ve recently spent a few hours debugging some user defined reports. A post on how to add trace/disconnect context menus to a session report required that I figure out what session my worksheet was running under. The code was easy… SELECT SYS_CONTEXT (’USERENV’, ‘SID’) FROM DUAL; …but I’m lazy. So this: The Setup Open your […]

Unshared Worksheets in Oracle SQL Developer 4

My alternate title for this post was How to get the DBAs’ attention with lots and lots of connections in her database. But I decided to go with substance over style instead. Anyways, let’s talk about connections in SQL Developer for a bit – you know you need the refresher! By default, connecting to a […]

Clickable Error Messages in Oracle SQL Developer v4

So you’ve got your monster script you’re running in SQL Developer and you run into some errors. Wish it were easier to jump to the line where said errors are being reported? Well in Oracle SQL Developer v4, your wish is our command. Just Click on the Highlighted Blue Error Text in the Output Panel […]

SQL Developer v4 Quick Hit: Split Worksheets

One of the cooler features SQL Developer offers is the ‘split document.’ If you don’t know what I’m talking about, please take 90 seconds and read this short post first. Ok, well that worked well for pretty much every type of editor in SQL Developer save one – the SQL Worksheet. Let’s say you wanted […]

SQL Developer: I’m Looking at a Record, How Do I Edit It?

You’re doing some data clean-up, or maybe you’re just trying to answer a business question for a user, and you notice the data doesn’t look quite right. You want to click in that ‘(null)’ cell and tell the world that Tyler and Perry composed that song! But, we’re in a query result set, and not […]

Monitoring Scripts as They Execute in Oracle SQL Developer

Interesting question from the forums: I’m doing multiple Inserts on a table using a script file (.sql) in SQL Developer. Since it has a lot of statements, I would like to check the progress of it somewhere in the application window. But I don’t see any progress of lines being displayed anywhere. The focus simply […]

How to Plug vi into Oracle SQL Developer

Love vi? Prefer emacs? Want the power of the 80’s added to Oracle SQL Developer? You can do that via our External Tools feature. And you can even have SQL Developer throw over your open file into vi, edit it, save it, and refresh the buffer in the worksheet to reflect the file changes. Here’s […]

Oracle SQL Developer Quick Hit: Paren Matching

Today’s Question: Does anyone know of an editor (or program) that will match beginning and ending parentheses in sql and highlight an ending paren that is missing? It just so happens that I do know of such an amazing editor or program I’ll let the pictures do the talking for me this afternoon: Matched Parens […]

A SQL Developer Primer: Open a New Worksheet

The Worksheet in Oracle SQL Developer is your primary interface for writing and running your SQL and PL/SQL code. As you can imagine, I’ve already written quite a bit about how the worksheet ‘works’. Today I want to spend just a few moments explaining the two different buttons for launching a new worksheet. With a […]

Formatting Keywords to UPPERCASE In Oracle SQL Developer

I received this question from a customer today, and it took me more than a few minutes to remember where this preference was located in SQL Developer. This tells me that the topic is ripe for blogging How do I go FROM: SELECT * FROM scott.emp WHERE ename LIKE ‘%JEFF%’ TO SELECT * FROM scott.emp […]

Running & Managing Concurrent Queries in SQL Developer

We’ve all been there – you’ve managed to write a query that takes longer than a few seconds to execute. Tuning aside, sometimes it takes longer than you want for a query to run. So what’s a SQL Developer user to do? I say, keep going! While you’re waiting for your query to finish, there’s […]

Related Posts Plugin for WordPress, Blogger...