Why is the GETDATE() an invalid identifier

by

I think you want SYSDATE, not GETDATE(). Try it:

UPDATE TableName SET LastModifiedDate = (SELECT SYSDATE FROM DUAL);

More Related Contents:

  1. Oracle trigger after insert or delete
  2. Split function in oracle to comma separated values with automatic sequence
  3. Auto-increment in Oracle without using a trigger
  4. HIbernate issue with Oracle Trigger for generating id from a sequence
  5. Trigger to enforce M-M relationship
  6. ORA-04091: table [blah] is mutating, trigger/function may not see it
  7. How to call an Oracle function with a Ref Cursor as Out-parameter from C#?
  8. Printing the value of a variable in SQL Developer
  9. Oracle Equivalent to MySQL INSERT IGNORE?
  10. null vs empty string in Oracle [duplicate]
  11. Convert comma separated string to array in PL/SQL
  12. UTL_FILE.FOPEN() procedure not accepting path for directory?
  13. Oracle stored procedure with parameters for IN clause
  14. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  15. Formatting DATE in oracle
  16. Oracle: How to find out if there is a transaction pending?
  17. check if “it’s a number” function in Oracle
  18. Sql*plus always returns exit code 0?
  19. SQL*Plus how to accept text variable from prompt?
  20. How to find difference b/w TIMESTAMP format values in Oracle?
  21. if (select count(column) from table) > 0 then
  22. NLS_LANG setting for JDBC thin driver?
  23. How can I describe a table in Oracle without using the DESCRIBE command?
  24. Get the LENGTH of a LONG RAW
  25. Reading clob line by line with pl\sql
  26. Oracle: Days between two date and Exclude weekdays how to handle negative numbers
  27. merge update oracle unable to get a stable set of rows
  28. How to get the week day name from a date?
  29. DBMS_JOB vs DBMS_SCHEDULER
  30. How to change default nls_date_format for oracle jdbc client

Leave a Comment