How to pass parameter from file to sqlplus in UNIX?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How pass the input parameter to a file in the script ?

OS version: RHEL 6.7 myTextFile.txt file is referred within Script1.sh script, I only execute Script1.sh and I want the input variable to be passed inside myTextFile.txt . Any idea how I can do this ? $ cat script1.sh cat myTextFile.txt $ cat myTextFile.txt $1 Requirement1....

2. Shell Programming and Scripting

How to pass the parameter in xml file in UNIX shell script?

Hi, I have an XML file like the following... <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ONDEMAND_JOB VERSION="5.1" LOCALE="en_US"> <IMPORT_JOBSET TC_CONNECTION_NAME="default" ENVIRONMENT="PRD" USERNAME="Administrator" PASSWORD="AdminPassword" CALENDAR="Main Monthly Calendar"...

3. Shell Programming and Scripting

How to pass the parameter in xml file in UNIX shell script?

4. UNIX for Dummies Questions & Answers

SQLPLUS Password Parameter file being used when logging in

Good day to everyone. This is my first time posting and just barely above basic Unix training. I think i have search thoroughly to ensure my question hasn't already been posted. But on the off chance the answer has been posted, please be nice as I am not 100% sure I know what I am looking for. I...

5. UNIX for Dummies Questions & Answers

Passing a Unix parameter to SQLPlus login command

hi All, i m trying to pass a user choice paramter from unix to sqlplus connect command here i want the user to enter the username and password he wants to connect in sql plus through read in unix and then automatically connect to that instance. sqlplus -s $1/$2 where $ 1 and $2 will b...

6. Shell Programming and Scripting

Pass value from file to parameter

Hi Guys, I have a file in the format Parmater=value. I want to read the value and pass it to corresponding Variable. The Parameter file is as follows Number=23 Text1=mango Text2=yup 'Number' value needs to be read and passed to ID variable. Also, 'Text1' value needs to be passed to...

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

8. Shell Programming and Scripting

To pass the .sql file as a paramter to sqlplus through shell programming

Hi, Currently i have a .sql file 1.sql. I need to pass that as a parameter through a shell script to the sqlplus inside the same shell script. How I should I do.can anyone help me pls. I have an req where I need to send the .sql file and the place where the script has to create a .csv...

9. Shell Programming and Scripting

Pass tablename as a parameter in the Control File -- sqlldr

Just wanted to know if there is a way to pass the table name as a parameter in the control file. I have two tables...Table A and Table B. LOAD DATA append INTO TABLE TABLE_B FIELDS TERMINATED BY X'09' OPTIONALLY ENCLOSED BY '"' AND '"' TRAILING NULLCOLS Rather than hard coding...

10. UNIX for Advanced & Expert Users

How to pass unix variable to SQLPLUS

hi fellows, can any body tell me how to pass unix variables to oracle code is... #! /bin/ksh echo ENTER DATE VALUE's read START_DATE END_DATE sqlplus xyx/abc@oracle select * from table1 where coloumn1 between $START_DATE and $END_DATE; is this is correct way........... Thanks in...

LEARN ABOUT PHP

mysql_result

MYSQL_RESULT(3) 							 1							   MYSQL_RESULT(3)

mysql_result - Get result data

SYNOPSIS

       Warning

	      This  extension  is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
	      be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:

		     omysqli_data_seek(3) in conjunction with mysqli_field_seek(3) and mysqli_fetch_field(3)

		     o PDOStatement::fetchColumn

       string mysql_result (resource  $result, int  $row, [mixed  $field])

DESCRIPTION

	Retrieves the contents of one cell from a MySQL result set.

	When working on large result sets, you should consider using one of the functions that fetch an entire row  (specified	below).  As  these
       functions return the contents of multiple cells in one function call, they're MUCH quicker than mysql_result(3). Also, note that specifying
       a numeric offset for the field argument is much quicker than specifying a fieldname or tablename.fieldname argument.

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

	      o $row
		- The row number from the result that's being retrieved. Row numbers start at 0.

	      o $field
		- The name or offset of the field being retrieved.  It can be the field's offset, the field's name, or the field's table dot field
		name (tablename.fieldname). If the column name has been aliased ('select foo as bar from...'), use the alias instead of the column
		name. If undefined, the first field is retrieved.

	The contents of one cell from a MySQL result set on success, or FALSE on failure.

       Example #1

	      mysql_result(3) example

	      <?php
	      $link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
	      if (!$link) {
		  die('Could not connect: ' . mysql_error());
	      }
	      if (!mysql_select_db('database_name')) {
		  die('Could not select database: ' . mysql_error());
	      }
	      $result = mysql_query('SELECT name FROM work.employee');
	      if (!$result) {
		  die('Could not query:' . mysql_error());
	      }
	      echo mysql_result($result, 2); // outputs third employee's name

	      mysql_close($link);
	      ?>

       Note

	       Calls to mysql_result(3) should not be mixed with calls to other functions that deal with the result set.

       mysql_fetch_row(3), mysql_fetch_array(3), mysql_fetch_assoc(3), mysql_fetch_object(3).

PHP Documentation Group 													   MYSQL_RESULT(3)

Programming