Oracle SQL Developer

-
I needed to access some data on our corporate Oracle database server. Unfortunately, no information was given to me other that the PHP connection string. I had not idea about the table or view names either, so I tried to use a database management tool but lacking any previous knowledge about Oracle databases I look for what I've used in the past. I was quite happy with EMS Postgresql Manager and I learned they do have a simlilar product for Oracle databases, but after installing it I learned I needed to install SQL*Net software which I did not know where to get from.

However, a quick Google search lead me to another gem from Oracle: SQL developer and the word free captured my attention inmediately. It turns out it is a nice Java program that is available for a variety of platforms. I'm currently using it on Windows and Linux successfully (please note JDK >=1.5 is required).

Using this program I was able to learn about the tables on the server but not before I was able to discover the SID value which was not given to me but apparently necessary to connect to the server.

Sqldeveloper works nicely and it has many useful features (provided you are familiar with SQL language). For some weird reason it did not print on Ubuntu Linux, not even to a file. It has many useful export filters (i.e. XML, HTML, CSV, TEXT ...) and you can beat the price. The only drawback is that you need to register first, but it is a quick one.

Definitely worth a try if you are into Oracle databases. Just do not be confused, this is not MS Access, you have no macro capability nor forms or reports features (well ... actually it does but I still need to learn about that). But you can always use your Oracle database from MS Access by installing the ODBC driver on your Windows machine.

Comments

Post a Comment

Popular posts from this blog

VFD control with Arduino using RS485 link

-
Image
Variable Frequency Drives ( VFD ) allow the control of spindles so speed can accurately be controlled and a detailed acceleration profile for the spindle and reverse rotation can all be handled. In essence a VFD is an three phase inverter for three-phase AC motor. I am using a popular (I mean cheap) Chinese VFD and though the reference manual is not great, I could see there is a built-in RS-485 port. I usually control the start, stop and speed selection using the keyboard on the unit but I thought it will be more useful if I could control everything from the same Arduino is doing our CNC table control. Some cheap RS-485 off eBay and some lines of code later, I can start, stop and change the speed from an Arduino. What a cool thing to have! Some configuration of your VFD are needed before you can use it like that.  You need to set PD163=1 (I am using address 1 in the code). PD=164=1 (for setting serial to 9600bps) and PD165=0 (for using ASCII and 8N1 character format)
Read more

How to get sinusoidal s-curve for a stepper motor

-
Image
After some experimentation, and delving a bit into the math of motion, I realized there can be a significant difference on the motion of a machine by just making small changes. A common and popular approach to smooth one axis of motion is to use a trapezoidal speed pattern, where acceleration and deceleration are uniformly accelerated movements (aka constant acceleration motion) separated by a portion happening at cruising speed. The problem comes with the fact that, while that approach is simple to understand and to code, it does contain sudden changes in the acceleration, that show as spikes on the acceleration derivative, called jerk. These sudden changes in the acceleration translate into undesired vibration in our machines. Most of that can be eliminated by selecting a motion pattern that does not contain sudden changes of acceleration. If we chose a mathematical function for our speed whose second derivative is continuous, then we reduce system vibration quite a lot. One ma
Read more

Stepper motor step signal timing calculation

-
Image
While we use stepper motors in many devices, the timing of the step signals is not always well understood. Most of us can see how a fixed speed is a bad idea unless the speed of motion is really slow, but it is fixed speed what is really to generate with simple code. You just can use the Arduino Blink example to send a fixed frequency of pulses to a stepper motor driver. If too slow, just reduce the delay value. But for most real-life applications variable speed controls will perform better. These systems will speed up the motor to a given maximum speed and it will slow it down to stop at the desired step count. But understanding the math behind this process is sometimes not obvious. Let us start with the simple case of the so-called trapezoidal speed motion profile. Here motion takes place in three phases: acceleration, constant speed (cruising) and deceleration. But the point is how can our code create such a behavior. Stepper motor drivers usually accept two signals to control
Read more