SQL Developer is a Java Swing desktop application – surprise! We support a native operating system ‘look and feel’ and also ship with an Oracle look and feel (LnF). The architecture of Swing is designed so that you may change the “look and feel” (L&F) of your application’s GUI (see A Swing Architecture Overview). “Look” refers to the appearance of GUI widgets (more formally, JComponents) and “feel” refers to the way the widgets behave. The…
It’s so much more fun to watch users demo and brag about your software than it is to get up and do it yourself. For one thing, it means a lot more coming from real people than it does coming from someone PAID to talk it up. Today, about 40 of us in Raleigh/Durham watched David Mann [Twitter] demonstrate lots of fancy SQL Developer reports at the East Coast Oracle Conference. Before he started, he…
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…
@thatjeffsmith Is there a way to define a function-based index in #SQLDevModeler?— Kent Graziano (@KentGraziano) October 29, 2014 Function based indexes [DOCS] have been part of Oracle Database since at least version 8. Instead of just indexing someone’s name, you could also index the values returned by a function call over that name. Example I just made up, and may not have anyting to do with the real world: Names are stored case sensitive, but…
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…
In SQL Developer if you use the Import Data feature from the main tree node, it will create a new table based on a delimited text or Excel file. We’ll look at the data and create some columns for you. In version 4.1, we’ll recognize numbers as numbers, dates as dates, and try to get a best guess for you in terms of the proper date formats, precision, etc. In all version of the tool,…
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…
While at Open World, I noticed Oracle ACE Director Heli’s desktop was setup very nicely for working with the Data Modeler. I asked if I could share it with you all, and she graciously agreed. So how do you get the panels to dock where you want them to in SQL Developer? By the way, we can thank the Netbeans team for giving us this cool desktop management tech. The trick is all in the…
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…
I had a pretty good week of presenting at Open World this week. 3 solo presentations, all well attended. But in one, I had a technical issue – that’s code for I was having problems because I was using the wrong database connection – when trying to show off the Real Time SQL Monitoring support feature in Oracle SQL Developer. So in case you were there, and left a bit disappointed, I cut this quick…