add the output of a query to a variable to be used in another query Post: 302300702

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to store the sql query's output in a variable

Hi, My requirement is : We are calling an sql statement from a UNIX session, and fetching data into some variables from a table .. now we are unable to access these variables from outside the SQL part. Please let me know how can I achieve this. Can you please share a code snippet which...

2. UNIX for Dummies Questions & Answers

Redirect Query o/p to variable

Hi, I wanted to o/p the number of rows in a table to a variable in linux. How can i achieve this. I wrote the query and its settings like feedback, pagesize line size in a file and using this file as a parameter to the sqlplus command. now can i redirect the o/p of that query to a variable....

3. Solaris

awk output query

Hi Everyone, When i issue command like ls -l | awk '/udtts/ {print $9}' =============================== I am getting output as udttsGEHLNAR.6864 udttsGEHLNAR.7921 udttsNARALAX.15415 udttsNARALAX.18016 But I want output after dot i.e like 6864 7921 15415 18016

4. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the...

5. Shell Programming and Scripting

How to use a variable in insert query?

My script contains as follows, VALUE=`sqlplus un/pwd <<EOF > OB.txt set pagesize 0 feedback off verify off heading off echo off select max(1) from table1; exit; EOF` insert into table2 values(1, 'The max value is $value',...); i need the value of VALUE to be inserted after 'The max...

6. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ...

7. UNIX for Dummies Questions & Answers

UNIX Query About wc -l output

I was performing the wc -l operation in one data file the result is less when i was giving -nu on the view of the file. while giving wc -l the count is 5023 after setting line numbers in view of file is giving 5024. Can anyone help on this....

8. Shell Programming and Scripting

Getting variable from a query

Hi, I need to get a variable HMAX_TBL_ID and then use it in second select query. The first select statement returns few leading white spaces for ex : 12345 so when I run the script HMAX_TBL_ID does not return the "12345" , it returns blank. Please let me know what I am missing. ...

9. Shell Programming and Scripting

How to pass variable to a query?

Hi All, How to pass date variable to a query? I have tried the below one , but it's not working. ost.ksh #!/bin/ksh v_date=$1 var=$(sqlplus -s $ORACON <<ENDOFSQL SELECT TO_DATE('$v_date','DD-MON-YYYY'),-1) FROM DUAL; exit; ENDOFSQL ) #End I have executed as below.

10. Shell Programming and Scripting

How to Assign the Output of an SQL Query to a Variable?

Hi iam new to shell scripting how to declare variables as redshift query and I have to compare two counts by using if condition . ex:count=select count(*) from prd; select count(*) from prd; select count(*) from tag; can any one help me . Please use CODE tags when displaying...

LEARN ABOUT PHP

mssql_fetch_row

MSSQL_FETCH_ROW(3)														MSSQL_FETCH_ROW(3)

mssql_fetch_row - Get row as enumerated array

SYNOPSIS

       array mssql_fetch_row (resource	$result)

DESCRIPTION

       mssql_fetch_row(3)  fetches  one  row  of  data	from the result associated with the specified result identifier. The row is returned as an
       array. Each result column is stored in an array offset, starting at offset 0.

	Subsequent call to mssql_fetch_row(3) would return the next row in the result set, or FALSE if there are no more rows.

PARAMETERS

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

RETURN VALUES

	Returns an array that corresponds to the fetched row, or FALSE if there are no more rows.

EXAMPLES

       Example #1

	      mssql_fetch_row(3) example

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

	      // Query to execute
	      $query = mssql_query('SELECT [id], [quote] FROM [quotes] WHERE [id] = '42'', $link);

	      // Did the query fail?
	      if (!$query) {
		  die('MSSQL error: ' . mssql_get_last_message());
	      }

	      // Fetch the row
	      $row = mssql_fetch_row($query);

	      // Print the 'quote'
	      echo 'Quote #' . $row[0] . ': "' . $row[1] . '"';
	      ?>

	      The above example will output something similar to:

	      Quote #42: "The answer to everything..."

NOTES

       Note

	      This function sets NULL fields to the PHP NULL value.

SEE ALSO

       mssql_fetch_array(3), mssql_fetch_object(3), mssql_data_seek(3), mssql_result(3).

PHP Documentation Group 													MSSQL_FETCH_ROW(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to store the sql query's output in a variable

Discussion started by: venkatesh_sasi

2. UNIX for Dummies Questions & Answers

Redirect Query o/p to variable

Discussion started by: Swapna173

3. Solaris

awk output query

Discussion started by: gehlnar

4. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Discussion started by: balaeswari