How to declare an array to take more than 10,000 characters


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to declare an array to take more than 10,000 characters
# 1  
Old 01-15-2008
Data How to declare an array to take more than 10,000 characters

Hi Guys
Need some help

I am reading the string values from the text files into the shell script and had them feed into array
I have declared an associative array as
TYPE t_user_id_tab IS TABLE OF VARCHAR2(3000);\n
my_user_id t_user_id_tab;\n
varchar2 is limiting me to take only 32760 characters
but I have a text files which has more than 1100 users with length of each user id is 8
1100* 8 = 8800 + the '',sapces

so I am looking around 10,000 characters is there a way that I can declare the array of string to take 10,00 characters

Thanks in advance
Pinky
Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. Programming

How to Declare an array of function pointers?

I am attempting to create an array of function pointers. The examples I follow to do this are from: support.microsoft.com/en-us/help/30580/how-to-declare-an-array-of-pointers-to-functions-in-visual-c ... (3 Replies)
Discussion started by: spflanze
3 Replies

2. UNIX for Dummies Questions & Answers

How to declare an array in UNIX and print the elements with tab delimits?

Hello, In a shell script, I want to declare an array and subsequently print the elements with tab delimits. My array has the following structure and arbitrary elements: myArray=('fgh' 'ijk' 'xyz' 'abc'); Next, I would like to print it with a '\n' at the end. Thanks for your input! ... (2 Replies)
Discussion started by: Gussifinknottle
2 Replies

3. Shell Programming and Scripting

create array holding characters from sring then echo array.

Hi, I wish to store $string1 in $string1array a character in each array element. Then i wish to echo the entire array to the screen so that it reads as the normal string again. I have been trying with the code below but does not work. Please help... To put string into array: ... (5 Replies)
Discussion started by: rorey_breaker
5 Replies

4. Shell Programming and Scripting

declare, assign variables using array, counter, loop

using bash Tru64... converting DCL to shell... any tips to make this work would be greatly appreciated. Below is my failed attempt to assign command line input to variables by first declaring an array. I use a counter to create unique variables in a loop through the array. I need to call... (3 Replies)
Discussion started by: egkumpe
3 Replies

5. News, Links, Events and Announcements

Microsoft "Donates" $3,000,000,000 to Feds

Surreal quote from the news link below: http://www.washingtonpost.com/wp-dyn/articles/A44615-2002Nov12.html (0 Replies)
Discussion started by: Neo
0 Replies
Login or Register to Ask a Question
MYSQLI_FETCH_ALL(3)							 1						       MYSQLI_FETCH_ALL(3)

mysqli_result::fetch_all - Fetches all result rows as an associative array, a numeric array, or both

       Object oriented style

SYNOPSIS
mixed mysqli_result::fetch_all ([int $resulttype = MYSQLI_NUM]) DESCRIPTION
Procedural style mixed mysqli_fetch_all (mysqli_result $result, [int $resulttype = MYSQLI_NUM]) mysqli_fetch_all(3) fetches all result rows and returns the result set as an associative array, a numeric array, or both. PARAMETERS
o $ result -Procedural style only: A result set identifier returned by mysqli_query(3), mysqli_store_result(3) or mysqli_use_result(3). o $resulttype - This optional parameter is a constant indicating what type of array should be produced from the current row data. The possible values for this parameter are the constants MYSQLI_ASSOC, MYSQLI_NUM, or MYSQLI_BOTH. RETURN VALUES
Returns an array of associative or numeric arrays holding result rows. MYSQL NATIVE DRIVER ONLY
Available only with mysqlnd. As mysqli_fetch_all(3) returns all the rows as an array in a single step, it may consume more memory than some similar functions such as mysqli_fetch_array(3), which only returns one row at a time from the result set. Further, if you need to iterate over the result set, you will need a looping construct that will further impact performance. For these reasons mysqli_fetch_all(3) should only be used in those sit- uations where the fetched result set will be sent to another layer for processing. SEE ALSO
mysqli_fetch_array(3), mysqli_query(3). PHP Documentation Group MYSQLI_FETCH_ALL(3)