What are the SEQ$ and OBJ$ tables?
From: BEERYR <Ron.Beery_at_DaytonOH.ATTGIS.COM>
Date: 1996/06/24
Message-ID: <DtIovw.ItK_at_ranger.daytonoh.ncr.com>#1/1
Date: 1996/06/24
Message-ID: <DtIovw.ItK_at_ranger.daytonoh.ncr.com>#1/1
I'm running the Oracle Financials application 10.4.2 running
on Oracle 7.1.3.
In my stats of frequently run sql statements, the following
keep comming up. What is the seq$, obj$, and user$
tables? What are they used for?
update seq$
set increment$=:2,
minvalue=:3,
maxvalue=:4,
cycle=:5,
order$=:6,
cache=:7,
highwater=:8,
audit$=:9
where obj#=:1
select o.name, u.name
from obj$ o, user$ u
where obj# = :1 and o.owner# = u.user#
Ron Beery
NCR
"Everything is computerized. What could possibly go wrong?"
Received on Mon Jun 24 1996 - 00:00:00 CEST