How to store count of multiple queries in variables in a shell script? Post: 302886361

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to store query multiple result in shell script variable(Array)

:) Suppose,I have one table A. Table A have one column. Table A have 10 rows. I want this 10 rows store into shell script variable. like #!/bin/ksh v_shell_var=Hi here in call oracle , through loop How can I store table A's 10 rows into v_shell_var (Shell Script Array). Regards, Div

2. Shell Programming and Scripting

How to store contents of a command in array of variables in shell script?

I want to store contents of command dir in array of variables For eg: dir contents are command d2 demovi~ file inven java new untitled folder d1 demovi er1 filename inven~ myfiles ubuntu desktop xmms ----------------------------------- I...

3. Shell Programming and Scripting

Multiple MySql queries in shell script?

Hi guys, i know how to run a single query using mysql embedded in a shell script as follows: `mysql -umyuser -pmypass --host myhost database<<SQL ${query}; quit SQL` However, how would i be able to run several queries within the same connection? The reason for this is i am creating...

4. Shell Programming and Scripting

store multiple variables in one go

Guys anyone know how i can store fields into multiple variables in one go? I'm wanting to grab the disk id's from format into disk1 and disk2 Below is what i want to work but i know it doesnt :- : | format | awk '/^(\ +)/ {print $2}' | read disk1 disk2 The below does work...but i don't...

5. Shell Programming and Scripting

count multiple objects in shell script

Hi all: Trying to count the number of oracle instances on HPUX 11.23 - using ksh. I have multiple instances running and I would like to have a count for how many processes for each instance. Example, run the 'ps -efu oracle' command and for each instance increment a counter. So I am looking for...

6. Shell Programming and Scripting

Shell Script to store contents of multiple files into one

Hi, I"m writing a script to store all the contents of multiple files with different file names into one single file. I am giving in only last modified date of file in a folder. The below script gives a list of just one file based on the input date i give which is taken as string variable. I...

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

8. Shell Programming and Scripting

Executing Multiple Queries in parallel in Shell

I have n number of SQL queries needs to executed in Shell. Result of this query need to assign in a variable. Once all the queries are executed script needs to exit. Sample Query: SQL 1: Select Count(*) from TABLE GROUP BY COL1,COL2 SQL 2: Select Count(*) from TABLE GROUP BY COL1,COL2 ...

9. Shell Programming and Scripting

Shell script to read a file and store in variables

10. Shell Programming and Scripting

Shell script count lines and sum numbers from multiple files

I want to count the number of lines, I need this result be a number, and sum the last numeric column, I had done to make this one at time, but I need to make this for a crontab, so, it has to be an script, here is my lines: It counts the number of lines: egrep -i String file_name_201611* |...

LEARN ABOUT PHP

ingres_field_name

INGRES_FIELD_NAME(3)							 1						      INGRES_FIELD_NAME(3)

ingres_field_name - Get the name of a field in a query result

SYNOPSIS

       string ingres_field_name (resource  $result, int  $index)

DESCRIPTION

       ingres_field_name(3) returns the name of a field in a query result.

       Note

	      Related Configurations

	       See ingres.array_index_start in Runtime Configuration

PARAMETERS

	      o $result
		- The query result identifier

	      o $index
		-$index   is   the   field   whose   name   will  be  retrieved.   The	possible  values  of  $index  depend  upon  the  value	of
		ingres.array_index_start. If ingres.array_index_start is 1 (the default) then $index must be between 1 and the value  returned	by
		ingres_num_fields(3). If ingres.array_index_start is 0 then $index must be between 0 and ingres_num_fields(3)
		 - 1.

RETURN VALUES

	Returns the name of a field in a query result or FALSE on failure

SEE ALSO

       ingres_query(3), ingres_fetch_array(3), ingres_fetch_assoc(3), ingres_fetch_object(3), ingres_fetch_row(3).

PHP Documentation Group 												      INGRES_FIELD_NAME(3)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to store query multiple result in shell script variable(Array)

Discussion started by: div_Neev

2. Shell Programming and Scripting

How to store contents of a command in array of variables in shell script?

Discussion started by: netresearch

3. Shell Programming and Scripting

Multiple MySql queries in shell script?

Discussion started by: muay_tb

4. Shell Programming and Scripting

store multiple variables in one go

Discussion started by: lavascript