Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> unlock table/row

unlock table/row

From: <hpcheong_at_ncs.com.sg>
Date: Tue, 10 Nov 1998 09:33:01 GMT
Message-ID: <72918d$19d$1@nnrp1.dejanews.com>


hi all,

i understand that there are two types of locks provided by Oracle:

1)table level locking
2)row level locking

But can anyone tell me how should i unlock the lock i have issue to table/row? is it true that these locks will stay until an unlock command is issue or the lock will stay until the end of the session.

question 2

can anyone verify the following syntax is correct?

			                            optional
    				                 |

SQL> alter table <table_name> drop primary key {cascade};

and

                    				                optional
					                     |

SQL> alter table <table_name> drop constraint PK_TB_APP {cascade};

see if cascade option is issue correctly?

thanks in advance!

evelyn.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Nov 10 1998 - 03:33:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US