How to update all records by inserting a character
I need To update all the records of my table by adding a space between two characters
For eg
id Name
1 category name -item name
2 category name -item name2
2 category name -item name3
This is how i stored the records
i want to update them all as
id Name
1 category name - item name
2 category name - item name2
2 category name - item name3
(Inserted a space between - and item name)
How can i update all records
Regards
Anees
Subject
Written By
Posted
How to update all records by inserting a character
March 09, 2009 02:46AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.