Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Multiple Query Results to Variables
Top Forums Shell Programming and Scripting Multiple Query Results to Variables Post 302733407 by Yoda on Tuesday 20th of November 2012 11:39:54 AM
Old 11-20-2012
You can spool the field values (comma separated) to a file and read it one by one to perform an action:-
Code:
sqlplus -s $user@$pass@inst << EOF
set echo off head off feed off pagesize 0 trimspool on linesize 1000 num 15 colsep ,
spool data.csv
select Field_1, Field_2 from table_1;
spool off;
exit;
EOF

while IFS=, read val_1 val_2
do
        sqlplus -s $user@$pass@inst << EOF
        delete from table_2 where Field_1='$val_1' and Field_2='$val_2';
        commit;
        exit;
        EOF
done < data.csv

 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Set shell variables from SQLPLUS query results

Hi All, I needed to get the result of two sqlplus queris into shell variables. After days of looking for the ultimate solution to this problem.. i found this... sqlplus -s USER/PASS@DB <<EOF | awk '{if(NR==1) printf("%s ", $1); if(NR==2) printf("%s ", $1);}' | read VAR1 VAR2 set head off... (2 Replies)
Discussion started by: pranavagarwal
2 Replies

2. Shell Programming and Scripting

Oracle Query results to be stored in variables

Hi I would like to know if there is a way to just have one ORACLE connection established, using which we can execute different queries and store the results under different variables. For e.g the following uses to two silent ORACLE connection to store the result under two different... (4 Replies)
Discussion started by: ashokjaysiv
4 Replies

3. Shell Programming and Scripting

Oracle Query results to be stored in variables using unix

I want to store the sql query output into a variable #!/bin/ksh ORACLE_SID=DB01; export ORACLE_SID; export FILE_PATH=/home/asg/Tmp # Order Checking echo " removing old files " rm $FILE_PATH/Malformed_Order.txt echo " Enter the Malformed Order ....!" read orders echo "Regrade... (5 Replies)
Discussion started by: Nareshp
5 Replies

4. UNIX for Dummies Questions & Answers

how to - redirect query results to a variable

How can I send the results of a query to a unix variable. I basically want to run a query then do some logic on the results. Trying to redirect the result into a variable I define in the script. select count(*) as counter from table - nut to redirect the "count" returned from the query... (2 Replies)
Discussion started by: rstone
2 Replies

5. Shell Programming and Scripting

SQL/Plus in a coprocess example. Also saves query results into shell variables

While assisting a forum member, I recommended running SQL/Plus in a coprocess (to make database connections and run a test script) for the duration of his script rather than starting/stopping it once for every row in a file he was processing. I recalled I made a coprocess example for folks at... (2 Replies)
Discussion started by: gary_w
2 Replies

6. Shell Programming and Scripting

How to store results of multiple sql queries in shell variables in ksh?

Hi, I have a script where I make a sqlplus connection. In the script I have multiple sql queries within that sqlplus connection. I want the result of the queries to be stored in shell variables declared earlier. I dont want to use procedures. Is there anyway else. Thanks in advance.. Cheers (6 Replies)
Discussion started by: gonchusirsa
6 Replies

7. Shell Programming and Scripting

How to Assign SQL Query Results to Variables in Linux?

Hi, I am new to linux... How to Assign SQL Query Results to Variables in Linux,i want ti generate it in param files, Can anyone please explain me. Ex: SQL> Select * from EMP; O/P: Emp_No Emp_Name 1 AAA 2 BBB 3 CCC and I want expected... (5 Replies)
Discussion started by: Sravana Kumar
5 Replies

8. Shell Programming and Scripting

Mailing query results in tabular format

Hi , I am purging two tables based on date. In my script I am taking the count of the tables purging them and then taking the after counts. I need to mail the before and after counts of the two tables in a mail in table format as mentioned in the result section. For Eg: ## Count of the... (14 Replies)
Discussion started by: CFA
14 Replies

9. Shell Programming and Scripting

Assigning multiple column's value from Oracle query to multiple variables in UNIX

Hi All, I need to read values of 10 columns from oracle query and assign the same to 10 unix variables. The query will return only one record(row). I tried to append all these columns using a delimiter(;) in the select query and assign the same to a single variable(V) in unix. I thought I... (3 Replies)
Discussion started by: hkrishnan91
3 Replies

10. Shell Programming and Scripting

Postgre Query results as Email HTML table

Hello, I'm trying to send email from Greenplum query results as HTML table with status Red/Green Select Server, Last_Date from Table; Results Server, Last_Date Prod, 2018-04-09 Final email Output in HTML format Server Status LastDate Prod GREEN(BOX) 2018-04-09 (if... (2 Replies)
Discussion started by: krux_rap
2 Replies

LEARN ABOUT OSF1

dop

dop(8)							      System Manager's Manual							    dop(8)

NAME

       dop - Allows a user to execute a privileged program without knowing the root password. The dop command also modifies the action database.

SYNOPSIS

       /usr/sbin/dop [-n  | -N] [ui:] action [args]

       /usr/sbin/dop -a priv[,priv]... action [ui:]pathspec[,[ui:]pathspec]...

       /usr/sbin/dop -a priv[,priv]... [ui:]pathspec

       /usr/sbin/dop -d  action

       /usr/sbin/dop [-w  | -W]

OPTIONS

       Invokes	a  prompt  asking  the	user  if  they want to run the command as a user or as root. The root password is required to run as root.
       Attempts to run the action with the user privileges.  Adds new actions to the dop database.  Deletes an existing action from the dop  data-
       base.  Writes a binary image without changing the source.  Updates the actionlist from the dop action file and then executes the -w option,
       which writes the binary image.

OPERANDS

       Name of privileged program to invoke Arguments to pass to the application guarded by the privilege.  Comma separated  privilege	list  (see
       sysman dopconfig) The fully qualified path name and arguments for the associated action.

	      When  specified by a comma separated pathlist and arguments for multiple user interface domains (ui:), the first ui: argument speci-
	      fied is used as the default. If no action is specified, then the path base name is used. A  run-time  argument  replaces	the  first
	      occurrence of asterisk as a word (for example *) in a string, or else they are ignored. Path arguments should be quoted per the cur-
	      rent shell.  Optional.  A user interface domain, typically one of X11, suit, java, menu, cui, or cli.

DESCRIPTION

       The dop (Division of Privileges) command can execute an action after proper authentication from	the  privilege	database  file.  For  more
       information, see the Security guide.

RESTRICTIONS

       You must have root privileges to modify the privileges database.

EXAMPLES

       The following example will add an action to the AccountManagement privilege.  dop -a AccountManagement adduser_script /usr/sbin/adduser

       The following example runs the action adduser_script for the AccountManagement privilege.  dop adduser_script

       The following example deletes the adduser_script action from the action database.  dop -d adduser_script

FILES

       Executable file.  Executable file for adding or deleting permissions for users and or groups.  dop database.

SEE ALSO

       Commands: sysman(8)

																	    dop(8)
All times are GMT -4. The time now is 10:08 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy