DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Inserting a singlecote ' into tables

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    Hi,
    I am trying to insert the data , that I get from some session tracking program. I receive the filename and the sitename.

    some times the filename comes as
    'kid's play room','http://www.kidsplayroom.com'

    How do it insert this data, as it is without changing the form.

    When I try to insert this using my procedure,

    proc_load('kid'splay room', 'http://www....');
    I get an error,

    Can anyone help me in loading this data as it is

    I am using oracle 8.1.6
    Badrinath

  2. #2
    Join Date
    Aug 2000
    Location
    CA
    Posts
    2
    hi,

    u might want to try this:

    proc_load('kid''splay room', 'http://www....');

    (two single quotes between d and s)

    [Edited by WengLi on 02-15-2001 at 06:01 PM]

  3. #3
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    Try this.

    exec proc_load(''''||'kid'||''''||'s play room',...);

  4. #4
    Join Date
    Jan 2001
    Posts
    642
    Thanks,
    It worked the way Wengli said
    Badrinath

  5. #5
    Join Date
    Jan 2001
    Posts
    642
    One more, How do I insert ampersand (&) into the tables in the insert statements.

  6. #6
    Join Date
    Jan 2001
    Posts
    642
    And also through the procedure.

    Example:

    proc_load('kid&youth's play room', 'http://www....');

    Badrinath


  7. #7
    Join Date
    Jan 2001
    Posts
    2,828
    try this ver simple

    proc_load('kid \&youth's play room', 'http://www....');


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width