Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> insert into statement
HI all
Right I have created a table stats based on v$session with a few selected columns ie username, terminal, sid and so on. I have a script that inserts into my table stats every half an hour from the v$session, the table has no primary key as yet. If I have a user connected for longer than half an hour he will be entered twice making my stats incorrect. What I want is some sort of validation to check the table before entering the data. Any light on my problem would be great
Thanks in advance Received on Tue Sep 25 2001 - 08:20:19 CDT