Can a %ROWCOUNT attribute returns the total number of rows returned by

1.	Can a %ROWCOUNT attribute returns the total number of rows returned by the FETCH command?
Answer» With PL/SQL, we can create a user-defined subtype. It already has PREDEFINED subtypes in STANDARD package. Let us now SEE how to create an INTEGER subtype: DECLARE SUBTYPE info IS varchar2(50); car info; BEGIN car:= 'I LOVE cars!'; dbms_output.put_line(car); END; / The output: I love cars!

Can a %ROWCOUNT attribute returns the total number of rows returned by the FETCH command?

Answer»

With PL/SQL, we can create a user-defined subtype. It already has PREDEFINED subtypes in STANDARD package.

Let us now SEE how to create an INTEGER subtype:

DECLARE SUBTYPE info IS varchar2(50); car info; BEGIN car:= 'I LOVE cars!'; dbms_output.put_line(car); END; /

The output:

I love cars!