how to create and drop table in oracle sql || oracle sql tutorial 11

in this video i will show you how to create table in oracle sql for more detail join our facebook group ,https://www.facebook.com/groups/242999206136244/

Oracle - SQL Table Basics
Create Table
The mechanics of creating a table are relatively straight forward. Being able to design a well thought out database that will scale to meet the needs of a large scale enterprise is a very challenging undertaking. In these examples we will be working through development of a fairly simple three table database. In doing so we will get to cover a good deal of the development basics for creating tables and indexes.

It is possible, though not advised to create a table without a primary key. I will discuss primary keys on a different page yet to be created. It is also possible to set initial default values for a column though none of the columns in our tables were suitable candidates to do this. There are many good primers on creating tables and databases. The purpose of this page is just to show the basic Oracle syntax by example for creating a table. Also, taking the create table for an existing table and using it as a model is also a very good practice and means of learning.


.----------------------------------------------------------------------------------------------------------.
video courses- list of playlist :

tips and trics
link► https://www.youtube.com/playlist?list=PLOfLYVXrwqXrI5jvwUEi6N13QR4xCj2k2

command prompt commands:
link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXobXGUdGk6JhzyQ216dNiQL

oracle sql:
link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXqoUWCoh4cARGDW13SofDO-

c programming:
link►https://www.youtube.com/playlist?list=PLOfLYVXrwqXrZ_Ub8EXeLY7YP1YxhoJzf

.-----------------------------------------------------------------------------------------------------------.
watch more videos:

learn oracle sql online overview tutorail :
https://www.youtube.com/watch?v=Dfesgj4w8QA&t=8s

how to fix or repair a corrupted usb flash drive or cd card using command prompt:
https://www.youtube.com/edit?video_id...

how to copy a folder using cmd:
https://www.youtube.com/watch?v=Lblhb...

how to move a folder using cmd:
https://www.youtube.com/watch?v=YFfHZ...

how to dell files in cmd:
https://www.youtube.com/watch?v=3-lqg...


how to make and remove directory:
https://www.youtube.com/edit?video_id...

how to change color and title in cmd:
https://www.youtube.com/edit?video_id...

how to change directory in command prompt:
https://www.youtube.com/watch?v=SmLYx...
.-----------------------------------------------------------------------------------------------------------.
social media links:
join our group:
► https://www.facebook.com/groups/24299...

► Follow on Google+: http://[email protected]

► Follow on Twitter: https://twitter.com/@rananavi4766669 :