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

  • 3 Contributors
  • 2 Replies
  • 118 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by hfx642
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.