Data Management

Learn Oracle - What is Oracle?

2 comments
palchin
palchin

can any one define oracle

kevaburg
kevaburg

Oracle is a fantastic database system that has been around for years. I can only speak for 10g onwards but in my opinion, the only thing that lets it down is the appalling "Enterprise Manager", a browser-based interface for administering the database itself and the features contained within it. RMAN, the tool for backing up and restoring data on the database, is extremely flexible and is relatively easy to learn on the command-line, the only way I ever use it. If you are thinking about using Oracle in a production environment, then consider using Navicat for Oracle or Toad for most operations although I have found the SQL Developer offered up by Oracle to be more than up to the job and relatively easy to use. Apart from the critism about Enterprise Manager, I would say that PL-SQL is a little too different from T-SQL (or others) to convert one database SQL to another very easily and certainly can't be done without massive testing before sending it out into the real world. Oracle is a massive subject and certainly can't be coverede in these few lines but if you take the time to learn it you won't be disappointed!