Re: Concatenating and copying columns data

Usman wrote:
> 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

So far just about everything you've written makes no sense. If I had a 10.1.0.2 database the first thing I'd do is apply the patch sets that have been out for years.

But given your question ...

SELECT 1
INTO x
FROM all_tab_columns
WHERE owner = ?
AND table_name = ?
AND column_name = ?;

IF x = 1 THEN

-- 
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