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...
koryknick's avatar
koryknick
Employee
5 years ago

Can you provide more context around what you are trying to do? Do you need to perform multiple statements in the execute and this is just the first one? Or do you need the current timestamp in the pipeline?