Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt

what's up internet this is Manish from rebellionrider.com today in this Oracle database tutorial we will see how to create a table I'm doing this video on popular demand so sorry for interrupting SQL function series we will be continuing with SQL function series after these SQL create table videos okay let's start with a brief intro about SQL table and SQL create table if we have to define a table in Layman language then we can say that tables are just a collection of rows and columns but in rdbms tables are database objects which helps in organizing data into rows and columns we can also say that SQL tables are kind of data structure which are used by database for efficient storage of data to create a table in our database we use SQL create table command SQL create table is a type of data definition language also known as ddl to create a table in your schema you will require create table system privilege in our future video we will see what are system and object Privileges and how to grant them to a user today for this video we will be using sample schema HR which already has all the necessary privileges okay let's see the syntax create table is an oracle reserved word or say an oracle keyword whereas table name and column name are user defined so you can specify whatever name you want to your table and its columns every column should separate from each other using commas Oracle has maximum limit of 1,000 columns in a table and no limits on rows there are three different ways of creating a table in Oracle database let's check them out first creating a table using command line interface in Oracle database for demonstrating how to create a table in Oracle database using CLI command line interface I will be using command prompt if you are working on a Linux machine then you can use terminal steps are same in both okay right now I am on my command prompt first of all we have to set the S ID of our database over which we want to work I have only one database with Sid orcl so now connect to the schema in which you want to create a table I will create a table in HR sample schema so I'm going to connect it with HR so now we are in our SQL prom let's apply our create table syntax I am creating a table by the name of table one this table has two columns T1 ID and first name you can add as many column as you want create table is the keyword and our command also table one is a user defined name for the table you can give whatever name you want start the parenthesis now give your First Column name I will give T1 ID along with the data type I will specify number sorry and the size which is optional if you want to give you can specify this size if you do not want to give then it's okay then comma don't forget to put this comma Now second column name my second column will be for name this is the second and the last column for this table where 2 and this time I will give 15 as it's the last column for my table so it's not mandatory to put the comma close the parenthesis and Terminator and hit enter that's how we create table using command prompt you can check your table structure by describe command for that just write DC and your table name like this DC C sorry and the table name which is table one sorry table one hit enter as you can see we created a table with two column T1 ID and first name here we have T1 ID and first name with the data type number and where 2 and the size three and 15 another way of creating a table is by using graphic user interface GUI in Oracle database to demonstrate how to create data table using GUI we will use SQL Developer let's open our SQL Developer I am connected to HR schema if you do not know how to create a connection to database using SQL Developer please watch my Oracle database tutorial 4 that explain database connectivity using SQL Developer and command prompt link for this video is in the description blow so let's create a table creating a table using SQL Developer is very easy we do not have to fire a single cury here let's start first of all right click on the connection and choose schema browser this will open a separate schema browser pen or you can expand your connection by clicking this plus button and then right click on table and choose new table however I prefer working with the schema browser so let's skip to schema browser pen here from the first drop- down list you can choose connection name and in the second drop- down list you can choose what database object you want to work with we want to create a table thus I will choose table and click this [Music] Arrow here and choose option for new table okay we are in a create table visard first of all give a unique name to your table and add some columns as well for this click this green plus button now give it a name I will give it T2 ID and specify data type I'll go with number and you can give size here I'll give three you can check this n column if in case you want to make this a mandatory column you can also specify default value and constant if you want to make this column a primary key you can click here in my future video I will show you what are these constants and different way of applying them on a column in a table for this video we will concentrate on create table only so when you are done with all these column let me add one more column and this time I will give a name T2 name where care okay and this time I will give it a size 30 okay just okay so when you are done with all your column click [Music] okay that's your table you can double click on your table name here and can see it's a structure this is our table that's it in my next video I will show you a third way of creating table using Enterprise Manager watch out for my soon to be uploaded next video on how to create table using Enterprise Manager you can visit my website ww. rebellionrider.com for the in-depth knowledge of SQL create table also you can download all the resources used in this video such as presentation and the script from here for that just scroll down a little bit and here are the links that's it for today thanks for watching this is Manish from Rebellion rider.com