Check out Oracle tutorials.
In this Oracle tutorial, we will learn about the decimal datatype in the oracle database. Also, we will illustrate how to use it to create decimals columns for a table in oracle. Introduction to Oracle Decimal datatype A decimal data type with fixed precision and scale is called DECIMAL in Oracle 21c. It is used … Read more >>
In this Oracle tutorial, we will learn about the Nchar datatype in the oracle database. Also, we will demonstrate how to use it to create Nchar columns for a table in oracle. Introduction to Oracle Nchar datatype A word string that can store Unicode information is known as an n-char and the nchar stands for … Read more >>
In this Oracle tutorial, we will learn about the Varchar2 datatype in the oracle database. Also, we will demonstrate how to use it to create varchar2 columns for a table. Introduction to Oracle Varchar2 Datatype The character values are stored using the VarChar2 data type. Because it is a variable-length data type, we can alter … Read more >>
In this oracle tutorial, we will learn how to delete duplicate rows in oracle database 21c. Moreover, we will take multiple examples where we need to delete duplicate rows in the oracle database. A table holds duplicate rows when the two or more rows in the tables are identical and the values of the bother … Read more >>
In this Oracle tutorial, we will learn how to use the Char datatype in oracle database 21c. Moreover, we will take a look at multiple examples and we will check with the use of char datatype. Introduction to Oracle Char datatype The character values are stored using the char data type. It is a fixed-length data … Read more >>
In this Oracle tutorial, we will learn about the float datatype in the oracle database. Also, we will demonstrate how to use it to create float columns for a table. Introduction to Oracle FLOAT datatype Floating-point numbers of the FLOAT datatype have a binary precision of b. This datatype’s default precision is 126 binary or 38 decimals. … Read more >>
In this Oracle tutorial, we will learn how to use the datatype in oracle database 21c. Moreover, we will take a look at multiple tables where the Oracle data types, including character, NUMBER, DATE, binary (LOB, RAW, and LONG RAW), ROWID and UNROWID, and XML data types, will be briefly discussed. Oracle Database Datatypes are utilized … Read more >>
In this oracle tutorial, we will learn how to construct a new sequence in Oracle using the Oracle CREATE SEQUENCE statement. An Oracle object called a sequence is used to create a numerical sequence. When you need to generate a special number to use as a primary key, this can be helpful. Here we will … Read more >>
In this Oracle tutorial, we will learn how to create an index in oracle database 21c. Moreover, we will take a look at multiple examples where we need to create an index in the oracle database An index is a schema object that allows fast, direct access to rows by storing entries for each value … Read more >>
In this Oracle tutorial, we will learn how to create a table using stored procedures in oracle 21c. Also, we will cover these topics: Oracle stored procedure create table In this section, we will learn how to write a stored procedure to create a simple table in oracle database 21c. A stored procedure is created … Read more >>
Download A 40 pages PDF And Learn Now.