In SQL Server, if I need to add a new datetime column in my query to display the current time, I always do:
SELECT *, GETDATE() EXECUTION_TIME
FROM TABLE_1;
I know in PL/SQL we can do SELECT SYSDATE FROM DUAL;
I tried to do the following query:
SELECT *, SYSDATE EXECUTION_TIME
FROM TABLE_1;
but Oracle SQL returned:
ORA-00923: FROM keyword not found where expected
00923. 00000 - "FROM keyword not found where expected"
What's the correct syntax to do
SELECT *, GETDATE() EXECUTION_TIME
FROM TABLE_1;
in PL/SQL?