Looking at endless spreadsheets or grids of data can make one’s brain a bit fuzzy. SQL Developer makes it easy to spot the bad data you’re looking for. Hit Ctrl+F in a grid. Type your search term. If you’re going to be looking for this data going forward, check the ‘Persist Highlight’ box. So for example, if I’m getting ready to demo some Tips & Tricks and I want to call out the very nice…
Updated 17 April, 2020: This feature now supports AutoReplace Oracle Docs just underwent a facelift, and I was testing to make sure that the code insight feature in SQL Developer was still able to pick out our code samples. Good news, it still works! But, I was getting distracted by a bit of code that LOOKED like it was DOCS related, yet wasn’t… So if it’s not coming from the docs, where is it coming…
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…