Search results for query: *

Ok - it works! [thumbsup] Actually, we're using Business Objects [sad] as a reporting tool to access an Oracle 8.17 db so the final code is somewhat different. I've created an object in Business Objects with the following & it works like a charm: @Select(Actual Ship Date) BETWEEN...

By the way we use MS Access on Win2K to connect to an Oracle 8.1.7 db... Seems obvious to me but make sure you make the odbc changes to the client machine!

You do not need to install the Oracle to create the odbc connection to link an Oracle db to MS Access. You can use the Microsoft odbc driver for Oracle. In Windows 2000 this is under control panel-administrative tools-data sources(odbc). You can download updated drivers from Microsoft by going...

I just discovered this link yesterday & it's great as far as I'm concerned. Instead of having to weed through all of the documentation for each Oracle manual this Oracle site includes a Master Index of all terms in all manuals which then links you to the manual/section which contains exactly...

I need to calculate the current month so I can include this in some canned reports we have. What I need is all of the "current month", where it will automatically know how many days are in the month and if it's a leap year etc.? Also I don't want to have to update the date always...

Not exactly your answer...but seems to be similar... We run a canned report for a "rolling" last 7 days using trunc(sysdate)-7 as the earliest date and trunc(sysdate) as the latest date. Sysdate is the system date selected from the "default" dual table that comes with...

How do you save a ® (registered trademark) symbol in an Oracle 8.1.7 db?

We have an Oracle db that has dates stored with the hours, minutes & seconds. I've created a date query that will allow users to run a query on a date range by entering a begin date and an end date. The query runs but the resulting data is not 100% accurate unless I explicitly enter the ending...