Re: Difficult query problem

On Sat, 5 Aug 2006 08:40:40 -0400, "DFS" <nospam_at_dfs_.com> wrote:

>Thanks
>
>
>What's an Oracle version?

I'm not sure why using Microsoft products has such a detrimental effect on the human brain. It seems once people are exposed to Microsoft products they stop being capable to think.

Your Visual Basic has a version, hasn't it? So Oracle must have a version too, wouldn't you think?
So why don't you post it? simply run select * from v$version from sql*plus.

I would also advise to
- to put up your code somewhere on a website.   You are wasting lots of bandwith right now - to make sure your statements will actually run in Oracle. Right now they don't because you are using a Microsoft VB specific date format. Do you really think anyone is going to edit your code? Please make sure dates are in the format dd-mon-yyyy or at least replace the stupid # by a single quote.

--
Sybrand Bakker, Senior Oracle DBA