In this video you will learn about Check Constraint in Oracle. A check constraint allows you to specify a condition on each row in a table. In other word, CHECK constraint is used to limit the value range that can be placed in a column. If you define a CHECK constraint on a single column it allows only certain values for this column. If you define a CHECK constraint on a table it can limit the values in certain columns based on values in other columns in the row.
For Support
===========
Email: [email protected]
Contact Form: http://www.learninhindi.com/home/contact
Our Social Media
================
Facebook: https://www.facebook.com/LearnInHindi
Twitter: https://twitter.com/LearnInHindi
For Training & Videos
=====================
For more videos and articles visit:
http://www.learninhindi.com
Free Java Programming In Hindi Course
=====================================
https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH
Free Oracle PL/SQL Programming In Hindi Course
==============================================
https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6
Free C Programming In Hindi Course
==================================
https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq
Trips & Tricks Channel
======================
https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw
Programming in Hindi Channel
============================
https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ

Constraint In Oracle PL SQL
oracle tutorial for beginners
A) UNIQUE CONSTRAINT :
A unique constraint is uniquely defines a record.
Its value is not repeated.
It can be null.
B)NOT NULL CONSTRAINT:
Not null constraint restrict from inserting null values.
If we want some columns does not take null values then we can use this constraint.
C)CHECK CONSTRAINT:
A check constraint allows you to specify a condition on particular column in a table.
we can add our custom logical conditions.
CREATE TABLE TEST2
(
ID VARCHAR2(10) UNIQUE,
NAME VARCHAR2(50),
DEPT VARCHAR2(10) NOT NULL,
AGE NUMBER(10),
CHECK (AGE BETWEEN 18 and 60)
);
#techquerypond
https://techquerypond.wordpress.com
https://techquerypond.com https://twitter.com/techquerypond

Subscribe to IT PORT : https://www.youtube.com/c/itport28
SQL Server Tutorial in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64enJDwWVvN3KduuZRlUrb3
SQL Server Concepts in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ67kdNIByJKAGBIBhor_h4Hs
SQL Server Analytic Functions in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ65XIU5azEUgLVrBKEl-jWMV
SQL Server Tutorial : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66AYrzPtxt2SeeR4UABcBcO
SQL Server Concepts : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66zRe8-nDDy-YHY2o0rmbn4
SQL Server Analytic Functions : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64hTsEdhLsVBquE1vERWngX
CHECK constraint is used to set limit range that can be placed in a column. If we define one check constraint on a single column it allows only certain values and doesn’t allow all values. We can make check constraint with Single Or Multiple columns on that table.

How to use Check Constraint in Oracle or what is Constraints and Types of Constraints in an Oracle SQL Database | integrity Constraints in SQL. Check Constraint is nothing but it allows you to specify a condition on each row in the table
Explaining constraints and types of constraints in Oracle or Constraints in Oracle SQL database or Constraints is nothing but a set of rules which is applied to the columns of any table in the database
------------------------------------
Assignment link :
-----------------------------------
https://drive.google.com/open?id=1uQBEYQ0e9Wszk5BIigz4CJ7ow4aPKL4B
In this series we cover the following topics:
SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator.
follow me on:
Facebook Page:
https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks
Contacts Email:
[email protected]
Instagram:
https://www.instagram.com/equalconnect/
Twitter:
https://twitter.com/LrnWthR

In this video you will learn about Unique Constraint in Oracle. The UNIQUE constraint uniquely identifies each record in a database table. The UNIQUE and PRIMARY KEY constraints both provide a guarantee for uniqueness for a column or set of columns. A PRIMARY KEY constraint automatically has a UNIQUE constraint defined on it. Note that you can have many UNIQUE constraints per table, but only one PRIMARY KEY constraint per table.
For Support
===========
Email: [email protected]
Contact Form: http://www.learninhindi.com/home/contact
Our Social Media
================
Facebook: https://www.facebook.com/LearnInHindi
Twitter: https://twitter.com/LearnInHindi
For Training & Videos
=====================
For more videos and articles visit:
http://www.learninhindi.com
Free Java Programming In Hindi Course
=====================================
https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH
Free Oracle PL/SQL Programming In Hindi Course
==============================================
https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6
Free C Programming In Hindi Course
==================================
https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq
Trips & Tricks Channel
======================
https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw
Programming in Hindi Channel
============================
https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ

