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 for...
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

Importing OpenSCAD designs into Onshape

-
Image
After using Onshape CAD software for a while I am really fond of it. So one natural thing to do, specially once they have released the Instructor's kit is to start using it in the classroom too. But one thing I was not so sure how to do was to use old designs I made using OpenSCAD. It does not mean I am completely quitting using OpenSCAD but suddenly I can see I can do assemblies in Onshape that will look quite nice for showing and documentation purposes if only I could easily import from OpenSCAD. I am glad to report that the route OpenSCAD --> FreeCAD --> Onshape worked brilliantly. Even more when a few tricks were applied. While some people suggest to import CSG files from OpenSCAD to FreeCAD, I have had more success by directly importing SCAD files into FreeCAD. One trick that worked well for me was to get rid of $fn references, so now circles become real circles (or cylinders) in FreeCAD. If a part keeps some $fn references then your cylinders or circles wi...
Read more