Hi lists
i need help in writing a sql query:
i am trying to capture the session information from v$session and
inserting the same into someother table xyz with columns username,
logon_time. (scott logged in at 10:30 hrs)
i put this script in cron. it runs every 30 minutes. but i need the
)To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
Shrinivas.Tatireddy@m cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
ed.ge.com Subject: avoid duplicate sql
Can you change from a sql statement to an anonymous
pl/sql block? You can trap for dup val on index or
check for the records existence prior to trying to
insert the new record.
james
--- Tatireddy, Shrinivas (MED, Keane)
[EMAIL PROTECTED] wrote:
Hi lists
i need help in writing a sql query:
]
Date: 2001/08/08 Wed AM 09:15:26 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: avoid duplicate sql
Hi lists
i need help in writing a sql query:
i am trying to capture the session information from v$session and
inserting the same into someother table xyz
, 2001 9:15 AM
To: Multiple recipients of list ORACLE-L
Subject: avoid duplicate sql
Hi lists
i need help in writing a sql query:
i am trying to capture the session information from v$session and
inserting the same into someother table xyz with columns username,
logon_time. (scott logged
]
Tatireddy, Shrinivas (MED, Bilgisine:
Keane)Konu:
[EMAIL PROTECTED] avoid duplicate sql