Tag archives for SQL

Oracle, Unix, Windows : Examples of SQL, SH and BAT scripts
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 which is the launcher of a SQL script ex1_processing_script.sql. This SH script takes 2 parameters: the output CSV file ...more»
Java : Library : API : H2, the Java SQL database
Hi, Here a very useful library H2, the Java SQL database The main features of H2 are: Very fast, open source, JDBC API Embedded and server modes; in-memory databases Browser based Console application Small footprint: around 1.5 MB jar file size Features: Pure Java Memory Mode Encrypted Database ODBC Driver Fulltext Search Multi Version Concurrency Examples: Examples with the h2-1.4.192.jar and JDK 1.70_72 H2FileDatabaseExample H2MemoryDatabaseExample H2CsvMemoryDatabaseExample people.csv id,name,surname 1,Anju,Johnson 2,Sonia,Paulson 3,Asha,Huseyinson peopleWritten.csv "ID","NAME","SURNAME" "1","Anju","Johnson" "2","Sonia","Paulson" "3","Asha","Huseyinson" "12","Huseyin","OZVEREN" H2CsvMemoryNoDatabaseExample people3.csv "id","name","surname" "13","Huseyin13","OZVEREN13" "14","Huseyin14","OZVEREN14" That's all!!! Huseyin OZVEREN ...more»
Java / Security : Cross Site Scripting (XSS) and SQL injection
Hi, A simple post concerning the Cross Site Scripting (XSS) and SQL injection which are types of security vulnerability used in Web applications. In SQL-Injection the vulnerability is exploited by injecting SQL Queries as user inputs. In XSS, Javascript code is injected (basically client side scripting) to the remote server (persistente or non-persistent). For more information, Wikipedia is a good source ...more»
Tool/Oracle SqlDeveloper : Access to Sybase, SQL Server databases
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»
Copyright ® 2012 Huseyin Ozveren. No reproduction, even partial, can be used from this site and all its contents including text, documents, images, etc.. without the express permission of the author.