http://bit.ly/oracle-sql-course | Get the complete course today.
Learn Oracle SQL : The Hierarchical Query Clause: In this video, I show you how to use the Hierarchical Query Clause in Oracle SQL to build a basic hierarchical query.
This is an excerpt of the course "The Ultimate Oracle SQL Course" which you can get at a heavily discounted price here: http://bit.ly/oracle-sql-course
================
You can find additional Oracle SQL related articles and educational content in my blog here: http://standout-dev.com/
Views: 7702
Oracle SQL
This video demonstrates one of the ways to query hierarchical data from Oracle.
For more information see:
https://oracle-base.com/articles/misc/hierarchical-queries
Website: https://oracle-base.com
Blog: https://oracle-base.com/blog
Twitter: https://twitter.com/oraclebase
Cameo by Arjen Visser
Blog: http://blog.dbvisit.com/
Twitter: https://twitter.com/dbvisit
Website: http://www.dbvisit.com/
Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 27524
ORACLE-BASE.com
Oracle - SQL - Insert Statement
Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm
Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
Views: 7391
Tutorials Point (India) Pvt. Ltd.
Blog Link: http://bit.ly/how-to-create-new-connection-in-sql-developer
Wishlist: http://bit.ly/wishlist-amazon
This SQL tutorial and Oracle database 11g tutorial for beginners will show how to connect to database either on a local machine or on a machine in your LAN using ip address.
Tool used in this tutorial is SQL developer & 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
Email
[email protected]
Twitter
https://twitter.com/rebellionrider
Instagram
http://instagram.com/RebellionRider
Facebook.
https://www.facebook.com/imthebhardwaj
Linkedin.
in.linkedin.com/in/mannbhardwaj/
Thanks for linking, commenting, sharing and watching more of our videos
The Code makers
Views: 278770
Manish Sharma
SQL tutorial for beginners in hindi and english
SQL Select Statement on Oracle 11g Database with Example
Views: 78875
Easy Engineering Classes
Oracle tutorial: How to connect oracle database using sqlplus command line
sqlplus tools to connect to oracle database
In this tutorial you can see using SQLPLUS commands how we can connect the oracle database .
After connecting the oracle database you can able execute the sql query.
oracleconnection oracle sqlplus connect to database
Views: 19040
Tech Query Pond
This screencast introduces table joins, including differences between SQL 89 and SQL 92 join syntax. The various join types such as natural (inner) joins and left/right/full outer joins, and cross joins.
Views: 147279
Michael Fudge
In this tutorial we'll take a look at SQL JOINS and see how we can pull data from two tables through a single query!
Views: 100550
The Bad Tutorials
Video from our Oracle SQL course. Check out the full course at..
http://learn.hackpress.co/courses/oracle-sql-learning-by-example
Views: 44949
etldeveloper
Connect SQL Server To Oracle http://www.ReportingGuru.com
This video shows how to connect SQL Server to Oracle with Linked Servers. Email us at [email protected] if you need help, custom reports, or reporting architecture setup. Our phone number is 1-(800) 921-4759
Reporting Guru is a US based development company with all resources located in the US. We have many senior level developers with over a decade of development experience.
We offer the following services:
Custom Report Writing | Consulting | Database Development & Integration.
Some of our specialties are:
--SQL Server Reporting Services SSRS / SQL Server / SQL Server Integration
--Services SSIS / SQL Server Analysis Services SSAS
--Custom Application Development / Maintenance
--Oracle
--MySQL
--Crystal Reports / Business Objects
--BIRT
--.NET Development
--PHP Development
--SharePoint
--Microsoft Dynamics
--Access
--Excel and Pivot Tables
--More!
CUSTOM REPORT WRITING
Our experienced data report writers take your report & business requirements to build the custom reports you need. We deliver reports on demand or on a timed schedule.
CONSULTING
When your data and reporting team needs guidance or whether you need to build new reports, convert reports, enhance existing reports or need advice on finding the right reporting solution for your business ReportingGuru is here to help.
DATABASE DEVELOPMENT & INTEGRATION
We create and develop the necessary structure to house business data in a clear and easily accessible manner, so you have the tools to pull the reports you need easily.
CUSTOM SOFTWARE & APPS
We also offer custom applications for our clients like our Dashboard Guru and Quickbooks Enterprise Connector http://www.reportingguru.com/products/. Reporting Guru's dashboarding software will give interactivity to static web based reports. Our Quickbooks Connector will pull data from Quickbooks into a database for custom reporting purposes.
Please let us know if you would like to discuss your requirements or issues free of charge. Our process is taking your requirements and suggesting the best architecture or approach without trying to sell you any specific software. We work as needed and only charge for the hours we work. We do not charge a retainer and there is no minimum charge.
Connect SQL Server To Oracle http://www.ReportingGuru.com
Email us at [email protected] or call 1-(800) 921-4759.
Views: 52465
Reporting Guru
Oracle - SQL - Select Statement
Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm
Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
Views: 4702
Tutorials Point (India) Pvt. Ltd.
RebellionRider.com presents a PL/SQL tutorial on how to use the BULK COLLECT clause with SELECT INTO statement in Oracle Database by Manish Sharma. In this tutorial, you will also learn how to overcome the overhead caused by context switch and improve the query performance.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/bulk-collect-2
Previous Tutorial
►Introduction to Bulk Collect: https://youtu.be/CrJSlf_m3yA
►PL/SQL Tutorial 51-Nested Table: https://youtu.be/EUYyiFCzU0I
►Collection Method Count:https://youtu.be/NNq80CcC5K8
-------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
-------------------------------------------------------------------------
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
https://twitter.com/rebellionrider
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
___Facebook Official Page of Manish Sharma___
https://www.facebook.com/TheRebellionRider/
___Facebook Official Page of RebellionRider.com___
https://www.facebook.com/RebellionRider.official/
You can also Email me at
for E-mail address please check the About section
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 10855
Manish Sharma
Link for all dot net and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
Link for slides, code samples and text version of the video
http://csharp-video-tutorials.blogspot.com/2014/05/part-2-sql-query-to-get-organization.html
To get the best out of this video, the following concepts need to be understood first. These are already discussed in SQL Server Tutorial.
1. Self-Join - http://www.youtube.com/watch?v=qnYSN_7qwgg
2. CTE - http://www.youtube.com/watch?v=ZXB5b-7HJHk
3. Recursive CTE - http://www.youtube.com/watch?v=GGoV0wTMCg0
Here is the problem definition:
1. Employees table contains the following columns
a) EmployeeId,
b) EmployeeName
c) ManagerId
2. If an EmployeeId is passed, the query should list down the entire organization hierarchy i.e who is the manager of the EmployeeId passed and who is managers manager and so on till full hierarchy is listed.
For example,
Scenario 1: If we pass David's EmployeeId to the query, then it should display the organization hierarchy starting from David.
Scenario 2: If we pass Lara's EmployeeId to the query, then it should display the organization hierarchy starting from Lara.
We will be Employees table for this demo. SQL to create and populate Employees table with test data
Create table Employees
(
EmployeeID int primary key identity,
EmployeeName nvarchar(50),
ManagerID int foreign key references Employees(EmployeeID)
)
GO
Insert into Employees values ('John', NULL)
Insert into Employees values ('Mark', NULL)
Insert into Employees values ('Steve', NULL)
Insert into Employees values ('Tom', NULL)
Insert into Employees values ('Lara', NULL)
Insert into Employees values ('Simon', NULL)
Insert into Employees values ('David', NULL)
Insert into Employees values ('Ben', NULL)
Insert into Employees values ('Stacy', NULL)
Insert into Employees values ('Sam', NULL)
GO
Update Employees Set ManagerID = 8 Where EmployeeName IN ('Mark', 'Steve', 'Lara')
Update Employees Set ManagerID = 2 Where EmployeeName IN ('Stacy', 'Simon')
Update Employees Set ManagerID = 3 Where EmployeeName IN ('Tom')
Update Employees Set ManagerID = 5 Where EmployeeName IN ('John', 'Sam')
Update Employees Set ManagerID = 4 Where EmployeeName IN ('David')
GO
Here is the SQL that does the job
Declare @ID int ;
Set @ID = 7;
WITH EmployeeCTE AS
(
Select EmployeeId, EmployeeName, ManagerID
From Employees
Where EmployeeId = @ID
UNION ALL
Select Employees.EmployeeId , Employees.EmployeeName, Employees.ManagerID
From Employees
JOIN EmployeeCTE
ON Employees.EmployeeId = EmployeeCTE.ManagerID
)
Select E1.EmployeeName, ISNULL(E2.EmployeeName, 'No Boss') as ManagerName
From EmployeeCTE E1
LEFT Join EmployeeCTE E2
ON E1.ManagerID = E2.EmployeeId
Views: 285125
kudvenkat
Learn how to create SQL Joins. The first 10 minutes teach you the basics. Inner Join, Left Outer Join, Right Outer Join, and Full Outer Join. The second 10 minutes show you are few techniques that will help you as you start building joins.
READ THE ORIGINAL ARTICLE WITH THE TABLE SCRIPS
http://www.sqltrainingonline.com/sql-joins-tutorial-for-beginners/
YOUTUBE NEWS UPDATES
http://www.youtube.com/user/sqltrainingonline
VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS
http://www.sqltrainingonline.com
SUBSCRIBE FOR OTHER SQL TIPS AND NEWS!
http://www.youtube.com/subscription_center?add_user=sqltrainingonline
SUBSCRIBE TO OUR EMAIL LIST!
http://www.sqltrainingonline.com
LET'S CONNECT!
Facebook: http://facebook.com/SQLTrainingOnline
Twitter: http://twitter.com/sql_by_joey
Linkedin: http://linkedin.com/in/joeyblue
SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 150698
Joey Blue
In this video you learn about what happens when you run a DDL ( data definition language) command in the Oracle Database.
Our Upcoming Online Course Schedule is available in the url below
https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0
Reach us at [email protected]
Views: 13686
Ramkumar Swaminathan
A simple example of recursion using SQL Server and Common Table Expressions (CTEs). Thanks to +Nikola Gujanicic for the request.
Views: 22640
Database by Doug
How to connect an Oracle Database to Microsoft Excel. https://www.elance.com/s/edtemb/
Views: 100848
i_marketing
Worked example of a SQL join involving more than two tables
Views: 43805
Brian Finnegan
Oracle 11g SQL tutorial (Exam 1Z0-051) for beginner / intermediate learners. We are a supplier of IT services to UK's leading Telecom and Financial organizations. This tutorial is presented by our LEAD ORACLE DBA with over 9 yrs of hands-on experience managing Oracle projects for companies such as Oracle Corp, AXA Insurance, Telefonica O2 etc.
*** Subscribe for notification on full course availability ***
Prev Video ( Introduction ) - http://www.youtube.com/watch?v=Ve4t_PuMaLc
SELECT STATEMENT
Covers the basic SELECT statement.
Views: 92083
Sahaey Edu
SQL Classes for Beginners in Hindi and English
SQL Insert Into Statement using Example on Oracle 11g Database
Views: 36143
Easy Engineering Classes
How to execute sql and Sqlplus commands from an external script
Views: 84945
jbleistein11
Learn how to connect to Oracle Database Cloud Service using Oracle SQL Developer
=================================
To improve the video quality, click the gear icon and set the Quality to
1080p/720p HD.
For more information, see http://www.oracle.com/goto/oll and http://docs.oracle.com
Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 7468
Oracle Learning Library
How to get Oracle SQL Developer to automatically format your query results to CSV, HTML, JSON, Insert statements, and more.
Views: 43907
Jeff Smith
for SAS online tutorials contact
email: [email protected]
SAS ACCESS to oracle database
Pre-requisite: prior knowledge of sas , libname , database
Views: 10590
Touche Bin
Learn how to connect HR and Sys User of Oracle database 12c With SQL Developer using TNS service. Connect HR user which is in pluggable database to SQL Developer
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog :
Previous Tutorial
► Tut 61: How To Unlock HR schema in Oracle Database 12c
http://youtu.be/F81gfUnznZY
-------------------------------------------------------------------------
►►►Help Me In Getting A Job◄◄◄
►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company
Thanks
-------------------------------------------------------------------------
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage
https://copy.com?r=kb4rc1
--------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
--------------------------------------------------------------------------
Amazon Wishlist: http://bit.ly/wishlist-amazon
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
https://twitter.com/rebellionrider
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/rebellionrider/
You can also Email me at
[email protected]
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 54044
Manish Sharma
How to build queries with your mouse versus the keyboard.
2018 Update: If you'd like to see how to convert your Oracle style JOINS to ANSI style (in the FROM vs the WHERE clause) see this post
https://www.thatjeffsmith.com/archive/2018/10/query-builder-on-inline-views-and-ansi-joins/
Views: 73715
Jeff Smith
Using HAVING clause and difference with GROUP BY & WHERE clause in SQL statement
Link for scripts on my blog: https://sqlwithmanoj.com/2015/05/23/sql-basics-difference-between-where-group-by-and-having-clause/
Check the whole "SQL Server Basics" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv14f3cWDhubPaddxRvx1reKR
Check my SQL blog at: http://sqlwithmanoj.com/
Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 65755
SQL with Manoj
CURRENT OF clause in PL/SQL
Views: 11718
Naresh i Technologies
Oracle Tutorials for beginners: Add and Drop a Column using Alter Statement
Views: 45
Tech Acad
How To Setup and install SQL Developer on windows 7
This SQL tutorial and Oracle database 11g tutorial for beginners will show how to Setup and install SQL Developer.
YouTube Video on How to create database
http://bit.ly/create-database-using-DBCA
Oracle BLOG on SQL Developer
http://goo.gl/ej4ku7
Direct Link To Download SQL Developer
http://goo.gl/hfsjuY
Link for downloading Java JDK
http://goo.gl/kZ95rl
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage
https://copy.com?r=j7eYO7
Wishlist: http://bit.ly/wishlist-amazon
Contacts
Email
[email protected]
Twitter
https://twitter.com/rebellionrider
Instagram
http://instagram.com/RebellionRider
Facebook.
https://www.facebook.com/imthebhardwaj
Linkedin.
in.linkedin.com/in/mannbhardwaj/
Thanks for linking, commenting, sharing and watching more of our videos.
Views: 449602
Manish Sharma
A new series using APEX 18.1 is now available.
https://youtu.be/acnRWpRSrbI
This video in the APEX 5 tutorial series shows how to use SQL Scripts (part of SQL Workshop) to run scripts that create tables, sequences (to generate unique values for primary keys), triggers and insert data (INSERT INTO statements).
SQL scripts for this series are available to download at:
http://db.kreie.net
Views: 49151
Jennifer Kreie
www.facebook.com/oracle.shohag
Email : [email protected]
Website : www.oraclebangla.com
skype id : shoahgcid2013
Topics : Oracle Sql Drop statement
Views: 1637
Oracle Bangla
Oracle SQL Tutorial on How to create a table in Oracle using Create Statement in SQL developer, sql oracle create table example
--------------------------------------------------
Oracle SQL Practice Question:
https://drive.google.com/open?id=1NV0wolKARbpov1oQGjYP2xQD4TGNTtFp
--------------------------------------------------
In this video you will get answer of following question
1) create table in sql
2) create table statement
3) create table examples in sql
4) create table syntax in oracle SQL
5) create table syntax in or
6) how to create table in oracle sql plus
7) oracle database tutorial for beginners
8) syntax error in create table statement
9) create table syntax error
Frequently asked interview question on Oracle SQL
https://www.youtube.com/watch?v=f7E30fV8wJA&index=1&list=PLiLpmqwkwkCv4qmtBnz4M3zIs1_ukkboT
Its perfect course on Oracle SQL for beginners tutorials
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/lrnwthr/
Twitter:
https://twitter.com/LrnWthR
#SqlCreateTableSyntax #RakeshMalviya #OraclOnlineTraining
Views: 222
EqualConnect Coach
Case expression let you perform IF-THEN-ELSE in oracle database. There are two type of case in oracle simple case expression and searched case expression. This SQL Tutorial 49 is about Simple Case Expression.
● What Is Case Expression
● Syntax of Simple Case Expression
● Query 1. Column name of a table as Search expression in CASE
● Query 2. String as Search expression in CASE
Celebrating 1000 subscribers. Thanks a lot guys for all your love and support.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/simple-case-expression
-------------------------------------------------------------------------
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage
https://copy.com?r=kb4rc1
--------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the first one to see my videos!
--------------------------------------------------------------------------
Amazon Wishlist: http://bit.ly/wishlist-amazon
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
https://twitter.com/rebellionrider
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/rebellionrider/
You can also Email me at
[email protected]
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 37793
Manish Sharma
follows Statement in trigger
Creating Triggers in oracle
Learn Oracle PLSQL
EXAM 1Z0-144
Views: 508
khaled alkhudari
تعلم اوراكل حتى الاحتراف
تعلم اوراكل من الصفر
Learn Oracle
Views: 1946
khaled alkhudari
Oracle PL/SQL Online training at TekClasses.com gives the in-depth knowledge on real-time work experience. Oracle Database is also be defined as RDBMS, it's an Object-relational data base management system which developed by Oracle Corporation. Oracle 11g is the latest and most refined database system. It enables sophisticated applications, high-speed transactions and higher business selections. Information will be accessed through SQL from the database and Oracle is not any exception. PL/SQL is the procedural language extension to the SQL. There is no other way to access the information from within the program and the SQL is often embedded in PL/SQL programs.www.tekclasses.com
Views: 3355
TEK CLASSES
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
Views: 179257
Manish Sharma
30 minute new feature overview for Oracle SQL Developer versions 18.1, 18.2, and 18.3. This was originally presented at Oracle Open World in San Francisco in October, 2018.
5:35 Jeff Skips all the marketing stuff and jumps into the actual feature demo
Views: 1340
Jeff Smith
In this video you will learn about Statement Level Trigger in PL/SQL Oracle.
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
Views: 4413
ITORIAN
In 8 minutes see how to install and run Oracle SQL, Oracle's newest command-line interface for Oracle Database. Featuring an in-line editor, automatic output formatting, statement history/recall, Oracle SQLcl marries the best of Oracle SQL Developer and a modern CLI.
Views: 35079
Jeff Smith
Oracle SQL Online Tutorials | onlineclasses free videos - This video talks about,
1. How to connect to a Oracle database using SQL developer?
2. Creating a new table
3. Drop the table
4. Inserting data into the table
5. Manual commit
6. Select statement with * all columns
7. Select statement with specific columns
For more Oracle SQL Online Tutorials | onlineclasses free videos -
Please visit the channel for more videos,
https://www.youtube.com/channel/UCrTvb3977MR0tElOSFb1nvQ
Please visit the website to refer the content & more articles ,
http://wowetltesting.com
-~-~~-~~~-~~-~-
Please watch: "Indian Professional Blogger harsh agarwal"
https://www.youtube.com/watch?v=RxNHeJSED10
-~-~~-~~~-~~-~-
Views: 248
Mypappu Tech
For more such videos visit http://www.questpond.com
Also watch Learn Sql Queries in 1 hour :- https://www.youtube.com/watch?v=uGlfP9o7kmY
See our other Step by Step video series below :-
Learn Angular tutorial for beginners https://tinyurl.com/ycd9j895
Learn MVC Core step by step :- http://tinyurl.com/y9jt3wkv
Learn MSBI Step by Step in 32 hours:- https://goo.gl/TTpFZN
Learn Xamarin Mobile Programming Step by Step :- https://goo.gl/WDVFuy
Learn Design Pattern Step by Step in 8 hours:- https://goo.gl/eJdn0m
Learn C# Step by Step in 100 hours :- https://goo.gl/FNlqn3
Learn Data structures & algorithm in 8 hours :-https://tinyurl.com/ybx29c5s
Learn SQL Server Step by Step in 16 hours:- http://tinyurl.com/ja4zmwu
Learn Javascript in 2 hours :- http://tinyurl.com/zkljbdl
Learn SharePoint Step by Step in 8 hours:- https://goo.gl/XQKHeP
Learn TypeScript in 45 Minutes :- https://goo.gl/oRkawI
Learn webpack in 50 minutes:- https://goo.gl/ab7VJi
Learn Visual Studio code in 10 steps for beginners:- https://tinyurl.com/lwgv8r8
Learn Tableau step by step :- https://tinyurl.com/kh6ojyo
Preparing for C# / .NET interviews start here http://www.youtube.com/watch?v=gaDn-sVLj8Q
In this video we will try to understand four important concepts Inner joins,Left join,Right join and full outer joins.
We are also distributing a 100 page Ebook ".Sql Server Interview Question and Answers". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [email protected] with the shared link and we will email you the PDF.
Views: 860657
Questpond
Use inner joins with multiple tables to create reports. Uses aliases, and the SUM aggregate function to demonstrate the flexibility of the join statement.
Get the SQL script to create the database and run the exercies in the video here: https://www.qewbi.com/sql/scripts/qewbijoins.zip
Views: 138843
Edward Kench
by Mohamed El Desouki - محمد الدسوقى
[email protected]
Tel :00966 553450836
جامعة سلمان بن عبد العزيز - السعودية - الخرج
How to update and modify existing data in a table. كيف تحدث بيانات موجودة فى الجدول
Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W
oracle create table statement
oracle drop table statement
oracle constraints
database constraints
primary key constraint
foreign key constraint
check constraint
null not null constraint
unique constraint
insert into statement
update statement
delete statement
Views: 34785
محمد الدسوقى
Welcome to MyOnlineEdu.com's video tutorial. In this video you will learn how to install Oracle Database 11g XE (Express Edition) and then connect the database using Oracle SQL Developer IDE tool.
You can avail an instructor based live class from MyOnlineEdu.com. To enroll click the lick: https://www.myonlineedu.com/course/view/6/oracle-sql-and-plsql-11g-fundamentals
Views: 357049
MyOnlineEdu.com
In this video I use the CREATE TABLE command to create three tables: Books, Publisher, and Author. I use these three tables as sample data. The code I entered in is:
CREATE TABLE BOOK
(
BOOK_ID VARCHAR(4) PRIMARY KEY,
ISBN_10 VARCHAR(10),
ISBN_13 VARCHAR(13),
TITLE VARCHAR(50),
CATEGORY VARCHAR(15),
PRICE DECIMAL(6,2),
BINDING VARCHAR(1),
PUB_DATE VARCHAR(4),
AUTHOR_ID SMALLINT,
PUBLISHER_ID SMALLINT
);
CREATE TABLE PUBLISHER
(
PUBLISHER_ID SMALLINT PRIMARY KEY,
PUBLISHER_NAME VARCHAR(40)
);
CREATE TABLE AUTHOR
(
AUTHOR_ID SMALLINT PRIMARY KEY,
AUTHOR_LAST VARCHAR(25),
AUTHOR_FIRST VARCHAR(20)
);
I have to create each table individually in the SQL commands window.
This video is part of a series of videos with the purpose of learning the SQL language. For more information visit Lecture Snippets at http://lecturesnippets.com.
Views: 108350
Lecture Snippets
The way you create a table is to use the CREATE TABLE command.
CREATE TABLE users()
So in this situation, the name comes right after the TABLE keyword.
The next thing we do is put all of the columns on a line that we want to put in our table.
CREATE TABLE users(
user_id,
username,
first_name,
last_name
)
Notice the naming conventions here. For this series we are going to make columns with what is known as snake casing. This is where each individual word is separated by an underscore.
if you have more than one column, all of them have to have commas except the last one. The comma is a way to say that another column is coming, so you don't need to do it on the last one. Now you would think we were done, but we also have to say what data type each column is. Later we will extensively discuss data types so we can focus on them exclusively. For now, here are the data types we are going to use:
CREATE TABLE users(
user_id NUMBER,
username VARCHAR2(50),
first_name VARCHAR2(50),
last_name VARCHAR2(50)
)
Now, inside of the parenthesis for varchar2, we pass in a number... This is the max length of the string. But the question is, what is it measured in? The default is actually in bytes, not characters. For example if we have the string hello, it is 5 characters, but it might take up a total of 10 bytes of storage. So I would recommend adding the keyword char right after the number so it defaults to 50 characters, not bytes.
CREATE TABLE users(
user_id NUMBER,
username VARCHAR(50 CHAR),
first_name VARCHAR2(50 CHAR),
last_name VARCHAR2(50 CHAR)
)
This will work to create a table, but it's really missing a lot of information… which column is the primary key? Are we adding any indexes? Is there any thing else we need to say about these columns?
So as you can tell, we are making progress, but there is still so much to learn. The biggest gotcha to remember from this video is that the data type VARCHAR ends in a 2, stupid, right? who would end the name of something with a 2?
Once again, this is Caleb from CalebTheVideoMaker2, and we will catch you in the next one!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
HELP 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!)
Views: 33958
Caleb Curry