how to use sqlplus command inside for loop Post: 302560173

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

read command (input) inside the while loop

Hi, 'read' command is not working inside the while loop, How can I solve this? Rgds, Sharif.

2. Shell Programming and Scripting

C Shell - Command Inside a Loop

I have a command nested in some while loops to parse some data that looks something like this. while ($condition) while ($condition) ... gzcat /dir/$fileName.gz | grep $searchString > out_file end end On the first loop, the command is executed properly (and takes maybe 10...

3. Shell Programming and Scripting

loop to replace txt and add command inside of colon (:)

in one of my script..I have some thing like john:christina : one:: and i want to make it like john:chritina:two:(date command):jackey: basically change 'one' to 'two' and run date :command and add other name:

4. Shell Programming and Scripting

Error while using sqlplus command inside 'if' condition in an unix shell script

Hi all, I am using the below given sqlplus command in my unix script to invoke a stored procedure which returns a value .It works fine. RET_CODE=$(/opt/oracle/product/10.2.0.4.CL/bin/sqlplus -S $USER/$PASSWD@$DB_NAME <<EOF EXEC MY_PKG.MY_SP (:COUNT); PRINT COUNT; commit; ...

5. Shell Programming and Scripting

Use sqlplus statement inside case sentence

Hello, I have a problem. I want to launch a different sql queries for different shell parameter values, something like this. #/bin/bash case $1 in "A") sqlplus -s user/pass << SQL query A; SQL "B") sqlplus -s user/pass << SQL2 ...

6. Shell Programming and Scripting

If else condition inside for loop of awk command in UNIX shell scripting

Hi , Please excuse me for opening a new thread i am unable to find out the syntax error in my if else condition inside for loop in awk command , my actual aim is to print formatted html td tag when if condition (True) having string as "failed", could anyone please advise what is the right...

7. Shell Programming and Scripting

Error with nested if within an sqlplus task inside

Hi ALL, I am receving a "strange" error using a nested if within an sql operation inside: ./dom.ksh: syntax error at line 80 : `then' unmatched This is all my script code: in bold the step receiving the error. Any help would really aprrecieted ......! **** I have tried all the...

8. Shell Programming and Scripting

[Solved] While loop error when add sqlplus command

Hi gurus, I hit a block when write the script. I need do while loop, in the loop I have code below. sqlplus -s abc/abc@abc <<EOF spool testwhile select * from dual; spool off exit; EOF when I run script with only this code, it works fine. if I add code as below: #!/bin/ksh ...

9. Shell Programming and Scripting

How to execute a command inside a while loop?

How do we execute a command inside a while loop?

10. Shell Programming and Scripting

CUT command not giving correct result inside loop

Hi, i have a source file and have 3 columns and separated by "|" .i want to split this 3 columns in different variable.When i am executing this values indivisually giving correct result but when the same execute inside a for loop,it's giving issues. Src file(jjj.txt) -------...

LEARN ABOUT OPENSOLARIS

purple-url-handler

purple-url-handler(1)						   User Commands					     purple-url-handler(1)

NAME

       purple-url-handler - Python script to handle URL with purple

SYNOPSIS

       purple-url-handler [-URL]

DESCRIPTION

       Python script to handle URL with purple.

OPTIONS

       Usage: purple-url-handler URL

       Example:

	 purple-url-handler "xmpp:romeo@montague.net?message"

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWgnome-im-client	   |
       +-----------------------------+-----------------------------+
       |Interface stability	     |Volatile			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       purple-remote(1), purple-send(1), purple-send-async(1), attributes(5)

       purple-url-handler Manual, http://pidgin.im/

NOTES

       Updated by Lei Ju, Sun Microsystems Inc., 2006, 2007.

SunOS 5.11							    02 Apr 2008 					     purple-url-handler(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

read command (input) inside the while loop

Discussion started by: sharif

2. Shell Programming and Scripting

C Shell - Command Inside a Loop

Discussion started by: hobbers

3. Shell Programming and Scripting

loop to replace txt and add command inside of colon (:)

Discussion started by: Learnerabc

4. Shell Programming and Scripting

Error while using sqlplus command inside 'if' condition in an unix shell script

Discussion started by: Shri123