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 […]

Similar Posts by Subject Areas: , , , ,

30 SQL Developer Posts in 30 Days, Day 26: Keyboarding from the Editor to the Results and Back

Using the mouse sucks. You love the mouse. Leaving the keyboard gives your fingers a wonderful vacation. If you fall in the second camp, this post isn’t for you. But, if you want to be able to get from your query down to your results or explain plans without having to touch your mouse, this […]

Similar Posts by Subject Areas: , , , ,

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 […]

Similar Posts by Subject Areas: , , , ,

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 […]

Similar Posts by Subject Areas: , ,

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 […]

Similar Posts by Subject Areas: , , ,

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 […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , , ,