Oracle Incorrect values

[divyakprabh]

Hi everyone!!!

I wanted to know the incorrect values for oracle data types.

like for example, string data type cannot accept ' value.

What other values does string data type does not allow.?

and what about other data types like number, float.

Thanks in advance..

[pinkartist]

Hi,this link has the answer:
http://www.w3schools.com/sql/sql_datatypes.asp

[hfx642]

The Oracle datatype VARCHAR2 can accept the ' (single quote).
You just have to put two of them '' to get it in.
It will be stored in the column as a ' (single quote).