ThatJeffSmith

Category: General

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

Similar Posts by Subject Areas:

SQL Developer and a 12c Magic Trick

When you start working with 12c, if you want to freak out (sorry, GRAB the attention of) your co-workers or folks attending your presentation, try this: Open a worksheet Write a simple query against a view, or a data dictionary view Mouse over the SELECT and wait… Should just take a second or so… So […]

Similar Posts by Subject Areas: , , ,

SQL Developer 4.1: Easier Excel Imports

The most read post on this site? ‘How to Import from Excel to Oracle with SQL Developer‘ – and it has been since I published it almost 3 years ago. People really like Excel. Or I should put it this way – Excel is the way information is shared in an organization. It makes no […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , , ,