cancel
Showing results for 
Search instead for 
Did you mean: 

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

yes1819
New Contributor III

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 put that sql into Oracle-Execute snap, it gave me below error message.
Can anyone help me on this?
Thank you

image

5 REPLIES 5

koryknick
Employee
Employee

Very welcome. Glad it is what you need!