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's query optimization and without use of IN AND Exist can we get another way data from query
Explain self joins in oracle?
How to end the current transaction in oracle?
Compare and contrast between sql and sql server and explain its various functions?
What is the data pump import utility?
How to define a record variable to store a table row?
How to rename a tablespace in oracle?
What are temporal data types in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Please explain joins in oracle?
How to assign a table row to a record variable?
What is snapshot is too old? Give and example for better understand.
How to pass a parameter to a cursor in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
