SQL replace cursor writing example, SQL cursor writing example

SQL replace cursor writing example, SQL cursor writing example

Update Tb_Garden1 G Set Steward = (Select Id From Zyq. tb_User U Where Replace (U. name, 'region') = G. name And Rownum = 1) where exists (select 1 from zyq. tb_user u where Replace (U. name, 'region') = G. name And rownum = 1)

SQL cursor writing

Do I have to use a cursor?
This can be done without a cursor.

Update B set price = price + 1
From A, B
Where A. id = B. id and a. prodate like '2017-6-2012 ';
Commit;

An example of SQL cursor writing is as follows:

The prompt "the cursor is not opened" is because there is nothing in your WHILE loop, and the system will set CLOSE CUR_NAME to your loop body by default, so the close cur_name statement is consistently executed, of course, a consistent prompt is displayed, indicating that the cursor is not enabled.

If you use the temporary function, you need to analyze the specific situation and view your requirements.