CODEWITHSUNDEEP
sqldatabaseoracle-database
Poyraz
Poyraz

Reputation: 359

+ sign not inserted to Oracle db

I am trying to insert data with the query 

UPDATE CONTACTS SET internationalmsisdn = +904562038544 WHERE id = 31328

After executing query, the internationalmsisdn column is shown as 904562038544. Why do I lost + sign ?

Any idea?

Upvotes: 0

Views: 48

Answers (1)

Santhosh
Santhosh

Reputation: 8197

To insert a special character as a string you need to have the column type as varchar and pass the values as ,

UPDATE CONTACTS SET internationalmsisdn = '+904562038544' WHERE id = 31328

Hope this helps !!

Upvotes: 3

Related Questions