Please OPEN NEW subject if you start discussing new topic!!
Your question has nothing in common with:
"How do I check to see who is logged into the database"
KAzi
Akonji Robert wrote:
> How can one find out, when a table was last updated or when was the last
> time an insert was done on that table.
>
> Thanks
>
>
> Robert A. Akonji
> Sr. Oracle DBA
> Brightpoint Inc.
> Plainfield, Indiana
> 46168 USA
> Tel: 317 707 2318
> Fax: 317 707 2397
> Cell: 317 509 0497
>
>
> -----Original Message-----
> From: Manash Baruah
> [mailto:oracledba-ezmlmshield-x31566651.[Email address protected]
> Sent: Thursday, February 28, 2008 11:55 AM
> To: LazyDBA Discussion
> Subject: RE: How do I check to see who is logged into the database
>
>
>
> Abhijeet,
>
> There are three ways as far as I recall:
>
> 1. Use the DELETE method of the recordset object you have created for
> the table
> 2. Use the ConnectionObject.Execute "DELETE FROM TABLE_NAME"
> 3. Use the Delete method of the DATA control Active-X control (if) you
> are using.
>
> Thanks & Regards,
>
> Manash Partim Baruah
> MS-LCS| DBA| Tech Mahindra Ltd.
> Sharda Center, 6th Floor Annex Building, Pune-4, India
> www.techmahindra.com
>
>
> -----Original Message-----
> From: Abhijeet Bhurke [mailto:abhijeet-[Email address protected]
> Sent: Thursday, February 28, 2008 12:39 PM
> To: Manash Baruah
> Subject: RE: How do I check to see who is logged into the database
>
> **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email, **and removed
> any attachments, and kept your email address secret **from this person,
> and any viruses/trojans.
> **If you reply to this email, the person will see your email address as
> normal **Anything below this line is the original email text
>
>
> Dear All,
>
> Please help me.
>
> I want to delete data from some table in Oracle 10G. I am using VB 6.0
> front end & oracle as backend.
>
> What script should I write.
>
> Please mail.
>
>
>
> Thanks & regards,
> Abhijeet Bhurke
> MIS
>
> Ph: 07292-255021 Ext. 129
> Mob: (0)9826781621
> -----Original Message-----
> From: Manash Baruah
> [Email address protected]
> Sent: Monday, February 25, 2008 9:46 PM
> To: LazyDBA Discussion
> Subject: RE: How do I check to see who is logged into the database
>
>
> This will help:
>
> SELECT
> SID,SERIAL#,USERNAME,STATUS,OSUSER,MACHINE,PROGRAM
> FROM v$session WHERE TYPE='USER' ;
>
>
> Thanks & Regards,
>
> Manash Partim Baruah
> MS-LCS| DBA| Tech Mahindra Ltd.
> Sharda Center, 6th Floor Annex Building, Pune-4, India
> www.techmahindra.com
>
>
> -----Original Message-----
> From: Sikyala Raquel [USA]
> [mailto:oracledba-ezmlmshield-x84228228.[Email address protected]
> Sent: Monday, February 25, 2008 9:38 PM
> To: LazyDBA Discussion
> Subject: How do I check to see who is logged into the database
>
> What is the syntax I would use to check to see if there is anyone logged
> into the database?
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
> dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
> ========================================================================
> ====
> ================================================
>
>
> Disclaimer:
>
> This message and the information contained herein is proprietary and
> confidential and subject to the Tech Mahindra policy statement, you may
> review the policy at <a
> href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahind
> ra.c
> om/Disclaimer.html</a> externally and <a
> href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
> ra.c
> om/Disclaimer.html</a> internally within Tech Mahindra.
>
> ========================================================================
> ====
> ================================================
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
>
>
> ========================================================================
> ====================================================
>
>
> Disclaimer:
>
> This message and the information contained herein is proprietary and
> confidential and subject to the Tech Mahindra policy statement, you may
> review the policy at <a
> href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahind
> ra.com/Disclaimer.html</a> externally and <a
> href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
> ra.com/Disclaimer.html</a> internally within Tech Mahindra.
>
> ========================================================================
> ====================================================
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
Oracle LazyDBA home page