1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

doubts in query

Discussion in 'General' started by sriram_gc, Dec 27, 2010.

  1. sriram_gc

    sriram_gc Active Member

    Messages:
    4
    Likes Received:
    1
    Trophy Points:
    65
    hai i am beginner, i have one doubt

    i have one table as sample that contanis x , y,z columns

    x contains names, y contains names in that i want to select x which is not containes # means the content text will be changed as invalid same. other wise
    what it already contains same for y also.

    how to form a query
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Well I am no sql expert either, but you need to look at oracle's string functions for your query... in particular instr and substr functions
     
  3. jason_m_Longoria

    jason_m_Longoria Active Member

    Messages:
    23
    Likes Received:
    3
    Trophy Points:
    90
    Can you be more descriptive in what you are trying to do in your example? Like tell us what the X,Y,Z columns are and what the rows are populated with. I see you have name and name. but what is the calculation you are trying to get out of the system.

    THANKS
    Jason M Longoria
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,348
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Please provide an example of what you describe as your post is somewhat confusing.
     
  5. sriram_gc

    sriram_gc Active Member

    Messages:
    4
    Likes Received:
    1
    Trophy Points:
    65
    sorry for your confusion, i have one table as contact with three column one is email1, second is email two , third is phone no these are the three columns.
    in that 2 email fields i want to select the fileds which is not contanined '@' . and i want to change these field contents as 'invalid email' . how to form the query.
    thanks for your reply
     
  6. sriram_gc

    sriram_gc Active Member

    Messages:
    4
    Likes Received:
    1
    Trophy Points:
    65
    sorry for your confusion, i have one table as contact with three column one is email1, second is email two , third is phone no these are the three columns.
    in that 2 email fields i want to select the fileds which is not contanined '@' . and i want to change these field contents as 'invalid email' . how to form the query.
    thanks for your reply
     
  7. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,348
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    The instr() function will help you:

    Code (SQL):
     
    SQL> CREATE TABLE email_tst(
      2  email1 varchar2(80),
      3  email2 varchar2(80),
      4  phonenbr varchar2(14));
    TABLE created.
    SQL>
    SQL> BEGIN
      2          FOR i IN 1..100 loop
      3                  INSERT INTO email_tst
      4                  VALUES([EMAIL="'bob@'||i||'.com'"]'bob@'||i||'.com'[/EMAIL], 'ed'||i||'.com', '1-234-567-8900');
      5          END loop;
      6
      7          commit;
      8  END;
      9  /
    PL/SQL PROCEDURE successfully completed.
    SQL>
    SQL> SELECT * FROM email_tst;
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@1.com"]bob@1.com[/EMAIL]            ed1.com              1-234-567-8900
    [EMAIL="bob@2.com"]bob@2.com[/EMAIL]            ed2.com              1-234-567-8900
    [EMAIL="bob@3.com"]bob@3.com[/EMAIL]            ed3.com              1-234-567-8900
    [EMAIL="bob@4.com"]bob@4.com[/EMAIL]            ed4.com              1-234-567-8900
    [EMAIL="bob@5.com"]bob@5.com[/EMAIL]            ed5.com              1-234-567-8900
    [EMAIL="bob@6.com"]bob@6.com[/EMAIL]            ed6.com              1-234-567-8900
    [EMAIL="bob@7.com"]bob@7.com[/EMAIL]            ed7.com              1-234-567-8900
    [EMAIL="bob@8.com"]bob@8.com[/EMAIL]            ed8.com              1-234-567-8900
    [EMAIL="bob@9.com"]bob@9.com[/EMAIL]            ed9.com              1-234-567-8900
    [EMAIL="bob@10.com"]bob@10.com[/EMAIL]           ed10.com             1-234-567-8900
    [EMAIL="bob@11.com"]bob@11.com[/EMAIL]           ed11.com             1-234-567-8900
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@12.com"]bob@12.com[/EMAIL]           ed12.com             1-234-567-8900
    [EMAIL="bob@13.com"]bob@13.com[/EMAIL]           ed13.com             1-234-567-8900
    [EMAIL="bob@14.com"]bob@14.com[/EMAIL]           ed14.com             1-234-567-8900
    [EMAIL="bob@15.com"]bob@15.com[/EMAIL]           ed15.com             1-234-567-8900
    [EMAIL="bob@16.com"]bob@16.com[/EMAIL]           ed16.com             1-234-567-8900
    [EMAIL="bob@17.com"]bob@17.com[/EMAIL]           ed17.com             1-234-567-8900
    [EMAIL="bob@18.com"]bob@18.com[/EMAIL]           ed18.com             1-234-567-8900
    [EMAIL="bob@19.com"]bob@19.com[/EMAIL]           ed19.com             1-234-567-8900
    [EMAIL="bob@20.com"]bob@20.com[/EMAIL]           ed20.com             1-234-567-8900
    [EMAIL="bob@21.com"]bob@21.com[/EMAIL]           ed21.com             1-234-567-8900
    [EMAIL="bob@22.com"]bob@22.com[/EMAIL]           ed22.com             1-234-567-8900
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@23.com"]bob@23.com[/EMAIL]           ed23.com             1-234-567-8900
    [EMAIL="bob@24.com"]bob@24.com[/EMAIL]           ed24.com             1-234-567-8900
    [EMAIL="bob@25.com"]bob@25.com[/EMAIL]           ed25.com             1-234-567-8900
    [EMAIL="bob@26.com"]bob@26.com[/EMAIL]           ed26.com             1-234-567-8900
    [EMAIL="bob@27.com"]bob@27.com[/EMAIL]           ed27.com             1-234-567-8900
    [EMAIL="bob@28.com"]bob@28.com[/EMAIL]           ed28.com             1-234-567-8900
    [EMAIL="bob@29.com"]bob@29.com[/EMAIL]           ed29.com             1-234-567-8900
    [EMAIL="bob@30.com"]bob@30.com[/EMAIL]           ed30.com             1-234-567-8900
    [EMAIL="bob@31.com"]bob@31.com[/EMAIL]           ed31.com             1-234-567-8900
    [EMAIL="bob@32.com"]bob@32.com[/EMAIL]           ed32.com             1-234-567-8900
    [EMAIL="bob@33.com"]bob@33.com[/EMAIL]           ed33.com             1-234-567-8900
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@34.com"]bob@34.com[/EMAIL]           ed34.com             1-234-567-8900
    [EMAIL="bob@35.com"]bob@35.com[/EMAIL]           ed35.com             1-234-567-8900
    [EMAIL="bob@36.com"]bob@36.com[/EMAIL]           ed36.com             1-234-567-8900
    [EMAIL="bob@37.com"]bob@37.com[/EMAIL]           ed37.com             1-234-567-8900
    [EMAIL="bob@38.com"]bob@38.com[/EMAIL]           ed38.com             1-234-567-8900
    [EMAIL="bob@39.com"]bob@39.com[/EMAIL]           ed39.com             1-234-567-8900
    [EMAIL="bob@40.com"]bob@40.com[/EMAIL]           ed40.com             1-234-567-8900
    [EMAIL="bob@41.com"]bob@41.com[/EMAIL]           ed41.com             1-234-567-8900
    [EMAIL="bob@42.com"]bob@42.com[/EMAIL]           ed42.com             1-234-567-8900
    [EMAIL="bob@43.com"]bob@43.com[/EMAIL]           ed43.com             1-234-567-8900
    [EMAIL="bob@44.com"]bob@44.com[/EMAIL]           ed44.com             1-234-567-8900
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@45.com"]bob@45.com[/EMAIL]           ed45.com             1-234-567-8900
    [EMAIL="bob@46.com"]bob@46.com[/EMAIL]           ed46.com             1-234-567-8900
    [EMAIL="bob@47.com"]bob@47.com[/EMAIL]           ed47.com             1-234-567-8900
    [EMAIL="bob@48.com"]bob@48.com[/EMAIL]           ed48.com             1-234-567-8900
    [EMAIL="bob@49.com"]bob@49.com[/EMAIL]           ed49.com             1-234-567-8900
    [EMAIL="bob@50.com"]bob@50.com[/EMAIL]           ed50.com             1-234-567-8900
    [EMAIL="bob@51.com"]bob@51.com[/EMAIL]           ed51.com             1-234-567-8900
    [EMAIL="bob@52.com"]bob@52.com[/EMAIL]           ed52.com             1-234-567-8900
    [EMAIL="bob@53.com"]bob@53.com[/EMAIL]           ed53.com             1-234-567-8900
    [EMAIL="bob@54.com"]bob@54.com[/EMAIL]           ed54.com             1-234-567-8900
    [EMAIL="bob@55.com"]bob@55.com[/EMAIL]           ed55.com             1-234-567-8900
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@56.com"]bob@56.com[/EMAIL]           ed56.com             1-234-567-8900
    [EMAIL="bob@57.com"]bob@57.com[/EMAIL]           ed57.com             1-234-567-8900
    [EMAIL="bob@58.com"]bob@58.com[/EMAIL]           ed58.com             1-234-567-8900
    [EMAIL="bob@59.com"]bob@59.com[/EMAIL]           ed59.com             1-234-567-8900
    [EMAIL="bob@60.com"]bob@60.com[/EMAIL]           ed60.com             1-234-567-8900
    [EMAIL="bob@61.com"]bob@61.com[/EMAIL]           ed61.com             1-234-567-8900
    [EMAIL="bob@62.com"]bob@62.com[/EMAIL]           ed62.com             1-234-567-8900
    [EMAIL="bob@63.com"]bob@63.com[/EMAIL]           ed63.com             1-234-567-8900
    [EMAIL="bob@64.com"]bob@64.com[/EMAIL]           ed64.com             1-234-567-8900
    [EMAIL="bob@65.com"]bob@65.com[/EMAIL]           ed65.com             1-234-567-8900
    [EMAIL="bob@66.com"]bob@66.com[/EMAIL]           ed66.com             1-234-567-8900
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@67.com"]bob@67.com[/EMAIL]           ed67.com             1-234-567-8900
    [EMAIL="bob@68.com"]bob@68.com[/EMAIL]           ed68.com             1-234-567-8900
    [EMAIL="bob@69.com"]bob@69.com[/EMAIL]           ed69.com             1-234-567-8900
    [EMAIL="bob@70.com"]bob@70.com[/EMAIL]           ed70.com             1-234-567-8900
    [EMAIL="bob@71.com"]bob@71.com[/EMAIL]           ed71.com             1-234-567-8900
    [EMAIL="bob@72.com"]bob@72.com[/EMAIL]           ed72.com             1-234-567-8900
    [EMAIL="bob@73.com"]bob@73.com[/EMAIL]           ed73.com             1-234-567-8900
    [EMAIL="bob@74.com"]bob@74.com[/EMAIL]           ed74.com             1-234-567-8900
    [EMAIL="bob@75.com"]bob@75.com[/EMAIL]           ed75.com             1-234-567-8900
    [EMAIL="bob@76.com"]bob@76.com[/EMAIL]           ed76.com             1-234-567-8900
    [EMAIL="bob@77.com"]bob@77.com[/EMAIL]           ed77.com             1-234-567-8900
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@78.com"]bob@78.com[/EMAIL]           ed78.com             1-234-567-8900
    [EMAIL="bob@79.com"]bob@79.com[/EMAIL]           ed79.com             1-234-567-8900
    [EMAIL="bob@80.com"]bob@80.com[/EMAIL]           ed80.com             1-234-567-8900
    [EMAIL="bob@81.com"]bob@81.com[/EMAIL]           ed81.com             1-234-567-8900
    [EMAIL="bob@82.com"]bob@82.com[/EMAIL]           ed82.com             1-234-567-8900
    [EMAIL="bob@83.com"]bob@83.com[/EMAIL]           ed83.com             1-234-567-8900
    [EMAIL="bob@84.com"]bob@84.com[/EMAIL]           ed84.com             1-234-567-8900
    [EMAIL="bob@85.com"]bob@85.com[/EMAIL]           ed85.com             1-234-567-8900
    [EMAIL="bob@86.com"]bob@86.com[/EMAIL]           ed86.com             1-234-567-8900
    [EMAIL="bob@87.com"]bob@87.com[/EMAIL]           ed87.com             1-234-567-8900
    [EMAIL="bob@88.com"]bob@88.com[/EMAIL]           ed88.com             1-234-567-8900
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@89.com"]bob@89.com[/EMAIL]           ed89.com             1-234-567-8900
    [EMAIL="bob@90.com"]bob@90.com[/EMAIL]           ed90.com             1-234-567-8900
    [EMAIL="bob@91.com"]bob@91.com[/EMAIL]           ed91.com             1-234-567-8900
    [EMAIL="bob@92.com"]bob@92.com[/EMAIL]           ed92.com             1-234-567-8900
    [EMAIL="bob@93.com"]bob@93.com[/EMAIL]           ed93.com             1-234-567-8900
    [EMAIL="bob@94.com"]bob@94.com[/EMAIL]           ed94.com             1-234-567-8900
    [EMAIL="bob@95.com"]bob@95.com[/EMAIL]           ed95.com             1-234-567-8900
    [EMAIL="bob@96.com"]bob@96.com[/EMAIL]           ed96.com             1-234-567-8900
    [EMAIL="bob@97.com"]bob@97.com[/EMAIL]           ed97.com             1-234-567-8900
    [EMAIL="bob@98.com"]bob@98.com[/EMAIL]           ed98.com             1-234-567-8900
    [EMAIL="bob@99.com"]bob@99.com[/EMAIL]           ed99.com             1-234-567-8900
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@100.com"]bob@100.com[/EMAIL]          ed100.com            1-234-567-8900
    100 ROWS selected.
    SQL>
    SQL> UPDATE email_tst
      2  SET email2='Invalid email' WHERE instr(email2,'@')=0;
    100 ROWS updated.
    SQL>
    SQL> commit;
    Commit complete.
    SQL>
    SQL> SELECT * FROM email_tst;
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@1.com"]bob@1.com[/EMAIL]            Invalid email        1-234-567-8900
    [EMAIL="bob@2.com"]bob@2.com[/EMAIL]            Invalid email        1-234-567-8900
    [EMAIL="bob@3.com"]bob@3.com[/EMAIL]            Invalid email        1-234-567-8900
    [EMAIL="bob@4.com"]bob@4.com[/EMAIL]            Invalid email        1-234-567-8900
    [EMAIL="bob@5.com"]bob@5.com[/EMAIL]            Invalid email        1-234-567-8900
    [EMAIL="bob@6.com"]bob@6.com[/EMAIL]            Invalid email        1-234-567-8900
    [EMAIL="bob@7.com"]bob@7.com[/EMAIL]            Invalid email        1-234-567-8900
    [EMAIL="bob@8.com"]bob@8.com[/EMAIL]            Invalid email        1-234-567-8900
    [EMAIL="bob@9.com"]bob@9.com[/EMAIL]            Invalid email        1-234-567-8900
    [EMAIL="bob@10.com"]bob@10.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@11.com"]bob@11.com[/EMAIL]           Invalid email        1-234-567-8900
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@12.com"]bob@12.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@13.com"]bob@13.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@14.com"]bob@14.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@15.com"]bob@15.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@16.com"]bob@16.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@17.com"]bob@17.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@18.com"]bob@18.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@19.com"]bob@19.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@20.com"]bob@20.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@21.com"]bob@21.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@22.com"]bob@22.com[/EMAIL]           Invalid email        1-234-567-8900
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@23.com"]bob@23.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@24.com"]bob@24.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@25.com"]bob@25.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@26.com"]bob@26.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@27.com"]bob@27.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@28.com"]bob@28.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@29.com"]bob@29.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@30.com"]bob@30.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@31.com"]bob@31.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@32.com"]bob@32.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@33.com"]bob@33.com[/EMAIL]           Invalid email        1-234-567-8900
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@34.com"]bob@34.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@35.com"]bob@35.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@36.com"]bob@36.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@37.com"]bob@37.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@38.com"]bob@38.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@39.com"]bob@39.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@40.com"]bob@40.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@41.com"]bob@41.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@42.com"]bob@42.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@43.com"]bob@43.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@44.com"]bob@44.com[/EMAIL]           Invalid email        1-234-567-8900
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@45.com"]bob@45.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@46.com"]bob@46.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@47.com"]bob@47.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@48.com"]bob@48.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@49.com"]bob@49.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@50.com"]bob@50.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@51.com"]bob@51.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@52.com"]bob@52.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@53.com"]bob@53.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@54.com"]bob@54.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@55.com"]bob@55.com[/EMAIL]           Invalid email        1-234-567-8900
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@56.com"]bob@56.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@57.com"]bob@57.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@58.com"]bob@58.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@59.com"]bob@59.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@60.com"]bob@60.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@61.com"]bob@61.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@62.com"]bob@62.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@63.com"]bob@63.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@64.com"]bob@64.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@65.com"]bob@65.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@66.com"]bob@66.com[/EMAIL]           Invalid email        1-234-567-8900
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@67.com"]bob@67.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@68.com"]bob@68.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@69.com"]bob@69.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@70.com"]bob@70.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@71.com"]bob@71.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@72.com"]bob@72.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@73.com"]bob@73.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@74.com"]bob@74.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@75.com"]bob@75.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@76.com"]bob@76.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@77.com"]bob@77.com[/EMAIL]           Invalid email        1-234-567-8900
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@78.com"]bob@78.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@79.com"]bob@79.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@80.com"]bob@80.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@81.com"]bob@81.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@82.com"]bob@82.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@83.com"]bob@83.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@84.com"]bob@84.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@85.com"]bob@85.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@86.com"]bob@86.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@87.com"]bob@87.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@88.com"]bob@88.com[/EMAIL]           Invalid email        1-234-567-8900
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@89.com"]bob@89.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@90.com"]bob@90.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@91.com"]bob@91.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@92.com"]bob@92.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@93.com"]bob@93.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@94.com"]bob@94.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@95.com"]bob@95.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@96.com"]bob@96.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@97.com"]bob@97.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@98.com"]bob@98.com[/EMAIL]           Invalid email        1-234-567-8900
    [EMAIL="bob@99.com"]bob@99.com[/EMAIL]           Invalid email        1-234-567-8900
    EMAIL1               EMAIL2               PHONENBR
    -------------------- -------------------- --------------
    [EMAIL="bob@100.com"]bob@100.com[/EMAIL]          Invalid email        1-234-567-8900
    100 ROWS selected.
    SQL>