Re: Concatenating and copying columns data

Usman wrote:
> I have written the following trigger, I need to check if PROJ_ID
> column does not exists in table then skip the logic. How can I
> accomplish that? Oracle is throwing error at :new.PROJ_ID statement,
> if I remove PROJ_ID column from the table. Is there any other way to
> access PROJ_ID value from the new row?. Any help in this regard will
> be appreciated.

I would gladly answer this question except that you posted it to both the Oracle and SQL Server groups indicating that either you have no idea what product you are using or have some other issue.

Please clarify with version number.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org