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 things that I see people doing ‘the hard way.’ After just a few minutes or reading (ha ha, more like…
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…
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. Things like comments primary keys indexes stats So SQLcl has two new commands for you. INFORMATION (INFO) Like I said,…
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…
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 care of for you. The data dictionary has been modified to make any cross-schema contamination impossible. So you just see…
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…
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 database out to a file. For just PL/SQL stuff, you have this on a right-click: Now, you can use the…
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…
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 average. Great Lakes Blackout Stout People have been going crazy for their Christmas Ale, but I think this is better.…
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 we’re now seeing the SQL ‘behind the SQL’ – an MTV spinoff I pitched that that never really took off.…
