RETURN VARCHAR2 AS RETURN CASE WHEN SELF.raison_sociale_emetteur IS NULL THEN lpad(' ', 35,get_num_siret RETURN VARCHAR2 AS RETURN CASE WHEN SELF.num_siret IS NULL THEN lpad(' ', 14,VARCHAR2 AS RETURN CASE WHEN SELF.ref_remise IS NULL THE
我正在尝试编写一条使用LPAD和RPAD命令生成“Oracle$Internet$学院”的语句。这就是我到目前为止所得到的,但是我得到了一个缺少右括号的错误。SELECT LPAD(RPAD('Oracle', 10,'$$$')RPAD('Internet',24,'$$$'))
FROM dual;