Tag archives for Oracle

Oracle, Unix, Windows : Examples of SQL, SH and BAT scripts

10
Feb

posted by Huseyin OZVEREN               filed under Database, DEVELOPMENT, Tools, Unix

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»

Tags: BAT, example, Oracle, scripts, SH, SQL, Unix, Windows

Comments (0)

Tool/Oracle SqlDeveloper : Access to Sybase, SQL Server databases

26
Jul

posted by Huseyin OZVEREN               filed under Database

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»

Tags: access, databases, Oracle, server, SQL, SqlDeveloper, Sybase, tool

Comments (0)

Java/Oracle: Call and use the database views

8
Aug

posted by Huseyin OZVEREN               filed under Database, DEVELOPMENT, Java

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»

Tags: call, database, java, Oracle, use, views

Comments (0)

• RSS Feeds

  • Post Entries Feeds
  • Post Comments Feeds

• Tags

  apache API application BlockingQueue client cloud Composer Configuration content Creation Crypto Cryptology database deployment DEVELOPMENT Documentum DQL ecm Encryption example Execution extjs File GAE generate generation gwt Hibernate java jaxp job library method Presentation Queue Security sencha server Service spring tomcat tool Validation web xml

•  Categories

   Categories Select Category Cloud  (1) Cryptology  (15) Database  (8) DEVELOPMENT  (177)    C#  (3)    Java  (118)    Libray  (11)    Tools  (32) Documentum  (60)    API DCTM  (12)    DFC DCTM  (13)    DQL DCTM  (16)    TOOLS DCTM  (18) ECLISPE  (9) ECM  (18) GAE  (12) Google  (12) GWT  (13) Hibernate  (7) HTML5  (1) php  (1) Sencha  (14) Spring  (23) Unix  (5) WEB  (35)

•  Archives

   Archives Select Month October 2018  (1) July 2018  (2) June 2018  (3) April 2018  (1) March 2018  (1) February 2018  (1) December 2017  (2) November 2017  (6) October 2017  (1) August 2017  (4) May 2017  (1) April 2017  (2) March 2017  (13) February 2017  (22) January 2017  (14) December 2016  (5) November 2016  (7) October 2016  (4) September 2016  (4) August 2016  (1) October 2014  (1) July 2014  (1) May 2014  (2) April 2014  (2) March 2014  (1) February 2014  (5) December 2013  (1) September 2013  (1) August 2013  (2) July 2013  (2) March 2013  (1) February 2013  (2) January 2013  (2) December 2012  (3) November 2012  (3) October 2012  (3) September 2012  (8) August 2012  (11) July 2012  (12) June 2012  (22) May 2012  (17) April 2012  (16)

• Recent Posts

  • Documentum : Unexplained DM_API_E_EXIST Error, client_pcaching_change
  • Java : Web Service : Tracing XML requests/responses with JAX-WS
  • Documentum : Execution CMD/PowerShell Via Job/Method
  • SAMBA JCIFS : Open Source library for CIFS/SMB networking
  • Apache : Commons Configuration
  • Documentum : Audit trail entries dm_audittrail / SessionConfig / application_code
  • Documentum : Deleting of audit trail entries dm_audittrail
  • Documentum : Principal-Mode Authentication : Use of IDfPrincipalSupport
  • Java : Generation Of Proxies for CXF, AXIS web services via ANT Script (WSDLToJava)
  • Documentum : Relation MAIL With External Internal Attachments (dm_relation, content_attr_name, content_attr_value…)
  • Documentum : DataSource Configuration (DS)
  • CSharp/C# : Custom Logging Service With NLog

• JavaBlog.fr / Java.lu NewsLetter

  Email