In this Oracle tutorial, we will learn about the nclob datatype in the oracle database. Also, we will demonstrate how to use it to create nclob columns for a table in oracle.
Introduction to Oracle nclob Datatype
The NCLOB data type is a variable-length data type that can store up to 4 GB of Unicode character data in a single database column. The NCLOB data type is a useful alternative to the CLOB data type when you need to store character data in your database.
The NCLOB data type is supported in Oracle 21c and can be used in a variety of applications, including web applications, content management systems, and more.
Also, check: How to Get List all Tables in Oracle Database
Oracle nclob datatype Syntax
The syntax for declaring a column of nclob datatype in Oracle 21c is as follows:
where column_name is the name of the NCLOB column you want to create.
Read: How to add a foreign key in Oracle
Oracle nclob datatype Example
Here’s an example of how you can create a table with a nclob column in Oracle 21c.
CREATE TABLE employees ( emp_id NUMBER, nclob_value NCLOB );
Now we will insert data into a table with an NCLOB column using the INSERT statement.
INSERT INTO employees (emp_id, nclob_value) VALUES (897, 'This is a test'); INSERT INTO employees (emp_id, nclob_value) VALUES (534, 'This is another test');
In this example, we create a table named employees with two columns: emp_id and nclob_value. The nclob_value column is defined as an NCLOB, allowing it to store large amounts of character data.
Next, we insert two rows into the table with the INSERT INTO statement. Finally, we use the SELECT statement to retrieve all the data from the employees. The output shows that the NCLOB data is stored in the database and can be retrieved with a SELECT statement.
Also, check: Oracle Add Row Number
Now we will use the NCLOB datatype in a SQL developer tool using oracle 21c.
Here we will insert the values into a students table
INSERT INTO students (student_id, student_description) VALUES (4563, 'john lives in USA'); INSERT INTO students (student_id, student_description) VALUES (9523, 'Micheal is born in Newyork City');
Benefits of Using Nclob
- Increased storage capacity: The NCLOB data type can store up to 4 GB of data, making it an ideal choice for storing large amounts of character data in a single database column.
- Improved performance: The NCLOB data type is optimized for performance, allowing for fast and efficient storage and retrieval of character data.
- Support for multiple languages: The NCLOB data type is designed to store Unicode character data, making it an ideal choice for storing multilingual data in your database.
- Compatibility with other data types: The NCLOB data type is compatible with other data types in Oracle 21c, including NUMBER, DATE, and more, making it easy to integrate into your existing database structures.
So, in this Oracle tutorial, we understood how to define and use the nclob Datatype in Oracle Database. And we have also covered a few sample examples related to it.
Also, take a look at some more Oracle tutorials.
I am Bijay having more than 15 years of experience in the Software Industry. During this time, I have worked on MariaDB and used it in a lot of projects. Most of our readers are from the United States, Canada, United Kingdom, Australia, New Zealand, etc.
Want to learn MariaDB? Check out all the articles and tutorials that I wrote on MariaDB. Also, I am a Microsoft MVP.