You could try an array. This should work with bash; your shell might have another notation implemented:
You get at the variables' contents like echo ${aa_array[0]} etc. Inserting # before the array name will yield the count of elements.
Hello,
I am an intermediate scripter. I can usually find and adapt what I need by searching through previous postings, but I'm stumped.
I have a string with the format "{Name1 Release1 Type1 Parent1} {Name2 Release2 Type2 Parent2}". It is being passed as an argument into a ksh script. I need to... (5 Replies)
Hi,I have a single sql file containing many create table ddl's.Example:
CREATE TABLE sec_afs
(
rpt_per_typ_c char(1) NOT NULL,
rpt_per_typ_t varchar(20) NULL,
LOCK ALLPAGES
go
EXEC sp_primarykey 'sec_afs', rpt_per_typ_c
go
GRANT SELECT ON sec_afs TO developer_read_only... (5 Replies)
How do I dynamically assign the below output to unix shell variables
so I can build a menu in a shell script?
Example:
var1 = 1 var2= SYSTEM
var3 = 2 var4= UNDOTBS1
and so on, then in the shell script I can use the variables to build a menu.
set serveroutput on
declare... (2 Replies)
Hello,
I have a paramter $param consisting just of two literals and want to split it into two parameters, so I can combine it to a new parameter <char1><string><char2>, but the following code didn't work:
tmp_PARAM_1=cut -c1 $PARAM
tmp_PARAM_2=cut -c2 $PARAM... (2 Replies)
This is for an Oracle journal import. I was using a pl/sql package and oracle API's. Oracle added invoker rights to their API's and now my package won't run. I didn't want to use their API's anyway. The only reason i was using pl/sql and the API's (just a package) was to utilize a cursor. How... (2 Replies)
Hi,
I have a file called files.txt which contains data like
http://abc.xyz.com/ghi/klm/nop/qrs/tuv/wxyz/
There are multiple lines like the above in this file.
In .sh script, I would like to read this file, split each line, and store the variable of "qrs" and "wxyz" in separate variables.
... (3 Replies)
I have a SQL query
SELECT
BLAH_ID,
BLAH_CODE,
DATEFORMAT(CALENDAR_DATE, 'MM-DD-YYYY') AS CALENDAR_DATE_STR,
HOURS,
'N',
FROM blah_tmp_tbl order by CALENDAR_DATE_STR,BLAH_ID,BLAH_CODE;
OUTPUT TO 'MyExport.CSV' quote '' FORMAT ASCII;
That gets me the below output;
... (2 Replies)
Hi All,
I have around 900 Select Sql's which I would like to run in an awk script and print the output of those sql's in an txt file.
Can you anyone pls let me know how do I do it and execute the awk script? Thanks. (4 Replies)
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Hello gurus,
I have data in one of the oracle tables as as below:
Column 1 Column 2
1 NY,NJ,CA
2 US,UK,
3 AS,EU,NA
fyi, Column 2 above has data delimited with a comma as shown.
I need a sql query the produce the below output in two columns... (5 Replies)
Discussion started by: calredd
5 Replies
LEARN ABOUT PHP
count
COUNT(3) 1 COUNT(3)count - Count all elements in an array, or something in an objectSYNOPSIS
int count (mixed $array_or_countable, [int $mode = COUNT_NORMAL])
DESCRIPTION
Counts all elements in an array, or something in an object.
For objects, if you have SPL installed, you can hook into count(3) by implementing interface Countable. The interface has exactly one
method, Countable::count, which returns the return value for the count(3) function.
Please see the Array section of the manual for a detailed explanation of how arrays are implemented and used in PHP.
PARAMETERS
o $array_or_countable
- An array or Countable object.
o $mode
- If the optional $mode parameter is set to COUNT_RECURSIVE (or 1), count(3) will recursively count the array. This is particu-
larly useful for counting all the elements of a multidimensional array.
Caution
count(3) can detect recursion to avoid an infinite loop, but will emit an E_WARNING every time it does (in case the array
contains itself more than once) and return a count higher than may be expected.
RETURN VALUES
Returns the number of elements in $array_or_countable. If the parameter is not an array or not an object with implemented Countable inter-
face, 1 will be returned. There is one exception, if $array_or_countable is NULL, 0 will be returned.
Caution
count(3) may return 0 for a variable that isn't set, but it may also return 0 for a variable that has been initialized with an empty
array. Use isset(3) to test if a variable is set.
EXAMPLES
Example #1
count(3) example
<?php
$a[0] = 1;
$a[1] = 3;
$a[2] = 5;
$result = count($a);
// $result == 3
$b[0] = 7;
$b[5] = 9;
$b[10] = 11;
$result = count($b);
// $result == 3
$result = count(null);
// $result == 0
$result = count(false);
// $result == 1
?>
Example #2
Recursive count(3) example
<?php
$food = array('fruits' => array('orange', 'banana', 'apple'),
'veggie' => array('carrot', 'collard', 'pea'));
// recursive count
echo count($food, COUNT_RECURSIVE); // output 8
// normal count
echo count($food); // output 2
?>
SEE ALSO is_array(3), isset(3), strlen(3).
PHP Documentation Group COUNT(3)