How do I create a table MANAGER ( EMP#, MANAGER) where MANAGER is a foreign key which references to EMP# in the same table?

Give the exact DDL

First CREATE MANAGER table with EMP# as the primary key Then ALTER it to define the foreign key.