What Are SQL Data Types

  • 5 Feb, 2012

    Max. columns in a table is 255. Max. Char size is 255, Long is 64K & Number is 38 digits.Cannot Query on a long column.Char, Varchar2 Max. size is 2000 & 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 & Digitized Sound). Max. is 255 bytes.Mslabel Binary format of an OS label. Used primarily with Trusted Oracle.

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.