![]() ![]() ![]() Closed is a Date, Sleep is a Unix timestamp. Adjusting for 4 hours due to database update delay. The purpose of this query is to get all entries for a ticketing department, where the ticket status is changed to "closed" or "sleep" in the past day. Downloading and running SQL Developer on an ARM M1 Mac with Apple Silicon is not straightforward, at least as of this writing. This query still works despite the pink underline. Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. I noticed in Oracle SQL Dev, there is this spot underlined with pink, but I am not aware of any syntax error here (though it may be the culprit causing PBI to fail). My query works in Oracle SQL Developer, but in PBI I get an error "Details: "Oracle: ORA-00900: invalid SQL statement". To install and run Ensure you have a JDK installed, if not, download here (For 64-bit Intel Macs, download Java for Mac OS X 10.5, Update 1. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |