For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Create date Null
select * from table1 where create date < TRUNC(SYDATE) Requirement : I have check create date should be less than sysdate. if column is NULL, how to perform
This really has nothing to do with SQL Developer (the subject of this forum). It is a much better fit in SQL & PL/SQL. And just as a side comment, storing 'age' as data is a flawed design. The 'age' of everyone and every thing is increasing by the day, if not by the second. What is your plan to keep 'age' current? Better to store 'date of birth' and the calculate 'age' when needed at run-time.
The 'age' of everyone and every thing is increasing by the day, if not by the second. Sometimes the age stops increasing.
Pour me one! Of course, that's not actually the age, but the amount of time it was 'aged' in the barrel before bottling.