Compare the data in a table with the input parameters in Oracle and perform corresponding operations (stored procedure)

In Oracle, compare the data in a table with the input parameters and perform corresponding operations (stored procedures). If table a contains y records greater than x, insert y A words to Table.

In Oracle, compare the data in a table with the input parameters and perform corresponding operations (stored procedures). If table a contains y records greater than x, insert y A words to Table.

Compare the data in a table with the input parameters in Oracle and perform corresponding operations (stored procedure)

[Date: 2012-07-13] Source: Linux community Author: szstephen enzhou [Font:]

Compare the input data in a table in Oracle.

Table has a number field
The stored procedure test has a variable x. \

If there are more than y records for table a fields, insert y records for table A fields equal to x.
If field a does not have a record greater than x, all fields a are added with 100.

Okay, go directly to the test data.

,