How to include SQL within a script Post: 302448802

10 More Discussions You Might Find Interesting

1. Programming

How to include shell script in C program

hi I want to call a shell script in C program the script is : ssh -t user@remote sh /<remote>home/user/<file_name>.sh and other several commands C program : Call this script and the retrive the task that is been done in <file_name>.sh file can any one tell me how...

2. Shell Programming and Scripting

Include lines within a script

I want to add lines in my script dynamically. My script: ... echo addscript end addscript ... Lines to add: (can be put in a file and can be added) cp /opt/script1.sh opt/script1_org.sh sed 's/testusr/'${FUNCTID}'/g' /opt/script1.sh > ./tmpfile mv ./tmpfile /opt/script1.sh...

3. 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...

4. UNIX for Dummies Questions & Answers

Include PERL script with in the unix shell script

Hi Gurus, Is it possible to include perl script with in the unix shell script? What would be the general syntax? In the above case, is it required to write the below first two lines of codes? #!usr/bin/sh -x #!usr/bin/perl -w Thanks in advance / Mysore Ganapati.

5. Shell Programming and Scripting

include in script

Hello, I have a script and a second file that contains all parameters needed for the script. How can I include this file in the script ? I tried source but I have a "no such file or directory" error. :)

6. UNIX for Dummies Questions & Answers

script/program in vi include $? or...

Hi. When you write a script/program in vi Do you include the $ Eg. #!/bin/bash $ echo "Today's date is `date`" or echo "Today's date is `date`" Make your script executable. $chmod +x script I included that. I keep getting a permission denied... why? Thanks!

7. 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...

8. UNIX for Dummies Questions & Answers

Option in sql script to include column headers when spooling file to .csv format

Can anyone help me how to include COLUMN HEADER when spooling file to .CSV format through SQL statement. Thanks, Akbar

9. Shell Programming and Scripting

How to include a command in shell script?

# dbc "delete from alert;" DELETE 10 # However, the script created below generates an error that command does not exits. Can any one please exist. script.sh: #!/bin/sh dbc "delete from alert;" >>$TASKLOGFILE ./script.sh: line 38: dbc: command not found can any one please...

10. UNIX for Dummies Questions & Answers

[solved] Script creation (how to include options in the script)

Hi guys i have written a script which takes the options given to him and execute itself accordingly. for example if a script name is doctortux then executing doctortux without option should made doctortux to be executed in automatic mode i.e. doctortux -a or if a doctortux is needed to run in...

LEARN ABOUT DEBIAN

yaz-url

YAZ-URL(1)							     Commands								YAZ-URL(1)

NAME

       yaz-url - YAZ URL fetch utility

SYNOPSIS

       yaz-url [-H name:value] [-m method] [-O fname] [-p fname] [-u user/password] [-x proxy] [url...]

DESCRIPTION

       yaz-url is utility to get web content. It is very limited in functionality compared to programs such as curl, wget.

       The options must be precede the URL given on the command line to take effect.

       Fetched HTTP content is written to stdout, unless option -O is given.

OPTIONS

       -H name:value
	   Specifies HTTP header content with name and value. This option can be given multiple times (for different names, of course).

       -m method
	   Specifies the HTTP method to be used for the next URL. Default is method "GET". However, option -p sets it to "POST".

       -O fname
	   Sets output filename for HTTP content.

       -p fname
	   Sets a file to be POSTed in the folloing URL.

       -u user/password
	   Specifies a user and a password to be uesd in HTTP basic authentication in the following URL fetch. The user and password must be
	   separated by a slash (this it is not possible to specify a user with a slash in it).

       -x proxy
	   Specifies a proxy to be used for URL fetch.

SEE ALSO

       yaz(7)

YAZ 4.2.30							    04/16/2012								YAZ-URL(1)

10 More Discussions You Might Find Interesting

1. Programming

How to include shell script in C program

Discussion started by: mridula

2. Shell Programming and Scripting

Include lines within a script

Discussion started by: chiru_h

3. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Discussion started by: rajagavini

4. UNIX for Dummies Questions & Answers

Include PERL script with in the unix shell script

Discussion started by: ganapati