Hi
I have a column varchar2(100) in a table.
Some rows have data, some just null
I need to update the table so if this col A is null then the column A should be update to contain 100 spaces.
This should also happen on the insert of a new rows
I think I should be using rpad but what I have done does not seem to have worked
update AAA
set COLA = rpad(' ', 100)
where colA is null;
Any advice please
Gus