Re: Urgent help required

"Solidnull, Inc." <andrew_at_solidnull.com> wrote in message news:<3bf23a4b$1_at_motown>...
> Hi,
>
> Does anyone know how to assign values to variables in pl/sql? Do i have to
> use a constructor in this case and how? e.g. x1 := fld_x ???? For instance i
> do have two fields in my database fld_x. and fld_y and also i have created
> variebles such as x1,x2,x3,x4 y1,y2,y3 and y4 as coordinates in 2d space.
> i.e. (x1,y1) (x2,y2) (x3,y3) (x4,y4) these represent my variables.
>
> With regards,
>
>
> Andrew

Decide which you are really using objects or variables. Variables are just declared. Objects are declared and then instanciated (sp?) with a constructor.
so if X1 is a pl/sql variable you could

DECLARE
  X1 NUMBER;
BEGIN

• assign a value directly X1 := 1 ;
• or retrieve a value from the database SELECT FLD_X INTO X1 FROM YOUR_TABLE WHERE <conditions the resolve to one row> ; and so on . . .

Since I haven't done much with objects, I'll leave examples up to other posters. Also, there should be plenty of help in your PL/SQL manual. Received on Wed Nov 14 2001 - 13:01:13 CST