ORACLE uses cursor for in

cursor cur is to define a cursor, and then store the query statements defined in the cursor to the cursor.

Because the data found by the query statement is often several records.

But when you use it, you can only take it out one by one and use it.

This is where the benefits of the cursor come into play.

Cursors are stored with several records.

But when it comes to reading, he reads one record at a time.

Then use for in to loop a bit.

You can read the records you store in the cursor one by one, but only one at a time.

for your convenience.

In this case, if you don't use a cursor, you will often get an error of returning multiple lines of results.

ascursor should be as cursor

w name varchar2 This should declare the size of the data type, e.g. varchar2(50); At the same time, it is best not to have the same name as the field name.

begin dbms_; end;You don't need to write begin end here; Write dbms directly;

For example, create or replace procedure test forinloop() as

cursor test_cursor is

select w_name from work_oracle_test;

v_name work_oracle_test%rowtype;

beginfor v_name in test_cursor loop

dbms_;

end loop;

end testforinloop;

You can also: create or replace procedure test forinloop() as

cursor test_cursor is

select w_name from work_oracle_test;

v_name varchar2(50);

beginfor v_name in test_cursor loop

dbms_;

end loop;

end testforinloop;

Can you use loops when defining processes?

create or replace procedure test_forlnloop() is

cursor test_cursor is select w_name from work_oracle_test;

beginfor w_name in test_cursor loopdbms_;

end loop;

end;It seems that your w name does not need to be declared, and can be used directly in for.

There's only one kind. open cursorname on it.

After defining a parameter cursor, when the cursor is opened multiple times with different parameter values, different result sets can be produced, and the syntax is as follows:

cursor cursor_name(parameter_name datatype) is select_statement;

When you define a parameter cursor, the cursor parameter can only specify the data type, not the length.

The following is an example: declare

cursor temp_cursor(no number) is select name from cip_temps where id=no;

v_name cip_;

beginopen temp_cursor(1);

loop

You can pass it as you want, and in just means that the corresponding parameter can only be used to pass the value.

cursor means cursor.

Cursors are generally used in stored procedures to query, modify, or delete certain data that meets the requirements.

For details, see Cursor Use for PL SQL Programming.

Hello, please refer to the following**:

A cursor is a dataset, which is the one you used in the example above (select * from t t).

for variable in cursor loop

.end loop

You're using an implicit cursor here, and cur is just equivalent to a variable.

So when you use cur as a cursor, you will get an error.

Cursor is cursor, which is used in the storage program to occupy time to store data, and then take it out sequentially.