oracle10g - Oracle 10g - Escape quote in insert statement -


I am trying to put the height of people in the database as 5'9

How do I avoid the quote properly so I can do it. My convergence statement so far looks like this.

  Include height (id, height) values ​​(height-seq.nexval, '5' '9');   

Backslash does not work clearly and I'm very new to Oracle Oracle uses standard SQL:

 Enter height (id, height)     value (height-seq.nexval, '5''9');  

(yes there are two single quotes)

Comments