Oracle Database11g tutorials 14
How to Create table using command prompt and Create table using sql developer
Blog Link http://bit.ly/1TkY4Oe
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
Oracle Database tutorials 4: database connectivity using SQL developer and command prompt
You can have indepth knowledge about SQL create table here
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
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.
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.
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.
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.
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:-
CREATE TABLE table1<
ERROR AT LINE 1:
ORA-00922: MISSING OR INVALID OPTION
PLEASE HELP ME TO SOLVE THIS
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(
Hope this will solve your problem. if not then shoot me a message on my facebook
Thanks and have a great day.
hiii manish i am searching for "HOW TO CREATE DATABASE IN ORACLE 11G WITH SQL DEVELOPER ANS COMMAND PROMPT",IF YOU CAN UPLOAD ANY VIDEO IN COMING 2 DAYS. I WILL BE VERY THANK FULL TO YOU.
I NEED THIS VERY URGENTLY.............PLZZ
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?
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.
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.
@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
Whenever I install oracle, and developer I have following problem after certain time.
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ORA-12560: TNS:protocol adapter error
Enter user-name: hr
ORA-12560: TNS:protocol adapter error
and sometimes ORA-01031 trouble for HR user. Could you help me with this?
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.
@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.
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?
skinny blond cumshot black ashlyn gere tease peter north canyon african classic full movies sex an interracial nude beaches bukkake announcer busty wife next door quarrel husband out house naked part1 strip in fitgh lachelle marie gets slammed hard inthevip too big for hard core porn boy molested boy older brother incest gay video smoking mature nudist mum shows son junior idol 3some father and a dought cojiendo con panocha peluda brunette wife bigtits adultery housewive cheat turkish super mom romantic first veronica carso lesbian redbone deleted sex tape from facebook katrina kaif fake sex mi japanese mom son pale gandimasticom 3gp marathi celebrity school n ht femdom wife makes husband swallow forced bi bodystocking worship joi it4 japanese lesbi xhamster 3gp anal fuck compilation extra nasty kross two ripe cock arrimon en tren ava devine fucks sons friend cristina cristol philippines 1980s movies metro blonde buster 02 scene 4 uncensored japanese family orgy trample spit fanny gareau cuck under very young teenie swallows old handsome guy with sexy women goyang seksi tkw arab bastard forced german very indian secretary creampie super sexy brunette sucking cock and getting fucked hard das erste mal mit dildo first dildo sev beni seri 2 lesbian teacher stockings german double penetracion sofa
dad fuck daugther after boyfriend japanese yukino akari finger orgasm group slave drinks his own pee curly girl fucks dildo on coffee table moms dogs xxx 8883 terrazas ebony slut gets bent over and fucked 16years boy in women 35 years indian tamil indiana jayabharathi 102765 esperanza gomez creamed compilati mature daughter blow job in the car perverted french mom creampie young man handcuffed and forced by wife to suck cock mom en son creampie prostate miliing hardcore fuck my niece japanese mo son sex ed nice looking dirty wife used infrount of husband 2 busty natasha bangla xxx video in burdwan dist indian dayna mite indian women caught shitting on wwwyoutubecom wellhung handsome czech boys porn videos rompi el culo awek dikeroyok indonesia pelajar tayang dalam kelas 6gwy kj gay cheesy cock big black bikini dance rescue mission birmingham indian interacial ebony light skin lesbian setapes porn vera 2168 granny fucks young cock cock insest father wake straight video 1289474 shreya ghoshal xxx son tucker mom ebony oil fukc in vagima 2 guys cream pie septa cubka masha mom cam sophie moone golden showers first time alison part9 saney lein sex frends mom bdsm sheena ryder blowjob mum seduce son with short skirt amateur milf lesbian first time black hair homemade big tits yuki manaka in a threesome www.livepomo899.com dad goes in his daughters bedroom and shows them his 18 inch dick it makes him cry when he tells him he going to f him up the ass for the first time e rape by an entire crowd beena auntony nud boobs horny asian brunette spreads cum all over ameture cd dildo solo chinese rape yube indian gang rape telugu black girl fuck her dad indian waterfall fuck 27min sie schaut ihm beim onanieren zu dad forces son to have sex with him asian amateur white novia comiendo 43old japan homemade chubby big tit teenr webcam 3gpbangla b.bariear xvideos japanese 18 year girl open sex tight cameron video propio miren como se le sale la leche a mi esposa black nylon footjob under table from a teen girl footjob broken huge cock exposed shraddha kapoor sex leg affair demi delia cool black black 1993 black dirty debutantes 1 sasha dawn download red sex videos in africa allboy 19 examined boy celebrity jewel shepard nude tits and explicit sex barbie mae webcam cuckold bbw wife italian drunk son gets mom pregnant piledriver angle of teen roughly fucked by a cock that pounds her deep bisexual mmf gays get nasty ebony teens cum in mouth fat vs slim gfgirlfriend finger 3d mini series budak umoq 16 nakal gay scally lads orgy lesbian dildo fucking in kitchen demolition woman pt 1 yes touch me erotik expo budak asrama mandi indian foot fetish.. yummy feet lapdance bikini heyzo 0007 abella anderson longporn cewek ngangka shocked in chatroulette hanjob step sister mother kat denning daydream nature dungeon sm session indian actress dipaka xxx video www1619285sexy booby big nipples desi in mic red tits massage painfule forced nia d papa japanese old uncensored with english subs male prostate stimulation and fucking girl masturbates in tim hortons sleeping rape movies hot pussyjob mena li katt milf machure homemade harvore thresome said latinas from chicago download awek melayu tudung nenitas de quinse anios porno anal natalia di angelo chinese couple bbc grandfather big boobs kq uy wife and her female date facialized hubby holo man sex hollywood mother wrestle son the fucks him indian wife sex audio video diaper egg groom in law tribadism japan sister begs brother sex bbc gag gurl straight video 707556 japan model girl job hidden cam japanese av public nudity walking man on leash subtitled japaneses grand mother jerking solo 5 brazil fun clip quay len boy gaythu dam fist time bisexual guy.