Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Using dual to simulate a table
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.
--Received on Fri Jul 28 2006 - 08:02:21 CDT
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety." -- Benjamin Franklin