What Are Data Types Limitations

Home > PL/SQL > General

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, 4772👍, 0💬

What Is Rollback
What Is Rollback? Rollback causes work in the current transaction to be undone. 2007-04-15, 5002👍, 0💬

What Is a Join
What Is a Join? Join is the form of SELECT command that combines info from two or more tables. Types of Joins are Simple (Equijoin and Non-Equijoin), Outer and Self join. Equijoin returns rows from two or more tables joined together based upon a equality condition in the WHERE clause. Non-Equijoin r... 2007-04-15, 4888👍, 0💬

What Is Commit
What Is Commit? Commit is an event that attempts to make data in the database identical to the data in the form. It involves writing or posting data to the database and committing data to the database. Forms check the validity of the data in fields and records during a commit. Validity check are uni... 2007-04-15, 4819👍, 0💬

In What Order Different Parts of SQL Statements Are Executed
In What Order Different Parts of SQL Statements Are Executed? Where clause, Group By clause, Having clause, Order By clause and Select. 2007-04-15, 4811👍, 0💬

What Are Data Types Limitations
What Are Data Types Limitations? 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 ... 2007-04-15, 4773👍, 0💬

What Is a Transaction
What Is a Transaction? Transaction is defined as all changes made to the database between successive commits. 2007-04-15, 4742👍, 0💬

What Is a Sequences
What Is a Sequences? Sequences are used for generating sequence numbers without any overhead of locking. Drawback is that after generating a sequence number if the transaction is rolled back, then that sequence number is lost. 2007-04-15, 4673👍, 0💬

What Are Synonyms
What Are Synonyms? Synonyms is the alias name for table, views, sequences and procedures and are created for reasons of Security and Convenience. Two levels are Public - created by DBA and accessible to all the users. Private - Accessible to creator only. Advantages are referencing without specifyin... 2007-04-15, 4656👍, 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.