How to achieve this?

wang7498

DECLARE
  A NUMBER (16,2);
  B NUMBER (16,2);
BEGIN
  SELECT FIELD1 INTO A, FIELD2 INTO B FROM TABLE;
END;

I find that ORACLE can only be received with one parameter. Is there a similar function?

idpublic

DECLARE
  A TABLE%rowtype;
BEGIN
  SELECT * INTO A FROM TABLE ...;
END;

- A record type can be used

wang7498

I haven’t used it.
Ha ha. Do you want to define a structure yourself?
Then receive again?

whbilly

DECLARE
  A TABLE%rowtype;
BEGIN
  SELECT * INTO A FROM TABLE ...;
END;
This is to put all the fields of the table as a table structure into A

wang7498

DECLARE
  A TABLE%rowtype;
BEGIN
  SELECT * INTO A FROM TABLE ...;
END;
Report an error.
% This is wrong...
I tried a downstream standard. Can be achieved.
One more question. How to get the COUNT of the number of cursor records?

wang7498

DECLARE
  A TABLE%rowtype;
BEGIN
  SELECT * INTO A FROM TABLE ...;
END;

Suppose there is an error when the number of records is greater than 1.

wang7498

Suppose I write it like this and it is wrong.
DECLARE
  A TABLE%rowtype;
BEGIN
  SELECT FIELDA,FIELDB INTO A FROM TABLE ...;
END;
It should be related to the definition part,
A TABLE%ROWTYPE... is this TABLE related?

idpublic

DECLARE
  A TABLE%rowtype;
BEGIN
  SELECT * INTO A FROM TABLE ...;
END;
Report an error.
%This is wrong...
I tried a downstream bid. It can be achieved.

Ask another question. How to get the COUNT of the number of cursor records?
Define a variable a
open cursor
Loop to get cursor variable
a:=cursor%rowcount;
--cursor%rowcount determines the number of rows of records fetched from the cursor, only the records of the cursor have been obtained, in order to get the number of records of the cursor

idpublic

DECLARE
  A TABLE%rowtype;
BEGIN
  SELECT * INTO A FROM TABLE ...;
END;

Suppose there is an error when the number of records is greater than 1.
-
Greater than 1, you can use a cursor

liub950511

Many people don't read books or search, and they just ask simple questions. It is recommended that beginners lay a good foundation, read more books, and check more information.