Oracle ACE Director, BI/data/all things cool and extraordinaire, Stewart Bryson had a bit of a complaint about our favorite tool today. He wants Explain Plans in SQL Developer to show the same notes you can see in SQL*Plus… @thatjeffsmith See… no execution… and the notes. With one little statement. pic.twitter.com/w3GYkIPaDY— Stewart Bryson (@stewartbryson) November 4, 2014 So how do you see the Explain Plan notes in SQL Developer? The database writes that plan meta data…
For this year’s Open World, SQL Developer got lots and lots of love from the conference organizers and keynote speakers. I think SQL Devleoper was mentioned, demoed, or both in at least 3 of the executive keynotes. We had many successful, and FULL, hands on labs – led by the lovely Ashley Chen. And our SQL Developer talks were in the top 10 most popular in the Database/Tools tracks. Some Steven Feuerstein guy beat me…
I don’t think the word synonym is especially hard to spell, I just think it’s hard for my fingers to type it correctly. I’ve incorrectly typed it often enough that muscle memory is working against me. I run into a lot of developers that never learned to type, which sounds weird to me – like a plumber who doesn’t like wrenches…but anyways, if you need a bit of help, Oracle SQL Developer feels your pain.…
I’ve shown how to drag and drop database tables from Oracle SQL Developer into a design. But I’ve never done a start-to-finish, blow-by-blow post on how to import your existing database objects into a data model with SQL Developer. So let’s do that now. Warning: Lots of pictures coming up. Want to import from SQL Server (or DB2) instead? Check out this great post from Oracle ACE Director @kentgraziano on how to get SQL Server…
So you have decided to give Oracle SQL Developer a try. You’ve been working with Oracle for 15+ years, and you’re a bit set in your ways. But not THAT set in your ways. Want some advice for getting started in SQL Developer? Here goes… Go cold turkey. Put down your other tool(s). Pick up SQL Developer. Use just SQL Developer for a few weeks. When you get lost, or don’t know where to click…
Yesterday was regular expression day. I got asked by three different people about regex search options in SQL Developer. One of those wanted to know how to use them in the Data Modeler. Scenario: Find all columns which have precision of 9 or less I know, silly scenario. But I’m not that great with regular expressions, and I needed an easy one to play with. So this expression [0-9] will match any text that looks…
The ubiquitous HR.EMPLOYEES table – how many different ways can we look at this data? How much money people make, by department? By reading the column comments, we know that HR.EMPLOYEES.SALARY is “Monthly salary of the employee. Must be greater than zero (enforced by constraint emp_salary_min)” So let’s chart that. This charts the data we get back from 11012234216780285b3e8e6_000000 We want our reports, charts, and pictures to tell a story. Maybe this data would make…
For the month of September 2014, I published a SQL Developer tip each day. September has 30 days, so that equated to 30 posts. Now normally, I post anywhere from 1-3 posts a week. Going from that to 7 days a week meant a few things: posts were going to be shorter – especially on the weekends there was going to be some retreaded content – but I did try to give everything a fresh…
You have a query. You run a query. Now how can I take that data and make it available in a web browser or application? Export as HTML You can of course export your resultset as HTML using the Grid, right mouse, Export, to HTML. This will give you something like this… Don’t forget the hint! Remember, lazy-dev method: 11012234216780285b3e8e6_000001 And execute as script (F5) gives me this: 11012234216780285b3e8e6_000002 But the Internet wants more pictures!…
Updated Wednesday, July 6, 2016 Setting up a new install of SQL Developer this morning – exciting stuff as we’ll be teasing some v4.1 features at Open World this week – I found myself immediately tweaking the following preferences. Font – we’ve talked about this a few times, but I make it bigger to make it easier to see in presentation mode I also change the font itself, Dialog is horrible Open Object on Single…