Shulou(Shulou.com)05/31 Report--

This article mainly introduces the oracle trigger error did not find the data how to do, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor with you to understand.

Select ts.tbcxsx into param_timeLimit from winf_sv_ex_hybs_tbcxsq ts

Where ts.sblsh=:new.sblsh and ts.xh=:new.xh

If no records are found, add a sentence after that.

Exception when no_data_found then

Param_timeLimit: = 0;

Thank you for reading this article carefully. I hope the article "what to do if the trigger failed to find data in oracle" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.