|
Re: How can I describe dimension without create table in oracle forms? [message #81436 is a reply to message #81434] |
Tue, 18 February 2003 03:15 |
magnetic
Messages: 324 Registered: January 2003
|
Senior Member |
|
|
slm,
Using cursors might be a slution
cursors
In oracle we use rowtype
example
declare
cursor c1 is
select column1 c1
, column2 c1
from table1;
r1 c1%rowtype;
begin
open c1;
fetch c1 into r1;
dbms_output.put_line(r1.c1||r2.c2);
close c1;
end;
the variable r1 is kinda array
Besides i believe oracle has arraytypes also.
Using views might be a solution as well.
[[Ne amacla kullanmak istediginizi yazmaliydiniz.
Hedefinizi belirtiniz.]]
|
|
|