Thanks for answer me.
The problem that I have is the next, I have to calculate from
a item transaction table the stock on hand to determinate date, (to made
different reports).
To do this I made the next query:
SELECT DISTINCT ITEM, SOH_QTY, UPDATE_DATE,
UPDATE_TIMEFROM ICTRANS
b1WHERE
Title: Message
Short answer is
no.
Long answer is "no, you cannot,
but you can use application contexts and virtual private database to do
something very similar."
--Mladen GogalaOracle DBA
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
I got the first part of the query, sum of entrace an exit per
item, and the initial inventary that I will use has stock on hand in case we
don't have transactionsmade onthe initial date on the rango or
later.
SELECT ICTRANS.COMPANY,
ICTRANS.LOCATION, ICTRANS.ITEM, ITEMMAST.INVEN_MAJCL,
At 02:45 PM 1/7/2003 -0800, Hamid Alavi wrote:
List,
Oracle8i support insert/updatable view or
NOT?
From Oracle's Metalink:
you can update a multiple base table view from 7.3.x
onwards, provided columns you are updating are not primary keys for these
tables.
Yo,
Oracle 7.2 supported updatable views. Some restrictions have been lifted
in later versions, others NOT.
Mogens
Hamid Alavi wrote:
List,
Oracle8i support insert/updatable view or NOT?
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095
===
USE INSTEAD OF TRIGGERS .
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 07, 2003 2:45 PM
List,
Oracle8i support insert/updatable view or NOT?
Hamid Alavi
Office : 818-737-0526
Cell phone : 818-416-5095