in Technology by

What is the usage of Save Points in Oracle database?

1 Answer

0 votes
by

Save Points are used to divide a transaction into smaller phases. It enables rolling back part of a transaction. There are maximum 5 save points allowed in Oracle Database. Whenever an error is encountered, it is possible to rollback from the point where the SAVEPOINT has been saved.

Related questions

0 votes
    What is save point in Oracle database?...
asked Dec 18, 2020 in Technology by JackTerrance
0 votes
    What is the usage of control file in Oracle?...
asked Dec 18, 2020 in Technology by JackTerrance
0 votes
    What is the usage of ANALYZE command in Oracle?...
asked Dec 18, 2020 in Technology by JackTerrance
0 votes
    The git repo for my Django app includes several .tsv files which contain the initial entries to populate my ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 20, 2022 in Education by JackTerrance
0 votes
    How to convert a string to a date in Oracle database?...
asked Dec 18, 2020 in Technology by JackTerrance
0 votes
    What are the various Oracle database objects?...
asked Dec 18, 2020 in Technology by JackTerrance
0 votes
    What is a snapshot in Oracle database?...
asked Dec 17, 2020 in Technology by JackTerrance
0 votes
    What are the components of logical database structure in Oracle database?...
asked Dec 17, 2020 in Technology by JackTerrance
0 votes
    What are the components of physical database structure of Oracle database?...
asked Dec 17, 2020 in Technology by JackTerrance
0 votes
    I am looking for a free tool to load Excel data sheet into an Oracle database. I tried the Oracle ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 22, 2022 in Education by JackTerrance
0 votes
    Question Can I build a image database/library that has an e-commerce style checkout system and a powerful ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 19, 2022 in Education by JackTerrance
0 votes
    I am looking for a free tool to load Excel data sheet into an Oracle database. I tried the Oracle ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 19, 2022 in Education by JackTerrance
0 votes
    Question Can I build a image database/library that has an e-commerce style checkout system and a powerful ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 19, 2022 in Education by JackTerrance
0 votes
    Question Can I build a image database/library that has an e-commerce style checkout system and a powerful ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 19, 2022 in Education by JackTerrance
0 votes
    Each tablespace in an Oracle database consists of one or more files called (a) Files (b) name space ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
...