getdata oracle sql,SQL Server's GETDATE() equivalent in PL/SQL

Hi,335bbfa9-9108-48fb-aa4f-8366537dd6b8 wrote: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_TIMEFROM TABLE_1;I know in PL/SQL we can do SELECT SYSDATE FROM DUAL;I tried to do the following query:SELECT *, SYSDATE EXECUTION_TIMEFROM TABLE_1;but Oracle SQL returned:ORA-00923: FROM keyword not found where expected00923. 00000 - "FROM keyword not found where expected"...

When you say   SELECT  * ...   (with the * all alone) then there must not be anything else in the SELECT clause.  If you want anything else in the SELECT clause, then you must qualify the * with a table name or alias.  for example:SELECT  table_1.*,       SYSDATE  AS execution_timeFROM    table_1;