Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

Urgent!, update oracle table

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.
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.
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

Information is Wealth ; Knowledge is Power