
Tag archives for Oracle
Hello,
In this post, I would like to keep in my "knowledge base" 2 examples of scripts : SHELLSCRIPT + SQL and SQL + BATCH.
Example 1 : SHELLSCRIPT + SQL : Export data to CSV file
Creation of a SHELLSCRIPT script ex1_launcher_script.sh which is the launcher of a SQL script ex1_processing_script.sql. This SH script takes 2 parameters: the output CSV file ...more»
Hi,
PL/SQL Developer is an Integrated Development Environment that is specifically targeted at the development of stored program units for Oracle Databases. However, it is also possible to access to Sybase databases.
Below, the main Features of SQL Developer:
Database connections
– OS authentication, Proxy, LDAP
– Force thick driver usage
– Group connections in folders
Navigator support for
– Queues, Queue tables
– Browse and load Java
– Generating ...more»
Hello,
In this first post on 'database entity', I would write some words concerning the call and use of the database views in java code. In this post, I will not present the details of view's creation in database, for this point, see the official documentation of your database, for Oracle 10g CREATE VIEW: http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_8004.htm.
The main advantages of view are:
Hide certain ...more»
