ThatJeffSmith

Using Reports to Print CLOBs

A co-worker asked me for some advice on building a report to view some CLOBs. CLOBs are fun. They let you store an unlimited (basically) amount of text. They’re not as flexible as VARCHAR2s, but they do come in handy. Viewing them in a report can get interesting though. The question came down to seeing […]

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: , , ,

A Friend Could Use Your Help

My friend Chet is facing some pretty large bills. They go to pay for therapy for his special needs daughter, Kate. Chet is @oraclenerd. He’s done a lot to help the community, and to help community members in need. We’ve started a fund-raiser to help Chet make sure his kids get the care they need. […]

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: ,

Resolutions for 2016

Our Database Insider Newsletter folks asked me to share some resolutions I had for 2016. 2015 was a great year for me, personally and professionally. I’m also continuously reminded of the things I don’t do so well and need to get better at. So here goes… Find new ways to reach and help our users. […]

Similar Posts by Subject Areas: ,

More SET SQLFORMAT fun in SQLcl

DELIMITED text files are popular ways of passing data around. CSV anyone? The C stands for ‘Comma’ – regardless of what your smug European friends may have told you 😉 #TonguePlantedFIRMLYInCheek Anyways, in SQL Developer, when using the export dialog to get a DELIMITED export for your dataset, you can set the delimiter and the […]

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

Similar Posts by Subject Areas: , ,

Formatting Code in SQLcl

Ever get a SQL statement from someone desperate for help? There’s 2 things these people do that drive me nuts: they send a SCREENSHOT of their code they send the Query as a single line of text If I’m in the command line, it’s real easy to fix the 2nd problem. Just use the FORMAT […]

Similar Posts by Subject Areas: ,

SQLcl: Optimizing Your History Lists

Since SQLcl is a command line tool, it’s not super helpful to have a huge command history list. How do I mean? Well, in the SQL Developer GUI, we have a History panel. It allows for sorting, filtering, scrolling, etc. So you can go ‘crazy’ and set your History limit to 1000 if you want. […]

Similar Posts by Subject Areas: , ,

10 Years & Counting, Rock On

Doing the math, SQL Developer is officially 10 years old. Or should I say, 10 years young? I remember VERY clearly when this came out. It was seen as a very disruptive move by Oracle – a company for which I did not work at the time, so this is my personal recollection 🙂 It […]

Similar Posts by Subject Areas: ,

Your Definitive Guide to SQL History

I went to link to this post earlier today, and was shocked to discover I hadn’t actually written it yet. What’s the opposite of ‘bazinga!’ ? SQL Developer stores every query AND script you execute in a worksheet. A query being a single statement, and a script being one or more queries and/or anonymous blocks. […]

Similar Posts by Subject Areas: , , ,

5 SQLDev Features I’m Thankful For

I hope this post isn’t too cheesy. But it’s Turkey-week here in the USA, and the theme demands that homage be paid. So here are 5 features in Oracle SQL Developer that I use all the time, and am truly thankful for. They help me conserve energy, AND they make my job easier. I want […]

Similar Posts by Subject Areas: , ,

Making Your Own Custom Object Navigators

The Connection Tree and Schema Browser make pretty nifty object navigators. But maybe you want your own custom list of objects. Perhaps you’re working on a project and you only want to see objects that pertain to Project XYZ. And you’re able to ID these objects by a common column ID – or use your […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , ,