Home » Developer & Programmer » Forms » How can I describe dimension without create table in oracle forms?
How can I describe dimension without create table in oracle forms? [message #81434] Mon, 17 February 2003 08:18 Go to next message
Kutlay Pinar
Messages: 4
Registered: January 2002
Junior Member
I want to write dimension like in basic or cobol.
Example : a(I)=X OR a(I,J)=Y

But I don't want to create table on database.

If you send me an example , I am very glad.

Thanks.
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 Go to previous message
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.]]
Previous Topic: I WANT TO RUN FORMS 6I AND FORMS 5 ON SAME MACHINE
Next Topic: New to D2K
Goto Forum:
  


Current Time: Thu Mar 28 13:51:28 CDT 2024