Where current of statement is not updating correct row oracle dating elvis
Thank you, Actually -- what you just demonstrated is that there is ONE sysdate function and its in SQL.declare x date := sysdate;begin ...really:declare x date;begin select sysdate into x from dual; ....
We must GOTO the database to get the sysdate, plsql doesn't have its "own" sysdate, it gets it from the database (same for USER as well). )and when we reference the current date in the code, we reference g_sysdate.
The WHERE clause specifies which record(s) that should be updated.Dropping an alias invalidates a prepared update statement if the latter statement uses the alias.