What Are Data Types Limitations

Q

What Are Data Types Limitations?

✍: fyicenter.com

A
  • Max. columns in a table is 255. Max. Char size is 255, Long is 64K and Number is 38 digits.
  • Cannot Query on a long column.
  • Char, Varchar2 Max. size is 2000 and default is 1 byte.
  • Number(p,s) p is precision range 1 to 38, s is scale -84 to 127.
  • Long Character data of variable length upto 2GB.
  • Date Range from Jan 4712 BC to Dec 4712 AD.
  • Raw Stores Binary data (Graphics Image and Digitized Sound). Max. is 255 bytes.

2007-04-15, 4626👍, 0💬