ThatJeffSmith

Tag: sqldev

Viewing BLOBs in SQL Developer as Text

I have talked about how to preview BLOBs (Binary Large Objects) as pictures… But someone on Stackoverflow asked how to read a BLOB value if it had text. So I spooled the content of my EMPLOYEES table to a txt file, as CSV, and then loaded that to a table as a BLOB. Then I […]

Similar Posts by Subject Areas: , , ,

2 Reports You Might Enjoy in Oracle SQL Developer

I keep telling people our reporting functionality is probably the most powerful AND overlooked feature in SQL Developer. Today I’m going to share 2 reports that I frequently forget about, that you may enjoy. Finding Unindexed Foreign Keys We all know this should not happen. We all know it eventually happens. Here’s a report to […]

Similar Posts by Subject Areas: , , , , ,

Case Closed: lower, InitCAP, UPPER, And Stuff

Best practice for code readability dictates that your keywords should always be in: insert your preferred style here __________. Here’s a Twitter poll I’m running if you want to personally weigh in: Do you agree? Best coding practices dictate uppercase identifiers? https://t.co/WhOZvL2Bmv — Jeff Smith ☜ (@thatjeffsmith) March 16, 2016 So even if we can’t […]

Similar Posts by Subject Areas: , , ,

SQLDev Trick: Alphabetized Column List in the Single Record Viewer

This trick’s title might actually be longer than the content – so guaranteed QUICK read! Question from a reader: is there a way to alphabetize the columns in the Single Record View? Quick Answer: No… Column order is usually something the application architect or data modeler deemed important, so we always show the column in […]

Similar Posts by Subject Areas: , , ,

Make SQL Developer Run Faster

Forgive the inelegant post title – but it gets to the point, and I reckon it might be closer to what folks will be Googling. I get questions from time to time around getting SQL Developer to load or respond quicker. Here’s the advice/tips I generally lead with: Look and Feel You can tell SQL […]

Similar Posts by Subject Areas: , ,

Advice on Finding Your Way Around a New Oracle Database

Received this query from a customer this morning… For your information, I’m average in SQL. What I would really like to know is if you can give me some tips regarding the use of Oracle SQL Developer in relation to a completely new database. So, are there functions/tools in Oracle SQL Developer which can help […]

Similar Posts by Subject Areas: , , , ,

Formatting Columns in SQL Developer a la SQL*Plus

Does SQL developer support, col command that is used to format query results in sqlplus. like – col id heading app_id format a10 My answer was: ‘Yes.’ But I figured I should put up or shut-up a little bit, so here goes. You can read more about column formatting in SQL*Plus here (Docs). I used […]

Similar Posts by Subject Areas: , ,

Getting Your Plans via SQL_ID

@thatjeffsmith hi Jeff, is it possible to see execution plan just by passing sql_id somehow,i dont think so as it just show running sql plan — Mayank (@mayankeurope) February 15, 2016 So of course you can just run a query in the worksheet to get this. But, you need to know a few things. So […]

Similar Posts by Subject Areas: , , , ,

What the SQL? (History)

Oracle SQL Developer has 2 client-side logging mechanisms for capturing SQL that is executed: SQL History Statements SQL History This is the SQL that you have executed in a SQL Worksheet. It’s also any scripts you have executed in a SQL Worksheet. Ran something the other day and forgot to save it to your script? […]

Similar Posts by Subject Areas: , , , ,

Oracle SQL Developer, In a Nutshell

Idiom:in a nutshell In a few words; concisely: Just give me the facts in a nutshell. Ok, so I used more than a few words, but if I told you that SQL Developer was a GUI version of SQL*Plus – I’d be leaving out a WHOLE LOT of important stuff. If that’s all you’re using […]

Similar Posts by Subject Areas: ,

Modeling Virtual Columns

Virtual columns made their debut in Oracle Database 11g. They are a value that’s not stored with the row, rather they are computed as queried. [DOCS] So I could have a column of type DATE. And I could have a virtual column of type VARCHAR2 that is computed by running a function against the previously […]

Similar Posts by Subject Areas: , , ,

SELECT SPLAT…To Just the Cols You Want

Question: I like SELECT *, but I don’t really want ALL the columns. Is there a better way? Side Note: People are giving me crap on the ‘SPLAT’ – it’s perfectly acceptable! To me at least… There’s a few better ways, and with an IDE like SQL Developer, you should expect lots of help in […]

Similar Posts by Subject Areas: ,

Your Favorite Posts from 2015

These were the stories published this year that enjoyed the most readers. Sadly, an article I wrote many years ago on how to import data from Excel to Oracle, remains the #1 post overall. Stupid Excel. 10. SQL Developer version 4.1 Feature Recap So we released version 4.1 of SQL Developer this past May. This […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , ,