ThatJeffSmith

If You Oracle Then You Should Twitter Too

Kellyn PotVin-Gorman and I have delivered a social media talk at the RMOUG Training Days Conference two years running now. We have fun doing the presentation, because we have fun being active on social media. We want you to not miss out on what we get out of it every day. This morning I saw […]

Similar Posts by Subject Areas: ,

A Quick 4.1 Trick: SET SQLFORMAT

One of your favorite SQL Developer ‘tricks’ is the ability to pre-format query output. So instead of getting standard output back, maybe you want query results to come back as CSV. But using that requires you to add code to your existing SQLs. Maybe instead it would be cool to set the overall script output […]

Similar Posts by Subject Areas: , , ,

Stop Doing That! – In Oracle SQL Developer

One of the coolest bits of The Matrix, was the ability for the main characters to ‘download’ new skills or objects into their virtual reality. Like Neo could learn Kung-Fu with a simple button click. Today, I want all of you to take the (Oracle) Red Pill, and download your SQLDev knowledge pack. These are […]

Similar Posts by Subject Areas: , ,

Are Invisible Columns Really Invisible?

Today’s question: How are invisible columns treated with DESC, INFO and the GUI equivalent? Super quick, an INVISIBLE column is one that the user doesn’t see. They won’t be able to access it unless they know about it. Security by obscurity? No. Tom Kyte shows a few examples of the features usefulness, especially when adding […]

Similar Posts by Subject Areas: , , , , , ,

SQLcl Commands: Info & Info+ – The New DESC?

We put out a HUGE update for our new SQL*Plus-style command line interface for Oracle Database. Forget how to install it, or how to connect: see the movie! Things that people really like to do in SQL Developer is pull up the object browsers to quickly see the things that a simple DESC doesn’t show. […]

Similar Posts by Subject Areas: , , ,

‘Modeling’ View Dependencies in SQL Developer Data Modeler

Today’s question: Please let me know how can I represent relation between view and base table in ER diagram created using sql datamodeler version4. So I know what the person is getting at here. They want to see the dependencies. Generally speaking, there are no actual relations between views and tables. Exception: you CAN define […]

Similar Posts by Subject Areas: , , , , ,

Oracle SQL Developer Meets SQL*Plus?

If you weren’t paying attention over the Christmas/Winter break, it’s very possible that you haven’t heard about our new project. You can find it on the SQL Developer version 4.1 Early Adopter download page.. If you’re not into reading so much, we have 7 or 8 blogs on the subject out there, you can just […]

Similar Posts by Subject Areas: , , , ,

SQL Developer 4.1: Search & Replace Enhancements

In the procedure editor, the editor that’s invoked when working with PL/SQL objects, you will notice a slightly new user interface when invoking a search or a replace. Let’s cover search first. Already searched for something, and want to do it again? Check out the history. Start searching, immediately highlight all of the ‘hits.’ Remember […]

Similar Posts by Subject Areas: , , , , ,

Your Favorite Posts from 2014

We’ve had another great year. Multiple product updates, 127 posts, and LOTS of questions asked and answered. Since it’s that time of year, here’s your, ‘lazy writer, popular posts’ update Based on overall site traffic in 2014, your favorite posts from this year are: 10. Introducing the Oracle Database 12c VirtualBox OTN Image One of […]

Similar Posts by Subject Areas: ,

Top Beers of 2014

There are a lot of ‘Top Beers’ lists out there, but none of them are written by me. Here are the beers that I discovered, Columbus-style, and loved in 2014. Data via Untappd. In no particular order… Stone’s Coffee Milk Stout I rated this beer higher than the avg Untappd user, but I’m smarter than […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: