OraFAQ Forum: SQL & PL/SQL » Default value in Array

Home » SQL & PL/SQL » SQL & PL/SQL » Default value in Array

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Default value in Array [message #2]

Wed, 02 January 2002 01:26

Bhagwan Singh
Messages: 23
Registered: December 2001

Junior Member

Hi,
Iam creating a small pl/sql statement where Iam creating an table array and wants to assign some default values inside that.it gives error.
Declare
Type str_type is table of varchar2(15) not null index by binary_integer;
arr str_type;
begin
dbms_output.put_line(arr.count);
end;
How can I assign default values inside array 'arr' between 'declare' and 'begin' statment?
please help.
bhaggs

----------------------------------------------------------------------

Report message to a moderator

Re: Default value in Array [message #3 is a reply to message #2]

Wed, 02 January 2002 02:43

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Hi,

You can declare the table as a CONSTANT and assign table values to it. Look at this example...

set serveroutput on

DECLARE
TYPE str_type IS TABLE OF VARCHAR2(15) NOT NULL; -- index by binary_integer;
arr CONSTANT str_type := str_type('strVal1', 'strVal2', 'strVal3');
BEGIN
DBMS_OUTPUT.PUT_LINE(arr.COUNT);
END;
/

Best regards

Frank Naude

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	Need Help For Trigger
Next Topic:	screen messages

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 19 04:37:06 CDT 2025