@scotty_walker
You can remove specific initial characters from a column in Oracle by using the SUBSTR function along with a CASE statement. Here's an example of how you can achieve this:
1 2 3 4 5 6 |
UPDATE your_table SET your_column = CASE WHEN SUBSTR(your_column, 1, 3) = 'ABC' THEN SUBSTR(your_column, 4) WHEN SUBSTR(your_column, 1, 2) = 'XY' THEN SUBSTR(your_column, 3) ELSE your_column END; |
In this example:
Make sure to backup your data before running the update statement to avoid any potential data loss.