run sql query via perl script

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Run sql query in shell script and output data save as delimited text

I want to run sql query in shell script and output data save as delimited text (delimited text would be comma) Code: SPOOL_FILE=/pgedw/dan.txt SQL=/pgedw/dan.sql sqlplus -s username/password@myhost:port/servicename <<EOF set head on set COLSEP , set linesize 32767 SET TRIMSPOOL ON SET...

2. Shell Programming and Scripting

Run sql query after ssh in UNIX

I am running this test.ksh on server1. It successfully logins to server2 but runs the queries of query.sql on server1. query.sql is present in both server1 and server2 Can anybody please help. I need to run queries on server2 itself.:confused: Below is the test script...

3. UNIX for Dummies Questions & Answers

Script to run sql query.

Please read How To Ask Questions The Smart Way

4. Shell Programming and Scripting

Shell script to run sql query having a long listing of parameters

Hi, I have a query regarding execution of a sql query having long listing of parameters ..I need to execute this query inside a shell script. The scenario is like.... Suppose I have a file abc.txt that has the card numbers..it could be in thousands.. then I need to fire a query like ...

5. Shell Programming and Scripting

Run SQL thru shell script: how to get a new line when run sql query?

Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database. I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :( What should I do? I'm not sure that...

6. Shell Programming and Scripting

How to run a SQL select query in Oracle database through shell script?

I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this? Is there a way to have a persistent connection to oracle database...

7. Shell Programming and Scripting

perl- oracle sql query

Hi, I am new to perl.How to query oracle database with perl??? Thanks

8. Shell Programming and Scripting

Need help to run sql query from a script..which takes input from a file

I need to run sql script from shell script which takes the input from a file and contents of file will be like : 12345 34567 78657 and query will be like : select seq_nbr from bus_event where event_nbr='12345'; select seq_nbr from bus_event where event_nbr='34567'; select seq_nbr...

9. Shell Programming and Scripting

Need help in printing a sql query in perl

Hi All, I have the following sql query select abcd from udbadm.log where xyz='1'. I have 16k queries similar to this with different values for xyz. I want to print the values of 'abcd' for each row. I have the following perl code, but not sure how i can print that particular...

10. Shell Programming and Scripting

Incorrect SQL query in perl

I the the following perl script, however it does not return anything. Did i form my syantax wrongly? $sth=$dbh->prepare("select a.rowid,a.* from Table1 a where a.field1 = \'$Indicator1\' and a.schedule = \'$Indicator2\' and a.lastdate <= sysdate"); $sth->execute() ...

LEARN ABOUT DEBIAN

pperl

PPERL(1p)						User Contributed Perl Documentation						 PPERL(1p)

NAME

       PPerl - Make perl scripts persistent in memory

SYNOPSIS

	 $ pperl foo.pl

DESCRIPTION

       This program turns ordinary perl scripts into long running daemons, making subsequent executions extremely fast. It forks several processes
       for each script, allowing many processes to call the script at once.

       It works a lot like SpeedyCGI, but is written a little differently. I didn't use the SpeedyCGI codebase, because I couldn't get it to
       compile, and needed something ASAP.

       The easiest way to use this is to change your shebang line from:

	 #!/usr/bin/perl -w

       To use pperl instead:

	 #!/usr/bin/pperl -w

WARNINGS

       Like other persistent environments, this one has problems with things like BEGIN blocks, global variables, etc. So beware, and try checking
       the mod_perl guide at http://perl.apache.org/guide/ for lots of information that applies to many persistent perl environments.

Parameters
	 $ pperl <perl params> -- <pperl params> scriptname <script params>

       The perl params are sent to the perl binary the first time it is started up.  See perlrun for details.

       The pperl params control how pperl works. Try -h for an overview.

       The script params are passed to the script on every invocation. The script also gets any current environment variables, the current working
       directory, and everything on STDIN.

Killing
       In order to kill a currently running PPerl process, use:

	 pperl -- -k <scriptname>

       You need to make sure the path to the script is the same as when it was invoked.

       Alternatively look for a .pid file for the script in your tmp directory, and kill (with SIGINT) the process with that PID.

ENVIRONMENT

       pperl uses the PPERL_TMP_PATH environment variable to determine the directory where to store the files used for inter-process
       communication.  By default, the subdirectory .pperl of the user's home directory is used.

BUGS

       The process does not reload when the script or modules change.

       $^S is not represented identically with respect to perl, since your script will be run within an eval block

AUTHOR

       Matt Sergeant, matt@sergeant.org. Copyright 2001 MessageLabs Ltd.

SEE ALSO

       perl. perlrun.

perl v5.14.2							    2011-11-15								 PPERL(1p)

Shell Programming and Scripting