Oracle - Oracle Built-in Data Types in Oracle

Home > Oracle

Oracle Built-in Data Types in Oracle

Q

What Are the Oracle Built-in Data Types in Oracle?

✍: FYIcenter.com

A

There are 20 Oracle built-in data types, divided into 6 groups:

Character Datatypes - CHAR, NCHAR, NVARCHAR2, VARCHAR2
Number Datatypes - NUMBER, BINARY_FLOAT, BINARY_DOUBLE
Long and Row Datatypes - LONG, LONG RAW, RAW
Datetime Datatypes - DATE, TIMESTAMP, INTERVAL YEAR TO MONTH, INTERVAL DAY TO SECOND
Large Object Datatypes - BLOB, CLOB, NCLOB, BFILE
Row ID Datatypes - ROWID, UROWID

⇒Understanding SQL Language Basics for Oracle

⇒⇒Oracle Database Tutorials

2016-10-17, 582👍, 0💬

💬 2017-07-10 sasi: Nice tutorial..

About dba.FYIcenter.com Website
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administrators) and database application developers looking for database server management tips, database programming tutorials, career information, and so on. Just browse through the site, you will find the b... 2016-10-17, 3616👍, 0💬

Testing Area
What is test testing area for? The testing area is provided to allow visitors to post testing comments. 2016-10-15, 693👍, 1💬

💬 2017-07-10 Kumar Kedi: ascdfwtwert

Privilege to Query Tables in Another Schema in Oracle
What Privilege Is Needed for a User to Query Tables in Another Schema in Oracle? For a user to run queries (SELECT statements) on tables of someone else's schema, he/she needs the SELECT ANY TABLE privilege. The following tutorial exercise gives you a good example of granting "dev" to query tables i... 2019-06-11, 528👍, 0💬

Privilege to Insert Rows in Another Schema in Oracle
What Privilege Is Needed for a User to Insert Rows to Tables in Another Schema in Oracle? For a user to insert rows into tables of someone else's schema, he/she needs the INSERT ANY TABLE privilege. The following tutorial exercise gives you a good example of granting "dev" to insert rows in "hr" sch... 2019-06-11, 526👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.