What is Read-Only Transaction ?
Answers were Sorted based on User's Feedback
Answer / guest
A Read-Only transaction ensures that the results of each query
executed in the transaction are consistent with respect to
the same point in time.
| Is This Answer Correct ? | 2 Yes | 0 No |
A Read_only transaction is one type of transaction which
ensures that all the execution query results that are
performed in this transaction will be remain consistent as
it allows only read priviledges to the users in order to
keep data secure in database.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishi
A Read-Only transaction ensures that the results of each query executed in the transaction are consistant with respect to the same point in time.
| Is This Answer Correct ? | 0 Yes | 0 No |
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
What does a Control file Contain ?
How to rollback the current transaction in oracle?
When a form is invoked with call_form, Does oracle forms issues a save point ?
Explain what are synonyms used for?
How to execute a stored procedure in oracle?
What is forall Statement ?
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
What privilege is needed for a user to query tables in another schema?
Explain the use of log option in exp command.
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is meant by recursive hints ?