Write a trigger statement execution, the compiler error, ask for help-CodePudding

O great god help, online in a hurry, thanks

CodePudding user response:

If inserting then
.
end if;

CodePudding user response:

Thanks for a great god

CodePudding user response:

reference 1st floor selling fruit net reply:

if inserting then
.
end if;

changed after I don't complain, but why do I insert the data after the script output should not be first hint below will begin to insert data
1 row has been inserted, and I turned out to be the other way around, to prompt a row has been inserted, the prompt will begin to insert the data

CodePudding user response:

Dbms_output output, it is not timely, or lagging,

You can run a large circulation in dozens of data, is to see the result of all the data are inserted into the successful, can appear the DBMS to print content,

CodePudding user response:

The

reference 4 floor selling fruit net reply:

dbms_output output, it is not timely, or lagging,

You can run a big circle write dozens of data, is to see the result of all the data are inserted into the successful, can appear the DBMS to print, the content of the

I won't post, only in this I ask you a question, why the FOR LOOP without open the cursor, extraction, and closing process

CodePudding user response:

reference 5 floor weixin_44763303 reply:

I won't post, only in this I ask you a question, why the FOR LOOP without open the cursor, extraction, and closing process

You want to ask why not open the action, it's difficult to answer this,

The example below, you should say is the difference between the two

Cursor SSS is the select * from TAB.
The open SSS;
The for loop in XXX x
end loop;
The close SSS;

For x in (select * from TAB) loop
end loop;