How to pass Variable from shell script to select query for SqlPlus? Post: 302857199

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to pass variable to SQLPLUS in a ksh script?

Hi, I am writing a ksh script which will use sqlplus to run a sql and pass 2 variables as the SQL request. In the ksh script, I have 2 variables which are $min_snap and $max_snap holding 2 different numbers. Inside the same script, I am using SQLPLUS to run an Oracle SQL script,...

2. UNIX for Dummies Questions & Answers

select count(*) in sqlplus into variable unix shell

Need to select count(*) from table to check for zero result in unix script

3. Shell Programming and Scripting

How to pass parameter from sqlplus(procedure completed) to your shell script

if then # mail -s "Import failed file does not exist" sanjay.jaiswal@xyz.com echo "FILE does not exist" exit 1 fi echo "FILE EXIST" size=-1 set $(du /export/home/oracle/nas/scott21.dmp.gz) while do echo "Inside the loop" size=$1 set $(du...

4. Shell Programming and Scripting

In a csh script, can I set a variable to the result of an SQLPLUS select query?

Can someone tell me why I'm getting error when I try to run this? #!/bin/csh -f source ~/.cshrc # set SQLPLUS = ${ORACLE_HOME}/bin/sqlplus # set count=`$SQLPLUS -s ${DB_LOGIN} << END select count(1) from put_groups where group_name='PC' and description='EOD_EVENT' and serial_number=1;...

5. Shell Programming and Scripting

redirecting oracle sqlplus select query into file

So, I would like to run differen select queries on multiple databases.. I made a script wich I thought to be called something like.. ./script.sh sql_file_name out.log or to enter select statement in a command line.. (aix) and I did created some shell script wich is not working.. it...

6. Shell Programming and Scripting

Problems with storing oracle sqlplus query output shell script

Hello everyone, I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected. I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't...

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

8. Shell Programming and Scripting

How to print the output of a select query using shell script?

HI, I want to connect to database and fetch the count from a table. The sql query is as below : select count(*) from table_test where test_column='read'; How can I print the output of this statement using shell script. Thanks in advance.

9. Shell Programming and Scripting

Shell Script (ksh) - SQLPlus query filter using a string variable

Using ksh, I am using SQLPlus to execute a query with a filter using a string variable. REPO_DB=DEV1 FOLDER_NM='U_nmalencia' FOLDER_CHECK=$(sqlplus -s /nolog <<EOF CONNECT user/pswd_select@${REPO_DB} set echo off heading off feedback off select subj_name from subject where...

10. Shell Programming and Scripting

Pass a VARIABLE to sqlplus script

Hi Team, I am trying to run a sqlplus script against several databases via a FOR/LOOP and also passing the loop variable to a sqlplus script I am calling, as follows: #!/bin/bash export ORACLE_SID=plgc1 export ORACLE_HOME=/opt/oracle/product/11.2.0.2/db_1 export...

LEARN ABOUT PHP

udm_get_res_field

UDM_GET_RES_FIELD(3)							 1						      UDM_GET_RES_FIELD(3)

udm_get_res_field - Fetch a result field

SYNOPSIS

       string udm_get_res_field (resource  $res, int  $row, int  $field)

DESCRIPTION

	Fetch a mnoGoSearch result field.

PARAMETERS

	      o $res
		-$res - a link to result identifier, received after call to udm_find(3).

	      o $row
		-$row - the number of the link on the current page. May have values from 0 to $UDM_PARAM_NUM_ROWS-1.

	      o $field
		-$field - field identifier, may have the following values:

		     o UDM_FIELD_URL - document URL field

		     o UDM_FIELD_CONTENT - document Content-type field (for example, text/html).

		     o UDM_FIELD_CATEGORY  - document category field. Use udm_cat_path(3) to get full path to current category from the categories
		       tree root. (This parameter is available only in PHP 4.0.6 or later).

		     o UDM_FIELD_TITLE - document title field.

		     o UDM_FIELD_KEYWORDS - document keywords field (from META KEYWORDS tag).

		     o UDM_FIELD_DESC - document description field (from META DESCRIPTION tag).

		     o UDM_FIELD_TEXT - document body text (the first couple of lines to give an idea of what the document is about).

		     o UDM_FIELD_SIZE - document size.

		     o UDM_FIELD_URLID - unique URL ID of the link.

		     o UDM_FIELD_RATING - page rating (as calculated by mnoGoSearch).

		     o UDM_FIELD_MODIFIED - last-modified field in unixtime format.

		     o UDM_FIELD_ORDER - the number of the current document in set of found documents.

		     o UDM_FIELD_CRC - document CRC.

RETURN VALUES

       udm_get_res_field(3) returns result field value on success, FALSE on error.

PHP Documentation Group 												      UDM_GET_RES_FIELD(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to pass variable to SQLPLUS in a ksh script?

Discussion started by: rwunwla

2. UNIX for Dummies Questions & Answers

select count(*) in sqlplus into variable unix shell

Discussion started by: struggle

3. Shell Programming and Scripting

How to pass parameter from sqlplus(procedure completed) to your shell script

Discussion started by: sanora600

4. Shell Programming and Scripting

In a csh script, can I set a variable to the result of an SQLPLUS select query?

Discussion started by: gregrobinsonhd