How to Create a Table using SQL on Oracle SQL Developer | Make Table in SQL in Hindi

Published: 12 May 2022
on channel: Versatile Studio Max

284

How to Create a Table using SQL on Oracle SQL Developer

In this video I am showing how to create table in sql. So watch this video till the end for making how to create table in sql server. You can also create table in MySQL

Follow these steps to create a table in Oracle SQL Developer.

1. Open Oracle SQL Developer.
2. Connect to the Database.
3. On the left side, click on the schema name to expand the node.
4. Then select Table node and do the right click on it.
5. Select the New Table option from the shortcut menu to create a table.
6. A Create Table window will appear, as shown in the below example.
7. In the Create Table window, first, select the Advance checkbox at the right to show all options for the table on the left side of the window.
8. Then select the schema from the Schema drop-down list, by default it is showing the current schema.
9. Specify the table name in the Name field. As shown in the above image.
10. Choose the table type from the table type drop-down list.
11. Then start by specifying columns for the table in the Column section of the window.
12. Click on the PK column if you want to make the primary key column. Then specify the column name, its data type, and length, the column can be nullable or not and the default value if any for the column.
13. Repeat the action for every new column and after completing the column creation, click on the OK button to create the table. You can also use other options in this window, such as Constraints, Indexes, and Partitions as per your table requirement.

You have now created a new table using Oracle SQL Developer.

Your Query:
How to create a table in sql
How to create a table in MySQL
How to Create table in sql developer
How to create table in oracle sql sever
Create table in sql developer
How to create a table in sql
oracle sql developer
SQL create table

Disclaimer:
Copyright Disclaimer under section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, education and research.

On this page of the site you can watch the video online How to Create a Table using SQL on Oracle SQL Developer | Make Table in SQL in Hindi with a duration of hours minute second in good quality, which was uploaded by the user Versatile Studio Max 12 May 2022, share the link with friends and acquaintances, this video has already been watched 284 times on youtube and it was liked by 19 viewers. Enjoy your viewing!

287