HomeОбразованиеRelated VideosMore From: Manish Sharma

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

515 ratings | 194486 views
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A 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 help 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 videos 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. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets 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 explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways 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 your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Html code for embedding videos on your blog
Text Comments (41)
Vicky Patekar (4 months ago)
Hi Manish Sir, what is Username and Password hr/hr which Username and Password it is?
Haritha Chennareddy (7 months ago)
Hi manish sir, i am getting an error in sql developer like insufficient privileges ,WHILE CREATING A TABLE PLEASE HELP ME SIR
Nanda Kishore (7 months ago)
Hi Manish, After creating connection, In the drop down I am not able to see the tables and views in that particular connection. I have tried to create multiple connections but same problem. Please help me out.
Supragya Raturi (11 months ago)
This should have been first video
Avichal Ambar (1 year ago)
Hi manish sir,Thank you for all those videos i have learn very much. by creating table in cmd with same syntax i am getting error:- CODE>> CREATE TABLE table1< t_id NUMBER<5>, f_name VARCHAR2<10> >; eRROR>> ERROR AT LINE 1: ORA-00922: MISSING OR INVALID OPTION PLEASE HELP ME TO SOLVE THIS
Manish Sharma (1 year ago)
Hey Avichal. first of all, you are doing a great job. The code is perfect except the brackets with DDL statements we use parenthesis, not the angled brackets which you have used. So try replacing < > from ( ). Like this CREATE TABLE table1( t_id NUMBER(5), f_name VARCHAR2(10) ); Hope this will solve your problem. if not then shoot me a message on my facebook https://www.facebook.com/TheRebellionRider/ Thanks and have a great day.
Prathmesh Sawant (1 year ago)
Hi Manish, I am getting error while installing oracle, will you help me
PAWAN OfficialMail (1 year ago)
Thanks Sir
abdul majeed (1 year ago)
What's SID Means in ORACLE_SID
divya namdev (2 years ago)
what is CLOB and BLOB ?
pratik sharma (2 years ago)
good work.
medo bash (2 years ago)
thank you boss
Tarique Islam (2 years ago)
Manish, This is good stuff..It is great..Thanks for your effort! Helped me learn this fast!
Vijaysimha Kulkarni (2 years ago)
Hi Manish how to display the names of employees who are working in a company for the past few years in Oracle sql developer
Yvn Reddyy (2 years ago)
very useful thank you
ruchir sohani (2 years ago)
phong le (2 years ago)
Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection?
EarnFree 4gLTE (2 years ago)
How do you add a new name where HR is? For example I am trying to name my data base MEC, before I start my table.Also, am I able to create the table in GUI and copy it to the  command prompt? My school is asking for me to create a database on their connection to MySQL  but they are not set up for me to use the GUI and I want to use the GUI that's why I asked is there a way to copy from the GUI to the command prompt of my school?
syed rizu (2 years ago)
hi please help me to create a trigger that should not insert any dml after 6 pm and inform the user that dml operations cannot be done after 6 o clock.. can any one help me to create this?
dj & pj (2 years ago)
When connecting to Oracle I got this ORA-00020 error ERROR: ORA-00020: maximum number of processes (150) exceeded
Chethan Prabhu (2 years ago)
hello im using oracle 9i....are the syntax and functions same as oracle 11g
Marri Sreejith Reddy (2 years ago)
sir, where are the rest sql function videos? @manish
Source!!! (2 years ago)
Where do we go an get the schema HR? I can't find it as part of Oracle SQL Developer 11g.
Pervez Ansari (3 years ago)
You tutorials are really awesome, you rock buddy:-)
Soumya Biswas (3 years ago)
hi manish.. i have downloaded oracle 11 g database. after installation there are two options: 1>start database, 2>sql command line.. when i am trying to create a database, it is showing message "Not connected".. Please suggest me about the configuration and connection to the database.
Hiroshi Perera (4 years ago)
Hi Maish, In Oracle SQL Developer you have used HR to create the table. But what happens if I select SYSTEM and does the same. Is it too ok. What are the difference between these different roles?
Rafiqul Islam (2 years ago)
ORA-01017:invalid username/password,logon denied showing. I don't use LAN,so kindly suggest me how to create sys user connection. Btw u r really doing well for we learner,u have a clear voice and good presentation skill.good luck.
Manish Sharma (4 years ago)
@Hiroshi Perera Greate Question, For making a new connection using sys user I would suggest you to check out this article http://bit.ly/how-to-create-new-connection-in-sql-developer on my website where I explained the correct step by step process of making a new SQL Developer connection using SYS user. Hope you will find it useful, if so then please share it with your friends also don;t forget to LIKE, SHARE & SUBSCRIBE thanks
mmt2k9 (4 years ago)
Hi Manish, Whenever I install oracle, and developer I have following problem after certain time. Copyright (c) 1982, 2010, Oracle.  All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: hr Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: and sometimes ORA-01031 trouble for HR user. Could you help me with this?
Source!!! (2 years ago)
Yeah I'm having that problem too. I wish the lecture was more basic and avoided having to troubleshoot the problem.
mmt2k9 (4 years ago)
@Manish Sharma Thanks Manish, yesterday I installed Oracle and today when I tried to run Developer to connect with using HR I got "Status: Failure -Test Failed: ORA-01031:Insufficient privileges" This happened third time.
Manish Sharma (4 years ago)
@mmt2k9 Try this Open your command prompt with administrative privileges and write " net start OracleServiceORCL " and try connecting again. Plus you can also check other service of your oracle database and start them if not running. Read this http://bit.ly/why-windows-startup-get-slow-on-installing-oracle blog may be it will help you.
ayo ola (4 years ago)
i tried creating a table using subqueries from two tables but i ended up creating a table with catesian data ( an employee can have upto 20 rows in this table) so is there a way to create this tablesfrom two different table without it giving me a cartesian product?
jyothi kiran (4 years ago)
hi manish how  to insert data table using sql developer
please try to upload the function series soon....you r great ......
boris andonov (4 years ago)
Manish Rulezz...! :)
tmitchable (4 years ago)
i have question, why can u use select to retrieve the dbase table instead u use desc ?
Haider Ali (4 years ago)
ahsanul haque (5 years ago)
thanks MANISH BHAI.........................please quickly continue next
ahsanul haque (5 years ago)
Manish Sharma (5 years ago)
Thanks for the appreciation. I'll be uploading next video very soon.  And yes don't forget to like, comment and Share :-)  

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.