如何删除plsql中的前导空格

LTRIM(string)

CREATE TABLE employees (
    id NUMBER,
    department VARCHAR2(50)
);

INSERT INTO employees (id, department) VALUES (1, '  Sales');
INSERT INTO employees (id, department) VALUES (2, 'Marketing');
INSERT INTO employees (id, department) VALUES (3, '  HR');

COMMIT;

SELECT id, LTRIM(department) AS trimmed_department
FROM employees;

ID  TRIMMED_DEPARTMENT
--  -------------------
1   Sales
2   Marketing
3   HR