Empno has number data type, not null. MRG_NAME has number data type.
I changed this:
ALTER TABLE EMP RENAME COLUMN MGR TO MGR_NAME;
SELECT empno, ename, hiredate, mgr_name(empno)
I want MGR_Name to display with empno.
Return, I got "MGR_NAME" invalid identifier.
Any advice is appreciated?