Error while insertting special characters in to oracle database

Help Studio
, ,
1

I am getting error while Insertting data in to oracle database while insertting with special character called @.
I have a row value called kk@gmail.com, bot is getting failed while insertting with @
but when I remove @ it is successfully loaded in to database.

2

@karthik_kulkarni1

In run query @ is used as a variable parameter…try to eacape it using \@

Use replace to replace it

Cheers

3

Please add "" or " ’ " before “@”
Hope it help,
regards,