title: how to create deadlock situation in the oracle on a table which is having simple 4 columns(sno,name,job,dept)?
body: <p>i wanted to create a deadlock situation in the oracle table which will not give response and will be hang on executing the same query from the java application ?Could you please provide one sample query which makes this situation on a table (having 4 columns sno,name,job,dept ) .</p>