Try replacing the string literal for date '1989-12-09'
with TO_DATE('1989-12-09','YYYY-MM-DD')
More Related Contents:
- Best way to do multi-row insert in Oracle?
- “column not allowed here” error in INSERT statement
- The most efficient way to UPPER CASE two columns in a single query [closed]
- ORA-01843 Not a valid month
- Merging two tables in SQL [closed]
- I want to search job and salary from employee table but I am getting error like invalid relational operator [closed]
- Inner join vs Where
- How do I do top 1 in Oracle? [duplicate]
- Insert data in 3 tables at a time using Postgres
- How to declare variable and use it in the same Oracle SQL script?
- How to find the employee with the second highest salary?
- Are a CASE statement and a DECODE equivalent?
- How can you tell if a value is not numeric in Oracle?
- Select a random sample of results from a query result
- SQL error “ORA-01722: invalid number”
- Get month name from date in Oracle
- OVER clause in Oracle
- SQL Error: ORA-00942 table or view does not exist
- How to count the number of occurrences of a character in an Oracle varchar value?
- PARTITION BY with and without KEEP in Oracle
- How to return multiple rows from the stored procedure? (Oracle PL/SQL)
- How to extract week number in sql
- How to use Timestamp_to_scn and Scn_to_timestamp in Oracle?
- In Oracle, is it possible to INSERT or UPDATE a record through a view?
- Return number from Oracle Select statement after parsing date
- How do you interpret a query’s explain plan?
- ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)
- How to call Oracle MD5 hash function?
- SQL Server equivalent of WM_CONCAT function [duplicate]
- Oracle: ‘= ANY()’ vs. ‘IN ()’