Answer Posted / sohini
A transaction is a series of SQL data manipulation
statements that does a logical unit of work.DML statements
run between explicit COMMIT,ROLLBACK or when database is
connected or disconnected form a transaction.DDL, DCL and
TCL statements issue autocommit hence they do not form
transaction.Also when one transaction ends another one
starts.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is the usage of merge statement?
How to rename an index in oracle?
Describe the types of sub query?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is meant by a deadlock situation?
what is the use of system.effective.date variable in oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
how to do daily transactions with out sql* loader control file regesterd in apps?
What is the difference between truncate & delete command?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is BBED in Oracle?
What is SQL access advisor in Oracle?
What are internal user account in oracle?
can u plz provide me oca sql dumps please i need them
Is postgres faster than oracle?