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
How to drop a stored function?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
How to start your 10g xe server from command line?
What is a database schema in oracle?
What is a subquery?
How to save query output to a local file?
How to create a stored program unit?
How to use select statement to count the number of rows in oracle?
What is oracle rowcount?
What is difference between truncate and delete?
what's query optimization and without use of IN AND Exist can we get another way data from query
What are the different types of record groups in oracle? Explain each of them
What is the data pump export utility?
How to name query output columns in oracle?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)