Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2013
    Posts
    6

    Unanswered: SQL Plus problem

    So I am trying to add some records to my table. however i keep getting enter values for senior? I dont get it. What did I do wrong?


    My insert statement is INSERT INTO volunteer_opp(OPPORTUNITY_ID,CONTENT_ID,VOL_REQUES TS,TITLE,HITS,CATEGORY_ID,ORG_TITLE,ORG_CONTENT_ID ,ADDRESSES_COUNT,LOCALITY,REGION,POSTALCODE,CREATE D_DATE,LAST_MODIFIED_DATE,START_DATE_DATE,END_DATE _DATE) VALUES (4960,36730,25,'Mentors, Register to Attend A Breakfast Orientation January 24, 2011',35,1,'Community Service Society/Retired & Senior Volunteer Program',4279,1,'105 22nd St
    New York, NY 10010','NY',10010,'4-Jan-11','19-Jan-11','4-Jan-11','4-Jan-11'); and this is the insert table
    CREATE TABLE volunteer_opp
    (
    opportunity_id NUMBER NOT NULL PRIMARY KEY,
    content_id NUMBER NOT NULL ,
    vol_requests NUMBER ,
    title NUMBER NOT NULL ,
    hits NUMBER,
    category_id NUMBER,
    org_title CHAR,
    org_content_id NUMBER,
    address_count NUMBER,
    locality CHAR,
    region CHAR,
    postalcode NUMBER,
    create_date DATE ,
    last_modified_date DATE ,
    start_date_date DATE ,
    end_date_date DATE
    ) ;

  2. #2
    Join Date
    Feb 2006
    Posts
    173
    Provided Answers: 1
    It's the embedded ampersand(&).
    Run this sqlplus command before running the insert command:

    Code:
    set define off

  3. #3
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Wrong forum. SQL*Plus is for Oracle not for MySQL.
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

Posting Permissions

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