Shell script to perform appending of .sql files Post: 302823875

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Executing Multiple .SQL Files from Single Shell Script file

Hi, Please help me out. I have around 700 sql files to execute in a defined order, how can i do it from shell script

2. Shell Programming and Scripting

Help shell script to loop through files update ctl file to be sql loaded

I am currently trying to find a way to loop through files in a given directory and for each file modify a ctl file and sql load it. I have been using the sed command to change the infile, badfile parameters of the control file. I have not yet tried to sql load it. Requirement: files are ftp to...

3. Shell Programming and Scripting

shell script to run .sql files

hi Friends, Please help me in writing shell script to run list of sql files. database is Oracle 9i, unix os is solaris Requirement is 1. sql file must take two inputs a)feed id and b)business date 2.shell script must out put .xls or .csvfile as out put without trimming any column name and...

4. Shell Programming and Scripting

Appending columns of two files using shell script

Hi, I am using ksh, I want to read one csv file and append the columns of another file with new column. My input file: col1,col2 --------- siri,886 satya,890 priya,850 Another file with the below date:(test.csv) col3 ----- 321 333 442

5. Shell Programming and Scripting

shell script to take input from a text file and perform check on each servers and copy files

HI all, I want to script where all the server names will be in a text file like server1 server2 server3 . and the script should take servernames from a text file and perform copy of files if the files are not present on those servers.after which it should take next servername till the end of...

6. UNIX for Dummies Questions & Answers

How to perform string replace in shell script?

I have value like ABCDEF,BBCCDD in a shell variable, now i would like to have ABQWEF,BBQWDD in the same shell variable. How can i replace the char at position 3&4 with QW in shell script?

7. Shell Programming and Scripting

How to perform floating division in shell script?

I want to perform the below division operation in shell script and round the value. val1=6000 val2=5000 res=val1/val2 ----> 1.2---> Round to 2 Please help.

8. Shell Programming and Scripting

Oop to copy and rename files through SQL Statement in shell Script

#!/bin/sh sqlplus -s "/ as sysdba" << EOF SET HEADING OFF SET FEEDBACK OFF Select pt.user_concurrent_program_name , OUTFILE_NAME FROm apps.fnd_concurrent_programs_tl pt, apps.fnd_concurrent_requests f where pt.concurrent_program_id = f.concurrent_program_id and pt.application_id =...

9. Shell Programming and Scripting

Shell script appending output of sql query

I am writing the following script to create the file v_out.txt. sqlplus -s /nolog << EOF CONNECT scott/tiger@orcl; whenever sqlerror exit sql.sqlcode; set newpage 0; SET PAGESIZE 0; SET ECHO OFF; SET FEEDBACK OFF; SET HEADING OFF; SET VERIFY OFF; SET LINESIZE 100; set tab off; set...

10. Shell Programming and Scripting

How to execute 10 sql files from a folder through sqlplus in shell script?

I am new to shell scripting and i want to know how to execute the *.sql files from a folder through sqlplus in shell script and files should be execute in sequentially one by one while execution if any ORA error it has to exit from sqlplus session 1) scripts from external folder 2) logs has...

LEARN ABOUT DEBIAN

math::symbolic::exportconstants

Math::Symbolic::ExportConstants(3pm)			User Contributed Perl Documentation		      Math::Symbolic::ExportConstants(3pm)

NAME

       Math::Symbolic::ExportConstants - Export constants used for Math::Symbolic

SYNOPSIS

	 use Math::Symbolic::ExportConstants qw/:all/;

DESCRIPTION

       This just exports a number of constants on demand.  Usually, you'd want to rather use Math::Symbolic instead.  Math::Symbolic allows you to
       optionally export the same constants as this module, but using the ':constants' tag instead of the ':all' tag that you'd have to use with
       this module.

       Please refer to the documentation of the Math::Symbolic module for a list of constants.

   EXPORT
       None by default. But since exporting symbols is the only functionality of this module, you'll want to export the :all group of constants.

AUTHOR

       Please send feedback, bug reports, and support requests to the Math::Symbolic support mailing list: math-symbolic-support at lists dot
       sourceforge dot net. Please consider letting us know how you use Math::Symbolic. Thank you.

       If you're interested in helping with the development or extending the module's functionality, please contact the developers' mailing list:
       math-symbolic-develop at lists dot sourceforge dot net.

       List of contributors:

	 Steffen Mueller, symbolic-module at steffen-mueller dot net
	 Stray Toaster, mwk at users dot sourceforge dot net
	 Oliver Ebenhoeh

SEE ALSO

       New versions of this module can be found on http://steffen-mueller.net or CPAN. The module development takes place on Sourceforge at
       http://sourceforge.net/projects/math-symbolic/

       Math::Symbolic

perl v5.10.1							    2011-01-01				      Math::Symbolic::ExportConstants(3pm)