Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Test - Delete me

RE: Test - Delete me

From: Naveen Nahata <naveen_nahata_at_mindtree.com>
Date: Thu, 20 Mar 2003 00:21:00 +0530
Message-Id: <24715.322416@fatcity.com>


This is a multi-part message in MIME format.

------_=_NextPart_001_01C2EE48.7BB3A2DF
Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

a small technical mistake :-)
=20

delete from "oracle-l" where subscriber =3D 'Gene Sais';=20

            ^
"-" is not allowed in identifiers ;-)
=20

Regards
Naveen

-----Original Message-----
From: Daniel W. Fink [mailto:optimaldba_at_yahoo.com] Sent: Wednesday, March 19, 2003 11:57 PM To: Multiple recipients of list ORACLE-L Subject: Re: Test - Delete me

delete from oracle-l where subscriber =3D 'Gene Sais'; commit;

select count(*) from oracle-l
where subscriber =3D 'Gene Sais';

  COUNT(*)


         0

--=20

Daniel W. Fink

http://www.optimaldba.com

IOUG-A Live! April 27 - May 1, 2003 Orlando, FL

   Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL

   Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals

Gene Sais wrote:

DISCLAIMER:
This message (including attachment if any) is confidential and may be = privileged. Before opening attachments please check them for viruses and = defects. MindTree Consulting Private Limited (MindTree) will not be = responsible for any viruses or defects or any forwarded attachments = emanating either from within MindTree or outside. If you have received = this message by mistake please notify the sender by return e-mail and = delete this message from your system. Any unauthorized use or = dissemination of this message in whole or in part is strictly = prohibited. Please note that e-mails are susceptible to change and = MindTree shall not be liable for any improper, untimely or incomplete = transmission.

------_=_NextPart_001_01C2EE48.7BB3A2DF
Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE></TITLE>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3D"Courier New" size=3D2><SPAN=20
class=3D600124918-19032003>a small technical mistake = :-)</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff><SPAN=20
class=3D600124918-19032003></SPAN></FONT>&nbsp;</DIV> <DIV><SPAN class=3D600124918-19032003><TT><FONT color=3D#0000ff = size=3D2>delete from=20
"oracle-l" where subscriber =3D 'Gene Sais'; </FONT></TT></SPAN></DIV> <DIV><SPAN class=3D600124918-19032003><TT><FONT color=3D#0000ff=20 size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs= p;=20
^</FONT></TT></SPAN></DIV>
<DIV><SPAN class=3D600124918-19032003><TT><FONT color=3D#0000ff = size=3D2>"-" is not=20
allowed in identifiers ;-)</FONT></TT></SPAN></DIV> <DIV><SPAN class=3D600124918-19032003><TT><FONT color=3D#0000ff=20 size=3D2></FONT></TT></SPAN>&nbsp;</DIV> <DIV><SPAN class=3D600124918-19032003><TT><FONT color=3D#0000ff=20 size=3D2>Regards</FONT></TT></SPAN></DIV> <DIV><SPAN class=3D600124918-19032003><TT><FONT color=3D#0000ff=20 size=3D2>Naveen<BR></DIV></FONT></TT></SPAN> <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">   <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> Daniel W. Fink=20   [mailto:optimaldba_at_yahoo.com]<BR><B>Sent:</B> Wednesday, March 19, = 2003 11:57=20
  PM<BR><B>To:</B> Multiple recipients of list = ORACLE-L<BR><B>Subject:</B> Re:=20
  Test - Delete me<BR><BR></DIV></FONT><TT>delete from oracle-l where = subscriber=20
  =3D 'Gene Sais';<BR>commit;<BR><BR>select count(*) from = oracle-l<BR>where=20
  subscriber =3D 'Gene Sais';<BR><BR>&nbsp;=20   =
COUNT(*)<BR>----------<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ;=20
  0</TT><BR><BR><PRE class=3Dmoz-signature cols=3D"$mailwrapcol">--=20 Daniel W. Fink
<A class=3Dmoz-txt-link-freetext =
href=3D"http://www.optimaldba.com">http://www.optimaldba.com</A>

IOUG-A Live! April 27 - May 1, 2003 Orlando, FL

   Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL    Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo = Internals</PRE><BR>Gene=20
  Sais wrote:<BR>
  <BLOCKQUOTE cite=3D"midF001.0056D8E2.20030319085421_at_fatcity.com" = type=3D"cite">

    <META content=3D"MSHTML 6.00.2600.0" = name=3DGENERATOR><BR><BR></BLOCKQUOTE><BR><PRE class=3Dmoz-signature = cols=3D"$mailwrapcol"></PRE></BLOCKQUOTE><p></p><p>DISCLAIMER:<br>This = message (including attachment if any) is confidential and may be = privileged. Before opening attachments please check them for viruses and = defects. MindTree Consulting Private Limited (MindTree) will not be = responsible for any viruses or defects or any forwarded attachments = emanating either from within MindTree or outside. If you have received = this message by mistake please notify the sender by return e-mail and = delete this message from your system. Any unauthorized use or = dissemination of this message in whole or in part is strictly = prohibited. Please note that e-mails are susceptible to change and = MindTree shall not be liable for any improper, untimely or incomplete = Received on Wed Mar 19 2003 - 12:51:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US