Learn how to tune SQL with Constraints! In this lesson (4 of 5), OCM John Watson from SkillBuilders demonstrates how to improve query performance by adding not null constraints.
See all lessons, free at http://www.skillbuilders.com/oracle-database-sql-tuning-with-constraints.

In this video you will learn about Referential Integrity in Oracle. You will learn how to create Primary Key and Foreign Key. There will be Foreign Key in the child table that will reference Primary Key in master/parent table. You will also learn how to delete all the records from child table when related record is parent/master table is deleted. If you try to insert any record which is not available in master/parent table child table will ignore insert command.
For Support
===========
Email: [email protected]
Contact Form: http://www.learninhindi.com/home/contact
Our Social Media
================
Facebook: https://www.facebook.com/LearnInHindi
Twitter: https://twitter.com/LearnInHindi
For Training & Videos
=====================
For more videos and articles visit:
http://www.learninhindi.com
Free Java Programming In Hindi Course
=====================================
https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH
Free Oracle PL/SQL Programming In Hindi Course
==============================================
https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6
Free C Programming In Hindi Course
==================================
https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq
Trips & Tricks Channel
======================
https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw
Programming in Hindi Channel
============================
https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ

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

In the previous video we set up an entire table. The problem with this table is that the species column is just plain text. The problem with this is that there is a higher probability of incorrect data and if we have tons of animals in here there will be a lot of redundant information. The solution to this is to change this species to a foreign key to another table.
Remember that when you create a foreign key it is a child to a parent. The thing you need to know is that the parent has to exist before the child so the child has something to reference.
So let's create the parent table.
CREATE TABLE Species(
ID INT PRIMARY KEY IDENTITY,
Species VARCHAR(50) NOT NULL UNIQUE,
FriendlyName VARCHAR(50) NOT NULL //NOT UNIQUE because multiple rows could be same category (Ex: Bunny)
);
Now, the friendly name will likely have redundant data, so maybe later we can add a table for animal categories or something, but let's not overwhelm ourselves quite yet. Maybe in a few videos.
Now that we have created that table, we can recreate the table that references it. The first thing to know when creating a foreign key is that the data type must match. Because the ID column in the species table is of type INT, we should make our Species column in the Animals table also of type INT. Secondly, to make this a foreign key we add REFERENCES Species(ID) to the Species column.
DROP TABLE IF EXISTS Animals;
CREATE TABLE Animals(
ID INT PRIMARY KEY IDENTITY,
Name VARCHAR(50) NOT NULL,
Species INT NOT NULL REFERENCES Species(ID),
ContactEmail VARCHAR(50) NOT NULL UNIQUE
);
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Support me! http://www.patreon.com/calebcurry
Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter
Donate!: http://bit.ly/DonateCTVM2.
~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~
More content: http://CalebCurry.com
Facebook: http://www.facebook.com/CalebTheVideoMaker
Google+: https://plus.google.com/+CalebTheVideoMaker2
Twitter: http://twitter.com/calebCurry
Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)

Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials.
Learn Oracle 10g Tutorial series contains the following videos :
Learn Oracle - History of Oracle
Learn Oracle - What is Oracle - Why do we need Oracle
Learn Oracle - What is a Database
Learn Oracle - What is Grid Computing
Learn Oracle - What is Normalization
Learn Oracle - What is ORDBMS
Learn Oracle - What is RDBMS
Learn Oracle - Alias Names, Concatenation, Distinct Keyword
Learn Oracle - Controlling and Managing User Access (Data Control Language)
Learn Oracle - Introduction to SQL
Learn Oracle - Oracle 10g New Data Types
Learn Oracle - How to Alter a Table using SQL
Learn Oracle - How to Create a Package in PL SQL
Learn Oracle - How to Create a Report in SQL Plus
Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key
Learn Oracle - How to Create a Table using SQL
Learn Oracle - How to Create a Trigger in PL SQL
Learn Oracle - How to Delete Data from a Table using SQL
Learn Oracle - How to Drop and Truncate a Table using SQL
Learn Oracle - How to Insert Data in a Table using SQL
Learn Oracle - How to open ISQL Plus for the first time
Learn Oracle - How to Open SQL Plus for the First Time
Learn Oracle - How to Update a Table using SQL
Learn Oracle - How to use Aggregate Functions in SQL
Learn Oracle - How to use Functions in PL SQL
Learn Oracle - How to use Group By, Having Clause in SQL
Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL
Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL
Learn Oracle - How to use the Character Functions, Date Functions in SQL
Learn Oracle - How to use the Merge Statement in SQL
Learn Oracle - How to use the ORDER BY Clause with the Select Statement
Learn Oracle - How to use the SELECT Statement
Learn Oracle - How to use the Transactional Control Statements in SQL
Learn Oracle - How to use PL SQL
Learn Oracle - Data Types in PL SQL
Learn Oracle - Exception Handling in PL SQL
Learn Oracle - PL SQL Conditional Logics
Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor
Learn Oracle - PL SQL Loops
Learn Oracle - Procedure Creation in PL SQL
Learn Oracle - Select Statement with WHERE Cause
Learn Oracle - SQL Operators and their Precedence
Learn Oracle - Using Case Function, Decode Function in SQL
Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement
Learn Oracle - Using Rollup Function, Cube Function
Learn Oracle - Using Set Operators in SQL
Learn Oracle - What are the Different SQL Data Types
Learn Oracle - What are the different types of Databases
Visit Pebbles Official Website - http://www.pebbles.in
Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1
Engage with us on Facebook at https://www.facebook.com/PebblesChennai
Please Like, Share, Comment & Subscribe

