DECLARE yyyymmdd VARCHAR2(8) := ‘&&yyyymmdd’; –
BEGIN
…
END;
1st line is flagged as having an error “string initializer is too long”. It’s not really an error, unless you run it as a script with SET DEFINE OFF.
I can certainly continue to ignore the error indicator, but thought I’d mention it, since it did surprise me the 1st time I saw it.