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

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

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

LEARN ABOUT PHP

mssql_fetch_field

MSSQL_FETCH_FIELD(3)													      MSSQL_FETCH_FIELD(3)

mssql_fetch_field - Get field information

SYNOPSIS

       object mssql_fetch_field (resource  $result, [int  $field_offset = -1])

DESCRIPTION

       mssql_fetch_field(3) can be used in order to obtain information about fields in a certain query result.

PARAMETERS

	      o $result
		- The result resource that is being evaluated. This result comes from a call to mssql_query(3).

	      o $field_offset
		-  The numerical field offset. If the field offset is not specified, the next field that was not yet retrieved by this function is
		retrieved. The $field_offset starts at 0.

RETURN VALUES

	Returns an object containing field information.

	The properties of the object are:

	      o name - column name. if the column is a result of a function, this property is set to computed#N, where #N is a serial number.

	      o column_source - the table from which the column was taken

	      o max_length - maximum length of the column

	      o numeric - 1 if the column is numeric

	      o type - the column type.

EXAMPLES

       Example #1

	      mssql_fetch_field(3) example

	      <?php
	      // Connect to MSSQL and select the database
	      mssql_connect('MANGOSQLEXPRESS', 'sa', 'phpfi');
	      mssql_select_db('php');

	      // Send a select query to MSSQL
	      $query = mssql_query('SELECT * FROM [php].[dbo].[persons]');

	      // Construct table
	      echo '<h3>Table structure for 'persons'</h3>';
	      echo '<table border="1">';

	      // Table header
	      echo '<thead>';
	      echo '<tr>';
	      echo '<td>Field name</td>';
	      echo '<td>Data type</td>';
	      echo '<td>Max length</td>';
	      echo '</tr>';
	      echo '</thead>';

	      // Dump all fields
	      echo '<tbody>';

	      for ($i = 0; $i < mssql_num_fields($query); ++$i) {
		  // Fetch the field information
		  $field = mssql_fetch_field($query, $i);

		  // Print the row
		  echo '<tr>';
		  echo '<td>' . $field->name . '</td>';
		  echo '<td>' . strtoupper($field->type) . '</td>';
		  echo '<td>' . $field->max_length . '</td>';
		  echo '</tr>';
	      }

	      echo '</tbody>';
	      echo '</table>';

	      // Free the query result
	      mssql_free_result($query);
	      ?>

SEE ALSO

       mssql_field_seek(3).

PHP Documentation Group 												      MSSQL_FETCH_FIELD(3)

Shell Programming and Scripting