Re: Newbie Trigger question

Posted and mailed....

Clifford Buetikofer wrote:

> select OSuser from v$session into local_user; {where the local_user is
> a declared varchar2}
> but the SQL keeps choking when I try to create the trigger.

Try using SELECT OSuser INTO local_user FROM v$session;

> The second question is how can I format sysdate to include the time ?

SELECT to_char(sysdate, 'DD-MON-YYYY:HH:MI:SS') FROM dual;

Dean Received on Wed May 20 1998 - 12:47:04 CDT