Subscribe to IT PORT : https://www.youtube.com/c/itport28
SQL Server Tutorial in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64enJDwWVvN3KduuZRlUrb3
SQL Server Concepts in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ67kdNIByJKAGBIBhor_h4Hs
SQL Server Analytic Functions in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ65XIU5azEUgLVrBKEl-jWMV
SQL Server Tutorial : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66AYrzPtxt2SeeR4UABcBcO
SQL Server Concepts : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66zRe8-nDDy-YHY2o0rmbn4
SQL Server Analytic Functions : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64hTsEdhLsVBquE1vERWngX
A foreign key (FK) is a column or combination of columns that is used to establish and enforce a link between the data in two tables. You can create a foreign key by defining a FOREIGN KEY constraint when you create or modify a table.
In a foreign key reference, a link is created between two tables when the column or columns that hold the primary key value for one table are referenced by the column or columns in another table. This column becomes a foreign key in the second table. A table can have 253 foreign key constraints.

In this video you will learn about Column Formatting. I will show you how we can format the numeric column to use comma (,) to separate thousand etc. I will also show you how we can trunc string to show first 3 words etc.
For Support
===========
Email: [email protected]
Contact Form: http://www.learninhindi.com/home/contact
Our Social Media
================
Facebook: https://www.facebook.com/LearnInHindi
Twitter: https://twitter.com/LearnInHindi
For Training & Videos
=====================
For more videos and articles visit:
http://www.learninhindi.com
Free Java Programming In Hindi Course
=====================================
https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH
Free Oracle PL/SQL Programming In Hindi Course
==============================================
https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6
Free C Programming In Hindi Course
==================================
https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq
Trips & Tricks Channel
======================
https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw
Programming in Hindi Channel
============================
https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ

In this video we will learn about
What are indexes
Why do we use indexes
Advantages of indexes
These concepts are applicable to sql server 2000, 2005 and 2008
Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/09/indexes-in-sql-server-part-35.html
Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-35-indexes.html
All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html
All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html
All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd
All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

Subscribe to IT PORT : https://www.youtube.com/c/itport28
SQL Server Tutorial in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64enJDwWVvN3KduuZRlUrb3
SQL Server Concepts in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ67kdNIByJKAGBIBhor_h4Hs
SQL Server Analytic Functions in Tamil : https://www.youtube.com/playlist?list=PLouAaeZ4xQ65XIU5azEUgLVrBKEl-jWMV
SQL Server Tutorial : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66AYrzPtxt2SeeR4UABcBcO
SQL Server Concepts : https://www.youtube.com/playlist?list=PLouAaeZ4xQ66zRe8-nDDy-YHY2o0rmbn4
SQL Server Analytic Functions : https://www.youtube.com/playlist?list=PLouAaeZ4xQ64hTsEdhLsVBquE1vERWngX
A foreign key (FK) is a column or combination of columns that is used to establish and enforce a link between the data in two tables. You can create a foreign key by defining a FOREIGN KEY constraint when you create or modify a table.
In a foreign key reference, a link is created between two tables when the column or columns that hold the primary key value for one table are referenced by the column or columns in another table. This column becomes a foreign key in the second table. A table can have 253 foreign key constraints.
Explained in Tamil