If you just wanted to remove the leading spaces then just use the trim function:
SQL> INSERT INTO DEPARTMENT VALUES (' IT DEPARTMENT - ');

1 row created.

SQL> INSERT INTO DEPARTMENT VALUES (' FINANCE DEPARTMENT OR IT');

1 row created.

SQL> INSERT INTO DEPARTMENT VALUES (' MANUFACTURING DEPT ');

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SELECT TRIM(COL1) FROM DEPARTMENT;

TRIM(COL1)
------------------------------------------------------------
IT DEPARTMENT -
FINANCE DEPARTMENT OR IT
MANUFACTURING DEPT



Badrinath