Re: Concatenating and copying columns data

Hi Daniel,

Product that I am working on supports both Oracle and SQL Server databases as a data storage repository. I mistakenly posted SQL server source on Oracle mailing list. I need to support Oracle 10g (10.1.0.2.0).

Thanks,
Usman

On Apr 11, 8:07 pm, DA Morgan <damor..._at_psoug.org> wrote:
> 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
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Received on Thu Apr 12 2007 - 02:07:04 CDT