Communitcating between UNIX and SQL Scripts

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

UNIX Solution - Calling SQL*Plus scripts

I have a requirement of bash shell script calling SQL*Plus script. Shell Script sqlplus <user>/<pwd> @sqlscript1 parameters sqlplus <user>/<pwd> @sqlscript2 parameters Now I need the values generated by sqlscript1 in sqlscript2. But it is more like a huge dataset in a table and not one...

2. Shell Programming and Scripting

Issue in SQL Loader scripts

3. UNIX for Advanced & Expert Users

Call parallel sql scripts from shell and return status when both sql are done

Hi Experts: I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing...

4. Shell Programming and Scripting

Execute multiple SQL scripts from single SQL Plus connection

Hi! I would like to do a single connection to sqlplus and execute some querys. Actually I do for every query one connection to database i.e echo 'select STATUS from v$instance; exit' > $SQL_FILE sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT echo 'select VERSION from v$instance;...

5. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Hi guys, I am new on here, I have a function in oracle that returns a specific value: create or replace PACKAGE BODY "CTC_ASDGET_SCHED" AS FUNCTION FN_ASDSCHEDULE_GET RETURN VARCHAR2 AS BEGIN DECLARE ASDSchedule varchar2(6); ASDComplete...

6. Shell Programming and Scripting

any possible solution on sql calling scripts

hi all, i have a function which will take i/p as a ddl sctipt as i/p and execute it, let function execute_sql { db_var="$1" v_cnt=`sqlplus -s XXXXX/XXXXX@aXXX << ENDSQL | sed -e "s/Connected\.//" -e "/^$/d" set pagesize 0 feedback off verify off heading off echo off serveroutput on size...

7. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Hi- I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment... I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert...

8. UNIX for Dummies Questions & Answers

SQL and shell scripts

Initial code is modified...Can u help me with the next post.....

9. Shell Programming and Scripting

Calling SQL scripts through Shell Script

Oracle and Scripting gurus, I need some help with this script... I am trying to add the query SELECT * FROM ALL_SYNONYMS WHERE SYNONYM_NAME = 'METADATA' in the current script.... Read the result set and look for the TABLE_NAME field. If the field is pointing to one table eg....

10. Shell Programming and Scripting

Help with GDL to SQL scripts

Hi to everyone, i want ask if someone knows about a script/program to convert the .gdl (Interbase) to .sql scripts. I wrote a little script to make it but it's very very simple, and the triggers and some code from .gdl are so difficult to me. If somebody could help me, I would very thankful. ...

LEARN ABOUT SUSE

sql::statement::term

SQL::Statement::Term(3) 				User Contributed Perl Documentation				   SQL::Statement::Term(3)

NAME

       SQL::Statement::Term - base class for all terms

SYNOPSIS

	 # create a term with an SQL::Statement object as owner
	 my $term = SQL::Statement::Term->new( $owner );
	 # access the value of that term
	 $term->value( $eval );

DESCRIPTION

       SQL::Statement::Term is an abstract base class providing the interface for all terms.

INHERITANCE

	 SQL::Statement::Term

METHODS

   new
       Instantiates new term and stores a weak reference to the owner.

   value
       Abstract method which will return the value of the term. Must be overridden by derived classes.

   DESTROY
       Destroys the term and undefines the weak reference to the owner.

NAME

       SQL::Statement::ConstantTerm - term for constant values

SYNOPSIS

	 # create a term with an SQL::Statement object as owner
	 my $term = SQL::Statement::ConstantTerm->new( $owner, 'foo' );
	 # access the value of that term - returns 'foo'
	 $term->value( $eval );

DESCRIPTION

       SQL::Statement::ConstantTerm implements a term which will always return the same constant value.

INHERITANCE

	 SQL::Statement::ConstantTerm
	 ISA SQL::Statement::Term

METHODS

   new
       Instantiates new term and stores the constant to deliver and a weak reference to the owner.

   value
       Returns the specified constant.

NAME

       SQL::Statement::ColumnValue - term for column values

SYNOPSIS

	 # create a term with an SQL::Statement object as owner
	 my $term = SQL::Statement::ColumnValue->new( $owner, 'id' );
	 # access the value of that term - returns the value of the column 'id'
	 # of the currently active row in $eval
	 $term->value( $eval );

DESCRIPTION

       SQL::Statement::ColumnValue implements a term which will return the specified column of the active row.

INHERITANCE

	 SQL::Statement::ColumnValue
	 ISA SQL::Statement::Term

METHODS

   new
       Instantiates new term and stores the column name to deliver and a weak reference to the owner.

   value
       Returns the specified column value.

AUTHOR AND COPYRIGHT

       Copyright (c) 2009,2010 by Jens Rehsack: rehsackATcpan.org

       All rights reserved.

       You may distribute this module under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl
       README file.

perl v5.12.1							    2010-05-06						   SQL::Statement::Term(3)

UNIX for Dummies Questions & Answers