Forum Discussion

yes1819's avatar
yes1819
New Contributor III
5 years ago

Oracle SQL Declare a column and select today's date into the column

Hi I need to put today’s date in a column called “P_SNAP_DATE” Oracle stored procedure Execute Immediate ‘select sysdate from dual’ into P_SNAP_DATE was working fine in the Oracle. When I p...
yes1819's avatar
yes1819
New Contributor III
5 years ago

I want to do exact same thing that Oracle PL/SQL does.

In the Oracle, I created Stored Procedure, that’s like below.

This will be the only statement in this snap