Answer Posted / shanmugavelu
row level and table level locks,
dont try share update lock its failure in table lelvel ..
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the attributes of the cursor?
How to get a create statement for an existing table?
What are a query and state the different types of queries and their uses?
How to check the oracle tns settings?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What is the recommended interval at which to run statspack snapshots, and why?
What is the relation of a user account and a schema?
What is difference between truncate and delete?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to write a query with a right outer join in oracle?
How to get maxsal , minsal, ename department wise in single query
What is a read write transaction in oracle?
Explain the difference between a procedure and a function?
What are the types of trigger in oracle?
How to start instance with a minimal initialization parameter file?