String INSERT Function - Example?

Help
2012-03-19
2014-01-19
  • Michael Dever

    Michael Dever - 2012-03-19

    Please check this INSERT function syntax.
    I'm getting error: SQLSyntaxErrorException.
    Can you help me with the syntax?
    Thanks.

    SELECT INSERT( 'abcdefg' 1, 3, 'xxx' ) from dual

     
  • Fred Toussi

    Fred Toussi - 2012-03-19

    Yes, a comma is missing:

    SELECT INSERT( 'abcdefg', 1, 3, 'xxx' ) from dual

     
  • Michael Dever

    Michael Dever - 2012-03-20

    Thanks.
    Next time I'll type it in twice.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks