Make use of the stored procedure automatically update the database-CodePudding

Excuse me, I want to write a SQL statement using a stored procedure, function is after I have modified the data in the oracle database automatically update the database, how to implement?

CodePudding user response:

Can describe the demand of more clearly
For example, what is automatically update the database?

CodePudding user response:

Do a job, set up a time to do!

CodePudding user response:

reference 1st floor sych888 response:

can describe the demand of more clearly
For example, what is automatically update the database?

mean I to the data in the database with the operation, such as modify, delete, add after will be automatically saved

CodePudding user response:

refer to the second floor wmxcn2000 response:

do a job, set up a time to do!

so can you make it yourself in more detail, I also just contact, thank you

CodePudding user response:

reference baidu_28077423 reply: 3/f

Quote: refer to 1st floor sych888 response:

Can describe the demand of more clearly
For example, what is automatically update the database?

mean I with all the data from a database operation, such as modify, delete, add after automatically save

What you said is automatically COMMIT?

CodePudding user response:

reference 4 floor baidu_28077423 response:

Quote: refer to the second floor wmxcn2000 response:

Do a job, set up a time to do!

so can you make it yourself in more detail, I also just contact, thank you

You search first, specific problems, and come back to ask again!

Oracle dbms_job

CodePudding user response:

reference 5 floor sych888 reply:

Quote: refer to the third floor baidu_28077423 response:

Quote: refer to 1st floor sych888 response:

Can describe the demand of more clearly
For example, what is automatically update the database?

mean I with all the data from a database operation, such as modify, delete, add after automatically save

What you said is automatically COMMIT?

yes, is this meaning, don't know I can make it stored procedure

CodePudding user response:

refer to the original poster baidu_28077423 response:

excuse me, I want to write a SQL statement using a stored procedure, function is after I have modified the data in the oracle database automatically update the database, how to implement?

Demand is not enough clear,
1, changed the data, it is how to modify, with application software, or use the update command directly modify
2, automatic update, what is automatically updated, delete from emp, and then the data is updated? If so, set the autocommit property, but the risk is very big

CodePudding user response:

refer to 7th floor baidu_28077423 response:

Quote: refer to fifth floor sych888 response:

Quote: refer to the third floor baidu_28077423 response:

Quote: refer to 1st floor sych888 response:

Can describe the demand of more clearly
For example, what is automatically update the database?

mean I with all the data from a database operation, such as modify, delete, add after automatically save

What you said is automatically COMMIT?

yes, is this meaning, don't know I can make it stored procedure

Oracle default is explicitly commit so that you can avoid a lot of wrong operation, this is one of the features of oracle, use for a period of time you become accustomed to, also find
The characteristics of special use, it is strongly recommended that you don't have to spend idea to
in this place
The autocommit mode is off by default
SQL> Show the autocommit
The autocommit OFF
SQL>

You can turn it on, test, feel can
SET the AUTOCOMMIT ON

CodePudding user response:

http://jingyan.baidu.com/article/ac6a9a5e66804d2b653eaca9.html for PL/SQL set up automatic submission