Re: Oracle-SQL Problem

Norazman,

    I think there may be a more direct solution to your problem. Since you are using Oracle Applications, there are some stored procedures/functions provided by Oracle to automatically fill these so-called 'WHO_COLUMNS' to which you are referring. The earlier two suggestions are quite correct if you were not using Oracle Apps, but it appears that you are. The 'CREATED_BY := user;' in a database trigger suggestion would always return the user APPS since APPS is the user running everything in the Oracle Applications environment.

    I would suggest looking in your Oracle Apps Developer manual for 'Who Columns' and see what you come up with. I hope this helps. Feel free to email me if you have any other questions.

Shane.

Arjan van Bentem wrote in message <6t3nkg$8i4$1_at_newton.a2000.nl>...
>>a)CREATION_DATE - Maybe I can default it to SYSDATE (am I correct?)
>
>Yes:
>
> create table my_table
> ( creation_date not null default sysdate
> :
> )
>
>>b)But how about the rest
>
>Already answered by Alex.
>
>Arjan.
>
>
Received on Thu Sep 10 1998 - 05:18:51 CEST