Why doesn't this simple lpad work?
823919Nov 1 2012 — edited Nov 1 2012Can someone answer why this doesn't work? Or why it doesn't lpad with the '0'?
SQL> ed
Wrote file afiedt.buf
DECLARE
id NUMBER := 454141;
BEGIN
DBMS_OUTPUT.PUT_LINE(id);
IF id > 1000000 THEN
DBMS_OUTPUT.PUT_LINE('Greater');
id := to_char(id);
id := lpad(id,8,'0');
DBMS_OUTPUT.PUT_LINE(id);
ELSIF id < 1000000 THEN
DBMS_OUTPUT.PUT_LINE('Less');
id := to_char(id);
id := lpad(id,7,'0');
DBMS_OUTPUT.PUT_LINE(id);
ELSE
DBMS_OUTPUT.PUT_LINE('None');
END IF;
END;
SQL> /
454141
Less
454141
PL/SQL procedure successfully completed.
Edited by: sdlasiter on Nov 1, 2012 7:00 AM