Re: Using dual to simulate a table

In <44ca9719$0$4530$e4fe514c_at_news.xs4all.nl> "Robbert van der Hoorn" <removetheXinR.Xvanderhoorn_at_osait.nl> writes:

>"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?

Not certain if it's a serious question, but ..

I actually do control systems for an industrial plant. Primarily the power control systems. Oracle is bu a small part of what I'm responsible for.

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin