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 […]
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. […]
‘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 […]
Oracle SQL Developer: The Definitive Guide to Completion Insight
Can SQL Developer help me finish my SQL or code? Probably. Here’s a quick showing of what it’s capable of. Need more help on the syntax? Click on the keyword in the last two examples, and you’ll be taken to Oracle DOCS syntax pages for that command. Not working? A few things to remember: mind […]
Oracle SQL Developer and the Oracle Database Schema Service
The Cloud! You may have heard a few things about Cloud services and Oracle over the past few years. What I’m going to talk about today is our Database Schema Service offering. It’s what it sounds like, pretty much. On a kick-butt Exadata box, you get your own schema in a database that we take […]
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 […]
Drawing Foreign Keys & Relationships in SQL Developer Data Modeler
It’s all in the wrist, literally. You need to know where to start and where to finish. And you need to click ‘just’ right. Watch the animation and see what I’m talking about. So a few KEY things Start with the ‘parent’ Click on the table and ‘let go’ Now go and click on your […]
Exporting a PL/SQL Package Just the Way Monty Likes in SQL Developer
Got a quick question from my favorite President today. So basically, Monty was asking how to get a PL/SQL Package Spec & Body to: a single file with a SET DEFINE OFF with the schema prefix in the CREATE or REPLACE Now, there’s more than one way to get one or more objects in the […]
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 […]
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 […]
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 […]
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 […]
SDSQL: Installing and Connecting with our new Command Line Interface to Oracle Database
Instead of talking about or teasing some of the cool new features of SDSQL… Wait, what is SDSQL? …I thought I would start with the basics. Like: How to install it (on Windows) How to connect to Oracle Database If you want to see about the ‘cool new features’, then please go read up at […]
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 […]
SQL Developer 4.1: Multi-Cursor Editing
‘Make the editor work like Sublime Text or Crimson!’ So goes the several dozen requests I get each year. Well, in version 4.1, we’ve got something I think you’ll like. It’s a bit different than column text edit modes – but it allows for the same idea, and it’s even more powerful…I think. You can […]
Twitter
RSS
GooglePlus
Facebook