Oracle equivalent to SQL Server DATEPART

 SELECT to_number(to_char(sysdate, 'HH24')) FROM DUAL

An alternative is the EXTRACT function which is an ANSI standard and also works on other DBMS, but it also requires the use of current_timestamp (also ANSI) instead of sysdate

SELECT extract(hour from current_timestamp) 
FROM dual