How to execute a no of SELECT COUNT(*) statements using a loop Post: 302454629

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

for i loop with conditional statements?

New to scripting in general, so patience plz. If I ask a stupid question or don't get it, I thank you for your kindness in advance. That said, did a for i loops checks to see if a PB* file is there but I need to know two things before I copy the file. I need to know if the file's create date...

2. Shell Programming and Scripting

is that possible to keep statements in any loop??

Hi, Actually i stored all validdisks in one array and corresponding partitions required for all individual disks in other array.. Example: Validdisks=dsk2 dsk3 dsk5 ValidPartition=4 4 3 Now i have to create domain.. Domain creation can be done by below commands: fs_setup -d...

3. Shell Programming and Scripting

How do I execute multiple statements within If then else

Please help me. I have been doing this for several hours. Here is the code if then echo a b c d >> file.txt echo 1111 >> file.txt fi The reason I want the two echo is because I want these statements printed on multiple lines. I keep getting error . First it tells me...

4. Shell Programming and Scripting

for each value in an array, execute select statement

Hello All, I am new to shell scripting. I am working on Solaris O/S, bash script and sybase programming. I want to loop through multiple values in an array and for each value, I want to select a row from the database. following is the code written for it. output="loop.csv" ...

5. Shell Programming and Scripting

execute multiple statements in if-else

how can we execute multiple statements in else condition i have if then statement else statements fi in else condition i have multiple statements but it executing only one statement is there any way to execute multiple statements

6. Shell Programming and Scripting

Combine 4 awk pattern count statements into 1

Hello fellow awkers, I am trying to combine the following awk statements into 1 so that the results are more accurate: awk '/\=\+/ { count++ } END { print count}' filename awk '/\=\?/ { count++ } END { print count}' filename awk '/\=\-/ { count++ } END { print count}' filename awk...

7. Shell Programming and Scripting

2 statements in for loop

Bash shell, variables i and rem are working fine in 2 separate for loops, but I'd like to consolidate them like this: for && This gives syntax error on &&. Thanks in advance for direction.

8. Shell Programming and Scripting

Count lines with awk if statements

Hi Everybody, I wanna count lines in many files, but only if they meet a condition, I have something like this, cat /path1/usr/STAT/GPRS/ESTCOL_GPRS_2016* | awk 'BEGIN{FS=",";}{ if (substr($5,1,8)=='$DATE'){a++} END{for(i in a)print a}}' DATE=$(date +%Y%m%d -d "1 day ago") But it has...

9. Shell Programming and Scripting

For loop statements order of operations

Say I have a for loop that parse through a file....Say it look for the colors red and blue in sections of the file. Say it find red before it find blue in the file. Say I have two if statements in the for loop Something like if blue is found print blue is my favorite color is the first if...

10. UNIX for Beginners Questions & Answers

One Line Command how to use pipe statements to execute and comment on multiple possible outcomes

Hello Forum, I'm looking to expand the following command: INACTIVE_KERNELS=$(python -mplatform | grep -qi red && rpm -qa | grep '^kernel-' |grep -vE `uname -r` | paste -sd \; || echo "Not Red Hat Server") Currently this command will check if my server is RedHat server using the grep -qi...

LEARN ABOUT REDHAT

select_into

SELECT 
INTO(7)							   SQL Commands 						    SELECT INTO(7)

NAME

       SELECT INTO - create a new table from the results of a query

SYNOPSIS

       SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
	   * | expression [ AS output_name ] [, ...]
	   INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table
	   [ FROM from_item [, ...] ]
	   [ WHERE condition ]
	   [ GROUP BY expression [, ...] ]
	   [ HAVING condition [, ...] ]
	   [ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
	   [ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ]
	   [ LIMIT { count | ALL } ]
	   [ OFFSET start ]
	   [ FOR UPDATE [ OF tablename [, ...] ] ]

   INPUTS
       TEMPORARY

       TEMP   If specified, the table is created as a temporary table.	Refer to CREATE TABLE [create_table(7)] for details.

       new_table
	      The name (optionally schema-qualified) of the table to be created.

       All other inputs are described in detail for SELECT [select(7)].

   OUTPUTS
       Refer to CREATE TABLE [create_table(7)] and SELECT [select(7)] for a summary of possible output messages.

DESCRIPTION

       SELECT  INTO creates a new table and fills it with data computed by a query. The data is not returned to the client, as it is with a normal
       SELECT. The new table's columns have the names and data types associated with the output columns of the SELECT.

	      Note: CREATE TABLE AS [create_table_as(7)] is functionally equivalent to SELECT INTO.  CREATE TABLE AS is  the  recommended  syntax,
	      since SELECT INTO is not standard. In fact, this form of SELECT INTO is not available in PL/pgSQL or ecpg(1), because they interpret
	      the INTO clause differently.

COMPATIBILITY

       SQL92 uses SELECT ... INTO to represent selecting values into scalar variables of a host program, rather than creating a  new  table.  This
       indeed  is  the	usage  found in PL/pgSQL and ecpg(1).  The PostgreSQL usage of SELECT INTO to represent table creation is historical. It's
       best to use CREATE TABLE AS for this purpose in new code.  (CREATE TABLE AS isn't standard either, but it's less  likely  to  cause  confu-
       sion.)

SQL - Language Statements					    2002-11-22							    SELECT INTO(7)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

for i loop with conditional statements?

Discussion started by: xgringo

2. Shell Programming and Scripting

is that possible to keep statements in any loop??

Discussion started by: mansa

3. Shell Programming and Scripting

How do I execute multiple statements within If then else

Discussion started by: asemota

4. Shell Programming and Scripting

for each value in an array, execute select statement

Discussion started by: arundhati_s