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.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.

============================================================================================================================

Oracle LazyDBA home page