FAQ
This is a MIME message. If you are reading this text, you may want to
consider changing to a mail reader or gateway that understands how to
properly handle MIME multipart messages.

--=_DD829653.7918F6D9
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit



--=_DD829653.7918F6D9

Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
Content-Description: HTML

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

&nbsp;

--=_DD829653.7918F6D9--

Search Discussions

  • Naveen Nahata at Mar 19, 2003 at 6:51 pm
    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
    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(*)



    --=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">

    charset=3Diso-8859-1">

    class=3D600124918-19032003>a small technical mistake =
    :-)
    &nbsp;
    delete from=20
    "oracle-l" where subscriber =3D 'Gene Sais';
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
    p;=20
    ^
    "-" is not=20
    allowed in identifiers;-)
    &nbsp;
    Regards
    Naveen

    -----Original Message-----From: Daniel W. Fink=20
    Sent: Wednesday, March 19, =
    2003 11:57=20
    PMTo: Multiple recipients of list =
    ORACLE-LSubject: Re:=20
    Test - Delete medelete from oracle-l where =
    subscriber=20
    =3D 'Gene Sais';commit;select count(*) from =
    oracle-lwhere=20
    subscriber =3D 'Gene Sais';&nbsp;=20
    =
    COUNT(*)----------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=;=20
    0--=20
    Daniel W. Fink
    http://www.optimaldba.com" rel="nofollow">http://www.optimaldba.com">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 =
    InternalsGene=20
    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 =
  • Daniel W. Fink at Mar 19, 2003 at 7:23 pm
    --------------030004050507010909090506
    Content-Type: text/plain; charset=us-ascii; format=flowed
    Content-Transfer-Encoding: 7bit

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

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

    COUNT(*)



    --
    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:
    --------------030004050507010909090506
    Content-Type: text/html; charset=us-ascii
    Content-Transfer-Encoding: 7bit

    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

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

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

    &nbsp; COUNT(*)
    ----------
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0

    --
    Daniel W. Fink
    http://www.optimaldba.com" rel="nofollow">http://www.optimaldba.com">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:

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMar 19, '03 at 4:52p
activeMar 19, '03 at 7:23p
posts3
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase