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 a tweet/blog post from Oracle ACED Scott Spendolini of Oracle APEX fame… Screaming at Each Other http://t.co/Dqsw4xwYmR #orclapex— Scott Spendolini…
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 format? Now that we have our own SQL*Plus command line interface (AKA SQLcl), the commands that are available there are…
This is a similar version of the content I presented to some internal folks here at Oracle last week. I thought you might enjoy it as well. I’ve ‘optimized’ it for Slideshare – meaning that there are NO animated GIFs, which is sad, but it does read better this way. There’s a YouTube video inside that does have some live demo if you prefer to watch instead of read. Let us know if you have…
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 columns to a table and not breaking any SELECT * FROMs in your code. Of course, you don’t HAVE any…
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 foreign key constraints on VIEWS, but I digress. Skip to the end if you want to see how that works…
Can SQL Developer help me finish my SQL or code? Probably. Here’s a quick showing of what it’s capable of. Note: we enhanced this feature to be a lot more user friendly, so make sure you upgrade to the latest offering and you can do stuff like this. 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.…
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 watch the movie. In ten minutes I cover: what is this thing? what can it do that SQL*Plus can’t? some…
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 other table Confirm your properties and hit OK You now have your key! The column in the source object…
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 how you can just double-click on a word to find all of the occurrences? Yeah, that still works, and it’s…
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 our most valuable resources, a free VirtualBox image providing an Oracle 12.1.0.2 Multitenant Database – plus SQL Developer, Oracle…