All Questions
Tagged with multidimensional-array plsql
6 questions
0
votes
3
answers
802
views
Oracle PLSQL Array will not allow me to Index or Extend
create or replace TYPE csv_rec IS OBJECT (client_code varchar2(500),
debtor_code varchar2(500));
--
create or replace TYPE csv_table IS TABLE OF csv_rec;
--
...
- 11
-1
votes
1
answer
204
views
Building a Bidimensional Array in PL/SQL
I am trying to make a matrix to display on 7 lines the days of the week and on each line the total of people hired in the years 93,94,95,96,97, 98 and 99 based on a table that has their hire date as ...
- 620
1
vote
2
answers
6k
views
Initialize and loop through twodimensional array
I'm trying to write a diff procedure in pl/sql. The error message never says what the structure should be like, only it expected some other symbol, usually that would indicate the end of the line. ...
- 5,184
1
vote
1
answer
2k
views
Assign Multi Dimensional Collection in PLSQL
I have a record:
CREATE OR REPLACE TYPE rec01 IS OBJECT
( -- Business
refund_desc VARCHAR2(20),
percentage VARCHAR2(5),
amount VARCHAR2(25),
pmt_method VARCHAR2(20)
)
And then I ...
- 1,172
0
votes
1
answer
1k
views
Search in Nested Tables and Insert the result into new Nested Table!
How can I insert result of an WITH SELECT into a Nested Array (with two attributes) in it?
Here are the DDL and DML SQLs;
Don't worry about the NUMBER( 8 )
CREATE OR REPLACE TYPE DATE_RANGE IS ...
- 1,135
19
votes
3
answers
44k
views
How to manually initialize a collection of RECORDs in PL/SQL?
guys. Here's a simple sample two-dimensional array in PL/SQL, which is working perfectly.
declare
type a is table of number;
type b is table of a;
arr b := b(a(1, 2), a(3, 4));
begin
for i ...
- 11k