Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Urgent!, update oracle table

Robert_73
Occasional Advisor

Urgent!, update oracle table

Hi list,
I can select the data and trim it using the select statements

select ltrim(url,'"') from docpar
select datetime,substr(url,1,32) url,company,username from docpar

but I want to update it, how do I update?. I tried


update docpar
set url = replace(url,'"', ltrim(url,'"'))

update docpar
set url = substr(url,1,32)
Both does not work.
UNIXDUDE
2 REPLIES
Yogeeraj_1
Honored Contributor

Re: Urgent!, update oracle table

hi robert,
-
to make thing easier, can you please:
a. post the error you are getting
b. confirm whether you are the owner of the table being updated.
-
revert
-
regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Hari Kumar
Trusted Contributor

Re: Urgent!, update oracle table

Can you please post the Errors ??
These are the general errors when Object locked--------------

"ORA-00054: resource busy and acquire with NOWAIT specified"
Occurs when you attempt to lock NOWAIT and the resource is already locked.
"ORA-00060 deadlock detected while waiting for resource"

The rule is that primary keys must be preserved during the transaction.
You may be referencing a Foriegn and check the Primary key and the constraints of the
table.


Information is Wealth ; Knowledge is Power