String INSERT Function - Example?

Relational Database

Brought to you by: fredt, unsaved

String INSERT Function - Example?

Forum: Help

Creator: Michael Dever

Created: 2012-03-19

Updated: 2014-01-19

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

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Fred Toussi - 2012-03-19

Yes, a comma is missing:

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

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Michael Dever - 2012-03-20

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

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.