While working on a Relational Database Management System (RDBMS), our maximum time is spent on handling data in tables mainly because RDBMS stores data in database object called tables. In simple words we can say that tables are just a collection of unique Rows and Columns. Where every single row is called tuple and every single column is known as attribute of the table.
Every Single Row --> Tuple
Every Single Column --> Attribute
Every column as well as row should be unique.
In the above syntax CREATE TABLE is an oracle keyword and table and column names are user defined.
With oracle we have a maximum limit of 1000 columns in a table but there is no limit whatsoever on the number of rows. This means you can put unlimited rows in your table.
There are a few rules which we have to follow while naming a table or columns of the table.
These rules are as follows:
Table names and column names:
There are 3 different ways for creating a table.
Let's explore each of them in the upcoming blogs & video tutorials. Hope you found this article useful. Do make sure to share it with others. Thanks & have a great day!
You can DOWNLOAD SQL script and presentation used in the Video and in this article.