Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Using dual to simulate a table

Using dual to simulate a table

From: Stan Brown <stanb_at_panix.com>
Date: Fri, 28 Jul 2006 13:02:21 +0000 (UTC)
Message-ID: <ead1st$o15$1@reader2.panix.com>


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.

-- 

"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety." -- Benjamin Franklin
Received on Fri Jul 28 2006 - 08:02:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US