I recently got this request for help via a YouTube video comment. I’m sharing it here, because I see this type of question A LOT. And it scares me. “When I run this script it reads = Error starting at line : 1 in command – What am I doing wrong? Before I show the [...]
Connecting to Oracle from Your Host to a VirtualBox OEL Guest
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… Need [...]
Adding and Removing Objects from a SQL Developer Data Modeler SubView
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 [...]
How To Version Control Your SQL Developer Data Modeler Designs
Today I want to talk about how to version control your Data Modeler designs with Subversion. Oracle SQL Developer Data Modeler is free. Subversion is free. So for no money, you can design your database objects, and version control them for one or more people. I’ve put together some slides for your enjoyment: Oracle SQL [...]
SQL Developer 4.0 Patch Release Now Available
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 [...]
How to Start the PL/SQL Debugger
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, [...]
How I Setup SQL Developer to Look and Run
I do a lot of live presentations and demonstrations. I’m frequently asked, ‘why does your SQL Developer look that way?’ or ‘How can I make SQL Developer work that way?’ It’s all about the preferences (or options.) So here’s what you can do if you want to be like me. By the way, I can’t [...]
Auto-Replace in Oracle SQL Developer?
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 my editor text. [...]
On Conferences and User Groups…on a Saturday?
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 [...]
Oracle SQL Developer 101: PLSQL Compiler Warnings, Errors and the Right Gutter
Ever wonder what all the red, yellow, and purple marks in your procedure editor are supposed to tell you in the Oracle SQL Developer Procedure Editor? No idea what I’m talking about? This: This is the editor trying to help direct you to where you might have problems, instead of you having to to scroll [...]
Introducing the OTN Developer Day Database 12c VirtualBox Image
If you’re looking for an already configured Oracle Database 12c environment with a database already setup and all the software you need to learn database programming, design, and administration concepts, then look no further: This Stuff is all FREE The virtualization software is VirtualBox – that’s free. And it runs on any OS, including Windows, [...]
Defining Storage Properties for Primary and Unique Columns in SQL Developer Data Modeler
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 [...]
How to Open the Data Modeler in Oracle SQL Developer
You are using Oracle SQL Developer, and you want to create or open a design in the Data Modeler. How do you GET to the Modeler? Oracle SQL Developer Data Modeler is a standalone solution that is also shipped in SQL Developer as an extension. The user interface of the Modeler is folded into SQL [...]
Join Us for Our Upcoming Virtual Developer Day
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 [...]
Oracle SQL Developer for the DBA
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 [...]
Twitter
RSS
GooglePlus
Facebook