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..

Recommended Answers

All 2 Replies

Member Avatar for 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).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.