Author’s note: in the current Developer Day image, port forwarding on 1521 is there out-of-the-box for easy connections to your Database. This isn’t a SQL Developer post per-se, however if you are using the Oracle Developer Day VirtualBox 12c image, you will find this useful. A few of you have noticed that it’s difficult to connect to your Oracle Database from your computer if it’s running on this image. One Twitter friend asked just yesterday……
SubViews are a sub-collection of model objects. They are very useful for breaking up very large designs into smaller, easier to digest pieces. If you need to brush up on the topic a bit, try these posts. I recently received a note from a user, we’ll call him ‘Galo’ – who was having problems figuring out how to add a table to an existing subview. It actually took me a few minutes to figure out.…
We actually have THREE patches for you: Oracle SQL Developer 4.0.1 Oracle SQL Developer Data Modeler Oracle REST Data Services, formerly Oracle APEX Listener, 2.0.6 Bug Fixes, Mostly SQL Developer had a few dozen or so bugs that have been addressed. A few major fixes of note include the new ASH/AWR stuff not working when connected to RAC instances, and the debugger being busted when trying to use watches. The Modeler had it’s fair share…
Starting the debugger CAN be as simple as hitting this button in Oracle SQL Developer: But But, you need to make sure of the following: You have compiled for debug You have the privs You have a breakpoint set OR you have set the debugger preferences to start with a ‘Step Over’ On Database 12c, you’ve done setup the network access control list That’s a lot of buts. Let’s plow through them! Wait, wait, wait.…
Update: we added the auto-replace option in a later version of SQL Developer, so if you don’t see it in your version, UPGRADE. I get this question every few months, and I got it again last week in Denver – How can we setup auto-replace in SQL Developer? If I accidentally type ‘form’ I want it to come out as ‘from’ for example. I’m not a huge fan of the IDE ‘automatically’ doing things with…
I’m writing this at my departure gate in Denver, waiting for my flight home from the Training Days ’14 event hosted by the Rocky Mountain Oracle Users Group (RMOUG.) The RMOUG conference is the unofficial kick-off for Oracle conferences for the new year, and it’s one of my favorites. I helped put together a panel discussion on professional development, and one of the topics that came up was the ability of employees getting the approval…
Updated February 2021: I’ve updated this post to reflect the newest edition of this VirtualBox Appliance. If you’re looking for an already configured Oracle Database 19c environment with a database already setup and all the software you need to learn database programming, design, and administration concepts, then look no further! No need to create anything, just download, import, and run a fully functional Oracle Database, complete with sample data and hands on labs. This…
Going through our enhancement requests in The Exchange this week, I was struck by how many folks were asking for features that are already there. There were at least three requests for being able to define how the Indexes are handled for table columns defined as Primary Keys or Unique. Here’s an example that summarizes the general issue: There is currently no way to specify storage options for unique constraints in a table. Since it…
On Tuesday, February 4, 2014 – 9am to 1pm PT / 12pm to 4pm ET / 3pm to 7pm BRT, we will be holding a Virtual Developer Day conference. From the comfort of your Internet connection, you can pick from four different content tracks: Big Data for Developers Big Data for DBAs Oracle 12c for the Developer Oracle 12c for the DBA The Oracle Technology Network (OTN) has assembled an agenda of live, moderated sessions…
Wait, I thought SQL Developer was for developers? Yes, but it also provides a ton of features and value for the DBA. So if you’re already in SQL Developer to browse a table or run a query, you can fire up the DBA features under the View menu (and maybe save yourself an alt-tab to your browser and OEM.) We had a nice live webcast today with the good folks at ODUTG on this subject.…