Skip to Main Content
Forums

SQL & PL/SQL

Announcement

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!

comparing Last create date with sysdate

User_R4VJDJun 9 2021 — edited Jun 9 2021

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

Comments

Arie Geller
Hello,

Please check if the following example, from Denes, can help you - http://apex.oracle.com/pls/otn/f?p=31517:117

Regards,
Arie.
Sam.K
Arie,

I checked that link out , but this is not really what I am looking for. I have created over 100 reports that has the export to excel link and they all work fine EXCEPT this particular report. I tried to compare the properties of this report with other reports and they look same!! I am interested in only knowing if this is possible and knowing the possible reasons behind that.

Thanks,
Arie Geller
Hello,

>> I checked that link out , but this is not really what I am looking for

The ‘No Data Found” issue, while exporting to CSV is not a new issue. Denes blogged about it, and in the example he also explain some pre conditions that can lead to this kind of problem. If you’ll search the forum you’ll find many threads on this problem.

If you created so many working reports in the past, and you can’t figure out the problem, you can appreciate the fact that it’s almost impossible to single out the only one that isn’t working, without seeing it at all. Can you recreate the report, with the problem on apex.oracle.com?

Regards,
Arie.
M Tajuddin
Hi Sam,
Does your query return any column in report region?
Is the table in the same schema?

If you have other reports working fine, it could be a little issue that causing trouble. Did you try eliminate the report and do fresh one again?

Thanks,

Tajuddin
http://tajuddin.whitepagesbd.com
1 - 4

Post Details

Added on Jun 9 2021
#plsql, #sqldeveloper
7 comments
799 views
2 mentions