ORA-00928 missing SELECT keyword

如網上大部分出現的類似，是因為列名上不能添加單引号，可是我仔細檢查了一下并沒有在列上加多餘的單引号，因為我是用ibatis 配置的sql語句， <dynamic prepend=" ">，其中prepend的值就表示用什麼符号，但是我用的是""，并沒有多餘的單引号，再細看發現我的""中沒有空格，加上一個空格後，即" ",後程式正常運轉，特在此分享給大家。

<insert id="PhotoAlbumsSQL.createAlbum" parameterClass="photoAlbums">

  insert into photoalbums(

   <dynamic prepend=" ">

    <isNotEmpty  prepend="," property="albums_id">

    albums_id

    </isNotEmpty>

    <isNotEmpty  prepend="," property="albums_name">

    albums_name

    </isNotEmpty>

    <isNotEmpty  prepend="," property="create_tim">

    create_tm

    </isNotEmpty>

    <isNotEmpty  prepend="," property="update_tim">

    update_tm

    </isNotEmpty>

    <isNotEmpty  prepend="," property="albums_limits">

    albums_limits

    </isNotEmpty>

    <isNotEmpty  prepend="," property="album_cover">

    album_cover

    </isNotEmpty>

    <isNotEmpty  prepend="," property="album_category">

    album_category

    </isNotEmpty>

    <isNotEmpty  prepend="," property="album_desc">

    album_desc

    </isNotEmpty>

    <isNotEmpty  prepend="," property="albums_type">

    albums_type

    </isNotEmpty>

    <isNotEmpty  prepend="," property="creator">

    creator

    </isNotEmpty>

   </dynamic>

  ) values (

   <dynamic prepend=" ">

      <isNotEmpty  prepend="," property="albums_id">

    #albums_id#

    </isNotEmpty>

    <isNotEmpty  prepend="," property="albums_name">

    #albums_name#

    </isNotEmpty>

    <isNotEmpty  prepend="," property="create_tim">

    #create_tim#

    </isNotEmpty>

    <isNotEmpty  prepend="," property="update_tim">

    #update_tim#

    </isNotEmpty>

    <isNotEmpty  prepend="," property="albums_limits">

    #albums_limits#

    </isNotEmpty>

    <isNotEmpty  prepend="," property="album_cover">

    #album_cover#

    </isNotEmpty>

    <isNotEmpty  prepend="," property="album_category">

    #album_category#

    </isNotEmpty>

    <isNotEmpty  prepend="," property="album_desc">

    #album_desc#

    </isNotEmpty>

    <isNotEmpty  prepend="," property="albums_type">

    #albums_type#

    </isNotEmpty>

    <isNotEmpty  prepend="," property="creator">

    #creator#

    </isNotEmpty>

   </dynamic>

  )

 </insert>