Skip to main content

sqlplus used in perl

sqlplus is a command line tool used to work with an Oracle database.

#!/bin/perl
my $sqlString ='sqlplus -s user/pass@SID << END
set heading off
set echo off
set feedback off
set pagesize 0';

$sqlString = "$sqlString\nSELECT 'test' FROM dual;";

my $result; = `$sqlString`;

print $result;

usage: sqlplus [-s] user/pass@SID
-s parameter enables a silent mode. Only result of statement executions will be returned to a standard output (data like 'SQL>' prompt or a connection confirmation will be skipped)

To disable a default human-redable format of returned data the following parameters are set: heading, echo, feedback, pagesize.
Labels:

Comments

Post a Comment

Popular posts from this blog

Convert Source to String

import java.io.BufferedReader; import java.io.IOException; import java.io.Reader; import java.io.StringReader; import javax.xml.transform.Source; import javax.xml.transform.sax.SAXSource; import org.xml.sax.InputSource; public class DataSourceTest { public static void main(String[] args) throws IOException { // created Source InputSource inputSource = new InputSource(new StringReader( " \n \n \n ")); Source source = new SAXSource(inputSource); // read Source SAXSource saxSource = (SAXSource) source; InputSource inputSourceReader = saxSource.getInputSource(); Reader reader = inputSourceReader.getCharacterStream(); BufferedReader buffereRreader = new BufferedReader(reader); String read = null; while ((read = buffereRreader.readLine()) != null) { System.out.println(read); } } }
Post a Comment
Read more

scala Hello World

The code below prints Hello World! Hello.scala file (a name of file doesn't matter) object HelloWorld { def main(args: Array[String]) { println("Hello World!") } } Key word object is used to create a singleton object. To run this script use scala interpretor (check scala command line tools ).
Post a Comment
Read more

JAXB marshall and unmarshall

write xsd schema file(s) use xjc tool to compile xsd schema file(s) into java classes create a java object marshall the object into a file unmarshall the object from a file 1. drink.xsd schema file <xs:element name="drink"> <xs:complexType> <xs:sequence> <xs:element name="name" type="xs:string" /> <xs:element name="alcohol" type="AlcoholEnum" minOccurs="0" maxOccurs="10" /> <xs:element name="ice" type="xs:boolean" /> </xs:sequence> </xs:complexType> </xs:element> <xs:simpleType name="AlcoholEnum"> <xs:restriction base="xs:string"> <xs:enumeration value="vodka" /> <xs:enumeration value="rum" /> <xs:enumeration value="whiskey" /> <xs:enume
Post a Comment
Read more