Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

Saturday, 20 September 2014

Character Data types in Oracle

Oracle character data types / Character data types used in Oracle / Character data types supported by Oracle / Various character type variable declaration using Oracle

Character Datatypes


Oracle Character Datatypes are used to store alphanumeric character data. The following datatypes are the Character datatypes supported in Oracle.




LOB Character Datatypes                     – CLOB and NCLOB

LONG Datatype                                   – LONG



Data Types in Oracle

Oracle Datatypes / Supported datatypes in Oracle / Datatypes in Oracle (Up to Oracle 12c) / Various datatypes that are used in Oracle variable declaration / List of datatypes supported by Oracle up to Oracle 12c


Complete Guide to Oracle Datatypes (Up to Oracle 12c)


Oracle uses and supports the following built-in Datatype categories in creating tables, declaring variables in PL/SQL etc.

Character Datatypes           – To store and manipulate character based values / strings

Numeric Datatypes             – To store and manipulate numbers

Date Datatypes                  – To store and manipulate date and time

LOB Datatypes                   – To store and manipulate large objects like text based files, images, videos etc.

RAW Datatypes                  - To store graphics, sound, documents etc.

ROWID Datatypes               - To store the addresses of every row in a database.




SQL exercises for beginners one

SQL Exercises for Beginners / Simple SQL Exercises with Answers / Solved SQL exercises / SQL solved exercises with simple conditions / So...