Oracle Data type Limit

-

 

DatatypesLimitComments

BFILE

Maximum size: 4 GB

Maximum size of a file name: 255 characters

Maximum size of a directory name: 128 bytes

Maximum number of open BFILEs: see Comments

The maximum number of BFILEs is limited by the value of the SESSION_MAX_OPEN_FILES initialization parameter, which is itself limited by the maximum number of open files the operating system will allow.

BLOB

Maximum size: (4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB)

The number of LOB columns per table is limited only by the maximum number of columns per table (that is, 1000Foot 1).

CHAR

Maximum size: 2000 bytes

None

CLOB

Maximum size: (4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB)

The number of LOB columns per table is limited only by the maximum number of columns per table (that is, 1000Foot 1).

Literals (characters or numbers in SQL or PL/SQL)

Maximum size: 4000 characters

None

LONG

Maximum size: 2 GB - 1

Only one LONG column is allowed per table.

NCHAR

Maximum size: 2000 bytes

None

NCLOB

Maximum size: (4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB)

The number of LOB columns per table is limited only by the maximum number of columns per table (that is, 1000Foot 1).

NUMBER

999...(38 9's) x10125 maximum value

-999...(38 9's) x10125 minimum value

Can be represented to full 38-digit precision (the mantissa)

Can be represented to full 38-digit precision (the mantissa)

NVARCHAR2

Maximum size: 4000 bytes, or 32767 bytes if the MAX_STRING_SIZE initialization parameter is set to EXTENDED

See Also: "MAX_STRING_SIZE" initialization parameter for additional details

None

Precision

38 significant digits

None

RAW

Maximum size: 2000 bytes, or 32767 bytes if the MAX_STRING_SIZE initialization parameter is set to EXTENDED

See Also: "MAX_STRING_SIZE" initialization parameter for additional details

None

VARCHAR2

Maximum size: 4000 bytes, or 32767 bytes if the MAX_STRING_SIZE initialization parameter is set to EXTENDED

See Also: "MAX_STRING_SIZE" initialization parameter for additional details

None

Comments

Post a Comment

Popular posts from this blog

Difference join between (+) and (-) notation

-
  I have very old application. Then I saw some store procedure using (+) or (-) notation on the query. What i want to ask are : 1. what is the difference between (+) and (-) notation ? 2. what is the difference between (the position of the notation I put on left or right) ? SELECT * FROM A, B WHERE A.column = B.column(+) and SELECT * FROM A, B WHERE A.column(+) = B.column 3. I read from forum that notation is only present for backwards compatibility because Oracle debuted it before the ANSI standard for joins. So is there any problem if I'm not change the notation to 'join' statement (ANSI standard) on my old existing query ? 4. Is it recommended or not using notation (+) (-) ? 5. How about the performance. It's good using (+) (-) notation or join notation ? and Chris said... The plus sign is Oracle syntax for an outer join. There isn't a minus operator for joins. An outer join means return all rows from one table. Also return the rows from the outer joined where th...
Read more

Oracle Data Guard Startup & Shutdown Steps

-
Image
Data Guard Shutdown Sequence Stop log apply service or MRP and shutdown the standby SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL ; SQL > SHUT IMMEDIATE ; Stop log shipping from primary and shutdown primary database SQL > ALTER SYSTEM SET log_archive_dest_state_2 = 'DEFER' ; SQL > ALTER SYSTEM SET log_archive_dest_state_3 = 'DEFER' ; SQL > SHUT Transactional ; Modes of Shutdown of the Oracle Database: Shutdown Normal Shutdown Transactional Shutdown Immediate Shutdown Abort Data Guard Startup Sequence Startup primary database and enable log shipping SQL > STARTUP ; SQL > ALTER SYSTEM SET log_archive_dest_state_2 = 'ENABLE' ; SQL > ALTER SYSTEM SET log_archive_dest_state_3 = 'ENABLE' ; Startup standby and enable log apply service or MRP SQL > startup nomount ; SQL > alter database mount standby database ; SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNE...
Read more

Setup Oracle Database in Laravel

-
  Laravel is a powerful PHP web application framework that is widely used for building web applications. One of the strengths of Laravel is its ability to work with various databases. In this tutorial, we will walk through the steps involved in setting up an Oracle database in a Laravel framework. Prerequisites Before we begin, ensure that the following requirements are met: A Laravel project is set up on your machine The Oracle database software is installed and running The Oracle Instant Client is installed on your machine Basic knowledge of Laravel and Oracle database Step 1: Install the Oracle Driver The first step is to install the Oracle driver for PHP. The driver can be installed using the following command: composer require yajra/laravel-oci8 This command will install the Oracle driver and its dependencies in your Laravel project. Step 2: Configure the Oracle Driver Next, we need to configure the Oracle driver. To do this, open the “config/database.php” file in your Laravel...
Read more