Re: Newbee Question on table columns

From: <James>
Date: 1995/05/04
Message-ID: <1995May4.112056.558_at_newton.ccs.tuns.ca>#1/1


In article <3o7ol2$b20_at_solaris.cc.vt.edu> bagley <bagley_at_vt.edu> writes:
>Is there a way within an Oracle table to keep a column, once it has a
>value in it, from being changed agained?
>thanks in advance.
>
>Victor Bagley bagley_at_vt.edu
>Virginia Tech Computing Center (703) 231-8818
>1700 Pratt DR.
>Blacksburg VA. 24060

Well...
I wouldn't give access of SQL*Plus to users. My users have to use SQL*Forms (Runform). In the form, if there is a field/column I don't want updated, I disable the UPDATE ALLOWED for that field/column.

Does this help?

James Richard (JRICHARD_at_TUNS.CA)
"No Assembler Required!" Received on Thu May 04 1995 - 00:00:00 CEST

Original text of this message