Tag Archives: Oracle

Oracle SQL Developer

 

If you use Oracle for your projects, you are probably using your custom made interface for database connectivity, SQL*PLUS (integrated in the Oracle package) or some external 3rd party tool.

My choice on DB access when Oracle is the choice is Oracle SQL Developer.

Some features of this tool (from Oracle website):

1. Create Connections
2. Browse Objects
3. Create Objects
4. Modify Objects
5. Query and Update Data
6. Export Data and DDL and Import Data
7. Schema Copy and Compare
8. Process Commands
9. Edit PL/SQL
10. Run and Debug PL/SQL
11. Run and Create Reports
12. PL/SQL Unit Testing
13. Data Modeler Viewer
14. Migrate from Third Party Databases
15. Version Files
16. Review the Robust IDE

One of my favourite functions is trigger on sequence creation. When we need auto increment facility for a table, we usually pass through the following steps:

  1. Write the table code
  2. Write the sequence code
  3. Write the trigger code, connecting sequence to a 'before insert' action on a table.

Using Oracle SQL Developer, we could do:

Create a table with few clicks (defining the appropriate fields)

Create a sequence with the parameters in predefined form from the tool.

Then right-click on the table and create a Trigger -> PK from sequence which would create a trigger, catching a sequence and auto-incrementing an ID key of our own choice.

Great job that decreases the code writing when not necessary.

del.icio.us Digg DZone Facebook Google Google Reader Magnolia reddit SlashDot Technorati ReadMe.ru Dobavi.com Dao.bg Lubimi.com Ping.bg Pipe.bg Svejo.net Web-bg.com

Database training in Switzerland

 

Last week I gave a database training in Switzerland. We had a look into relational databases, normalization theory, some good principles on database modelling, SQL language.

As of the used tools, we had an overview of Oracle 11g free database server, as well as Oracle SQL Developer tool to access the database systems. The E/R diagram toolkit we used to train on was TOAD data modeller. The previous versions of the tool were freeware, but the last implementations available are only evaluation for 2 weeks. You could try to find an old version that does the general work - database drawing, generation of SQL (as well as simple reverse engineering), creation of relations - identifying and non-identifying, as for one-to-one, one-to-many and many-to-many relationships.

In my training here I also extend the presentations with PL/SQL tips and tricks, Object relational mapping with Hibernate and JPA and few practical projects in classes.

del.icio.us Digg DZone Facebook Google Google Reader Magnolia reddit SlashDot Technorati ReadMe.ru Dobavi.com Dao.bg Lubimi.com Ping.bg Pipe.bg Svejo.net Web-bg.com