* Dragos Madalin Popa
I am trying to run this update statement, but I got an error syntax...near
offsetCould You please point out what is wrong?
Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where
ABBREVIATION is null;
Use the CONCAT function:
URL:
Dragos,
Monday, October 07, 2002, 7:30:47 PM, you wrote:
DMP I am trying to run this update statement, but I got an error syntax...near
DMP offsetCould You please point out what is wrong?
DMP Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where
DMP ABBREVIATION is null;
sql,query
Hi,
I am trying to run this update statement, but I got an error syntax...near
offsetCould You please point out what is wrong?
Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where
ABBREVIATION is null;
Thank You,
Best Regards,
Madalin.