Re: Using dual to simulate a table

"Stan Brown" <stanb_at_panix.com> wrote in message news:eadkeg$m2p$1_at_reader2.panix.com...
> In <796kc2hnhbttfdmmoqmnehjf638e9ldtdh_at_4ax.com> Sybrand Bakker
<postbus_at_sybrandb.demon.nl> writes:
>
> >On Fri, 28 Jul 2006 13:02:21 +0000 (UTC), Stan Brown <stanb_at_panix.com>
> >wrote:
>
> >>I have a really old piece of (binary only) code that makes a call like
> >>"select tstamp from tstamp where tstamp = 123456". I've always
maintained a
> >>table with a continuous sequence of numbers for this app but I would
like
> >>to be able to stop doing this.
> >>
> >>Isn't there a way I can create a view by the name tstamp that queries
dual?
> >>or a sequence, somehow. The query always contains the desired answer.
> >>
> >>This is on version 7 BTW.
>
> >Just of out curiosity, why do you stick to a version which predates
> >the Neanderthaler?
> >I would say it wouldn't matter what you do, because you are on your
> >own anyway.
>
> Well, basicly because I'm under the impression that the (equally old)
> application that uses it probably can't connect to a newer version. I'd be
> willing to be corrected on that. And also the app won't run on any HP-UX
> version newer than 10.20, I suspect that limits my options on Oracl, no?
Of
> course _I could_ build a nice new (say) Linux Oracle abckend machine.
>
> But management _really_ does not want to spend money on this system :-(
>
> >But woe, when you loose your job, and have to catch up with Oracle 9i
> >(soon to be replaced) or 10g.
>
> Fortunately (in this context) Oracle s not my day job :-

Night job then?

>
> No sugestions as to the orignal question?
>
>
> >--
> >Sybrand Bakker, Senior Oracle DBA
> --
> "They that would give up essential liberty for temporary safety deserve
> neither liberty nor safety."
> -- Benjamin Franklin
Received on Fri Jul 28 2006 - 17:55:24 CDT