Hi friends in my today scenario i explaining how to create view in SQL and how view help to improve performance of SQL query. #SqlTutorial #createViewsinoracle Oracle database Unbeatable,Unbreakable Platform..

MySQL Tutorial #20 in Hindi: VIEWS in MySQL - Create View, With Check Option, Manage Views
How to Alter View
How to Drop a View
How to See View Defintion
MySQL tutorial for Beginners
MySQL Installation Guide
How to Install MySQL on windows 10

In this video we will learn about
1. What is a view
2. Creating example views
3. Advantages of using views
Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/09/views-in-sql-server-part-39.html
Slides
http://csharp-video-tutorials.blogspot.com/2013/09/part-39-views-in-sql-server.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

This is very important to know about Create View as Non Editable In SQL Server. Mostly we create view but we do not check whether is editable or not but if you try to edit from sql data will be editable .
To make Non editable we shown tips in this clip . As a programmer its very important to know this tips.
Facebook connect https://www.facebook.com/santosh439
Google Plus connect: https://plus.google.com/113811738373163359181
My blogs Details are as under.
Microsoft Dynamics Ax 2012: http://msdynamicsxx2012.blogspot.com/
Other Ax Blog :http://daynamicsaxaptatutorials.blogspot.com/
Youtube Connect: https://www.youtube.com/user/sksingh1980
Latest Jobs Information in IT Fields: http://latestjobsinsoftwareindustries.blogspot.com/
Information Technology Programming Tutorials:http://educationandintertainment.blogspot.com/

This video explains the syntax of creating a materialized view in oracle database, and also a brief demo of creating materialized view, refreshing the MV and dropping the MV is shown in this free video tutorial.

In this video I have explained what are materialized views?
What are there basic difference with views, and how they leverage query rewrite to optimize the performance with almost no change in existing code

A new series for APEX 18.1 is available. https://youtu.be/jYaOyiUWnk0
This is one in a series of videos about creating an application using Oracle APEX 5. In this video we create some simple views that combine information from two tables. We create a more complex view that uses other views and tables. We use these views to create a classic APEX report and then an interactive APEX report. A few options from the interactive report are demonstrated.
SQL scripts for this series are available to download at: http://db.kreie.net

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

https://www.quest.com/toad-for-oracle/
See an in-depth tutorial on Toad for Oracle, the solution from Quest that helps you reduce the time and effort required to develop and manage Oracle databases.
Logging into Oracle: 1:03
Key windows: 2:42
Options: 15:08
Customizing the UI: 17:38
Toad editions: 20:27
More information: 22:40

In this SQL Tutorial you will learn How To Grant Object Privilege using Grant Data Control Language (DCL) statement along with GRANT OPTION flag.
Third SQL Tutorial in the series of user privileges in oracle database
------------------------------------------------------------------------
►►►Timeline◄◄◄
1:06- Query 1- How To grant Basic Object Privilege (i.e.SELECT Object privilege) to a user
3:31- Query 2 - How to Grant Multiple Object Privilege To a user in 4:26- Query 3 - How To grant Object Privilege on Column Level
5:30- Query 4- How To Grant System Privilege WITH GRANT OPTION flag
6:06- WITH ADMIN OPTION demonstration
------------------------------------------------------------------------
Celebrating 1000 subscribers. Thanks a lot guys for all your love and support.
------------------------------------------------------------------------
►►►LINKS◄◄◄
List of Object Privilege http://bit.ly/list_of_object_privileges
Object Privileges Blog http://bit.ly/object_privileges-in-oracle-database
Previous Tutorial
System Privilege: http://youtu.be/EQzdtKPiErU
Introduction to user privilege: http://youtu.be/iQFb86lM1gs
-------------------------------------------------------------------------
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

In this SQL Tutorial you will learn How To Grant System Privilege using Grant Data Control Language (DCL) along with ADMIN OPTION flag.
First SQL Tutorial in the series of user privileges in oracle database
------------------------------------------------------------------------
►►►Timeline◄◄◄
1:50- Query 1- How To grant Basic System Privilege (i.e.Create Table system privilege) to a user
2:40- Query 2 - How to Grant Multiple System Privilege To a user in Single Grant (Data Control Language) Statement
3:52- Query 3 - How To grant System Privilege To Multiple Users in Single Grant (Data Control Language) Statement
4:50- Query 4- How To Grant System Privilege WITH ADMIN OPTION flag
5:26- WITH ADMIN OPTION demonstration
------------------------------------------------------------------------
Celebrating 1000 subscribers. Thanks a lot guys for all your love and support.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog (Link for SQL Script is at the end of this article) : http://bit.ly/system_privilege_admin_option
Link for How To create user
●SQL Tutorial 37 - Using Create User Statement
http://youtu.be/4QbK2Y-1LZw
●SQL Tutorial 38- Using SQL Developer
http://youtu.be/GS4udgR44Ls
●SQL Tutorial 39- Using Oracle Enterprise Manager
http://youtu.be/zGjh-Bb3HrI
List of few System Privileges Available in Oracle Database
http://wp.me/p3r6sw-7M
Previous Tutorial: Introduction To User Privileges
http://youtu.be/iQFb86lM1gs
-------------------------------------------------------------------------
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

APEX 4.2.4 is out of date. Please try the APEX 18.1 video series.
https://youtu.be/65LExgaQMHI
This video shows how to use APEX to create a view (a stored SQL query). Views are usually used to gather information from more than one table into a single display (i.e., view). Using the Object Browser and Query Builder, three views are created in this video. The first two views are simple but third view is more complicated. It uses two sub-views and two tables.

SQL is a standard Structured query language for storing, manipulating and retrieving data in databases. View
1) What is a View?
A view is a saved SQL query. A view can also be considered as a virtual table. actually retrieves the data from the underlying base tables. vtblEmployee, vtblDepartment
Create View vWName
as
sql query
Views can be used to reduce the complexity of the database schema, for non IT users. Views can be used as a mechanism to implement row and column level security. Row Level Security
where tblDepartment.DeptName = 'IT'
To look at view definition - sp_helptext vWName ; To modify a view - ALTER VIEW statement ; To Drop a view - DROP VIEW vWName.
2) Updateable Views
Is it possible to Insert, Update and delete rows, from the underlying tblEmployees table, using view vWEmployeesDataExceptSalary? Yes, SQL server views are updateable.
Update vWEmployeesDataExceptSalary
Set Name = 'Mikey' Where Id = 2
3) Indexed views
when you create an index, on a view, the view gets materialized. This means, the view is now, capable of storing data. In SQL server, we call them Indexed views and in Oracle, Materialized views. vtblProduct , vtblProductSales
If you want to create an Index, on a view, the following rules should be followed by the view. For the complete list of all rules, please check MSDN.
1. The view should be created with SchemaBinding option
2. If an Aggregate function in the SELECT LIST, references an expression, and if there is a possibility for that expression to become NULL, then, a replacement value should be specified. In this example, we are using, ISNULL() function, to replace NULL values with ZERO.
3. If GROUP BY is specified, the view select list must contain a COUNT_BIG(*) expression
4. The base tables in the view, should be referenced with 2 part name. In this example, tblProduct and tblProductSales are referenced using dbo.tblProduct and dbo.tblProductSales respectively.
Limitation :
1. You cannot pass parameters to a view. Table Valued functions are an excellent replacement for parameterized views.
2.Rules and Defaults cannot be associated with views.
3.The ORDER BY clause is invalid in views unless TOP or FOR XML is also specified.
4.Views cannot be based on temporary tables.

How to Create an user in Oracle
with minimum grants/privileges
we need to connect as SYSDBA
lets ceate an user test
you can see the user is created :
But can it connect?
lets open a new session
we can see it lacks create session priv.
so, we grant the create session privilege to user test
lets test
Its connecting.
But is it able to create a table ,lets check.
it lacks the ability to create table. SO lets give the privilege.
lets test again the create table command.
its throwing error regarding no Privilege on users tablespace .
But we have given USERS as the default tablespace to test(user).
So whats the problem?
The problem is there is not quota defined for user test.
lets give some quota like "10MB" or UNLIMITED , we will giev 10MB
NOw let us test.
So we can see that we now have sufficient / minimum privileges for the user test.
Hope this will help in understanding the concept behind user creation

USING SQL COMMAND
Types of SQL Commands
The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration.
The main categories are
DDL (Data Definition Language)
DML (Data Manipulation Language)
DQL (Data Query Language)
DCL (Data Control Language)
Data administration commands
Transactional control commands
Defining Database Structures
Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table.
Some of the most fundamental DDL commands discussed during following hours include the following:
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
ALTER INDEX
DROP INDEX
CREATE VIEW
DROP VIEW
Manipulating Data
Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database.
There are three basic DML commands:
INSERT
UPDATE
DELETE
Selecting Data
Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows:
SELECT
This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16.
A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt.
Data Control Language
Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows:
ALTER PASSWORD
GRANT
REVOKE
CREATE SYNONYM
You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book.
Data Administration Commands
Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows:
START AUDIT
STOP AUDIT
Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language.
Transactional Control Commands
In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions.
COMMIT Saves database transactions
ROLLBACK Undoes database transactions
SAVEPOINT Creates points within groups of transactions in which to ROLLBACK
SET TRANSACTION Places a name on a transaction
Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."
sql interview questions,sql interview questions and answers,interview questions for freshers,SQL,sql tutorial BEGINNERS,oracle,pl sql,pl/sql,mysql,oracle interview,google interview question,trigger in oracle,dbms,rdbms, oracle tutorial,pl sql basics,pl sql tutorials, pl sql example,sql,sql server ,query,sql query,questions,interview questions,coding interview,sql coding, code , database interview questions and answers,interview questions sql, interview questions,sql server,sql interview,interview sql,interview question sql join ,inner join, group by,select sql,interview questions ,sql basic,
PL SQL Programs,PL SQL,PL SQL block,PL SQL Function,PL SQL Package,PL SQL Package body,PL SQL Procedure
,PL SQL Trigger,PL SQLType,PL SQL Type body,CREATE OR REPLACE PROCEDURE,database interview questions and answers,interview questions sql, interview questions,sql server,Procedural Language,interview sql,interview question sql join ,inner join, group by,select sql,interview questions ,sql basic,pl sql variable,oraclecoach,claire rajan,
PL SQL,PL SQL block,PL SQL Function,PL SQL Package,PL SQL Package body,PL SQL Procedure,PL SQL Trigger,PL SQLType,PL SQL

CREATE TABLE command in sql/oracle,INSERT command in sql/oracle
UPDATE,ALTER PASSWORD command in sql,
GRANT command,
REVOKE command i,
CREATE SYNONYM command in sql/oracle,
DELETE command in sql/oracle,
ALTER TABLE command in sql/oracle,
DROP TABLE command in sql/oracle,
CREATE INDEX command in sql/oracle,
ALTER INDEX command in sql/oracle,
DROP INDEX command in sql/oracle,
CREATE VIEW command in sql/oracle,
DROP VIEW command in sql/oracle
USING SQL COMMAND
Types of SQL Commands
The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration.
The main categories are
DDL (Data Definition Language)
DML (Data Manipulation Language)
DQL (Data Query Language)
DCL (Data Control Language)
Data administration commands
Transactional control commands
Defining Database Structures
Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table.
Some of the most fundamental DDL commands discussed during following hours include the following:
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
ALTER INDEX
DROP INDEX
CREATE VIEW
DROP VIEW
Manipulating Data
Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database.
There are three basic DML commands:
INSERT
UPDATE
DELETE
Selecting Data
Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows:
SELECT
This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16.
A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt.
Data Control Language
Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows:
ALTER PASSWORD
GRANT
REVOKE
CREATE SYNONYM
You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book.
Data Administration Commands
Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows:
START AUDIT
STOP AUDIT
Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language.
Transactional Control Commands
In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions.
COMMIT Saves database transactions
ROLLBACK Undoes database transactions
SAVEPOINT Creates points within groups of transactions in which to ROLLBACK
SET TRANSACTION Places a name on a transaction
Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."

CREATE TABLE command in sql/oracle,INSERT command in sql/oracle
UPDATE,ALTER PASSWORD command in sql,
GRANT command,
REVOKE command i,
CREATE SYNONYM command in sql/oracle,
DELETE command in sql/oracle,
ALTER TABLE command in sql/oracle,
DROP TABLE command in sql/oracle,
CREATE INDEX command in sql/oracle,
ALTER INDEX command in sql/oracle,
DROP INDEX command in sql/oracle,
CREATE VIEW command in sql/oracle,
DROP VIEW command in sql/oracle
USING SQL COMMAND
Types of SQL Commands
The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration.
The main categories are
DDL (Data Definition Language)
DML (Data Manipulation Language)
DQL (Data Query Language)
DCL (Data Control Language)
Data administration commands
Transactional control commands
Defining Database Structures
Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table.
Some of the most fundamental DDL commands discussed during following hours include the following:
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
ALTER INDEX
DROP INDEX
CREATE VIEW
DROP VIEW
Manipulating Data
Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database.
There are three basic DML commands:
INSERT
UPDATE
DELETE
Selecting Data
Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows:
SELECT
This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16.
A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt.
Data Control Language
Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows:
ALTER PASSWORD
GRANT
REVOKE
CREATE SYNONYM
You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book.
Data Administration Commands
Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows:
START AUDIT
STOP AUDIT
Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language.
Transactional Control Commands
In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions.
COMMIT Saves database transactions
ROLLBACK Undoes database transactions
SAVEPOINT Creates points within groups of transactions in which to ROLLBACK
SET TRANSACTION Places a name on a transaction
Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."

This tutorial demonstrates how to set Ad Hoc options with Oracle Planning and Budgeting Cloud. Using Smart View, you learn how to set Ad Hoc options at a Global or Sheet level, and how to control how Ad Hoc actions are performed or how Ad Hoc grids are displayed. You see how to specify cell styles to apply visual cues such as font, background color, and border format to members or data cells in grids. You also see how to select Sheet options to customize how your data is displayed and formatted.

CREATE TABLE command in sql/oracle,INSERT command in sql/oracle
UPDATE,ALTER PASSWORD command in sql,
GRANT command,
REVOKE command i,
CREATE SYNONYM command in sql/oracle,
DELETE command in sql/oracle,
ALTER TABLE command in sql/oracle,
DROP TABLE command in sql/oracle,
CREATE INDEX command in sql/oracle,
ALTER INDEX command in sql/oracle,
DROP INDEX command in sql/oracle,
CREATE VIEW command in sql/oracle,
DROP VIEW command in sql/oracle
USING SQL COMMAND
Types of SQL Commands
The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration.
The main categories are
DDL (Data Definition Language)
DML (Data Manipulation Language)
DQL (Data Query Language)
DCL (Data Control Language)
Data administration commands
Transactional control commands
Defining Database Structures
Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table.
Some of the most fundamental DDL commands discussed during following hours include the following:
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
ALTER INDEX
DROP INDEX
CREATE VIEW
DROP VIEW
Manipulating Data
Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database.
There are three basic DML commands:
INSERT
UPDATE
DELETE
Selecting Data
Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows:
SELECT
This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16.
A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt.
Data Control Language
Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows:
ALTER PASSWORD
GRANT
REVOKE
CREATE SYNONYM
You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book.
Data Administration Commands
Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows:
START AUDIT
STOP AUDIT
Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language.
Transactional Control Commands
In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions.
COMMIT Saves database transactions
ROLLBACK Undoes database transactions
SAVEPOINT Creates points within groups of transactions in which to ROLLBACK
SET TRANSACTION Places a name on a transaction
Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."

USING SQL COMMAND
Types of SQL Commands
The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration.
The main categories are
DDL (Data Definition Language)
DML (Data Manipulation Language)
DQL (Data Query Language)
DCL (Data Control Language)
Data administration commands
Transactional control commands
Defining Database Structures
Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table.
Some of the most fundamental DDL commands discussed during following hours include the following:
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
ALTER INDEX
DROP INDEX
CREATE VIEW
DROP VIEW
Manipulating Data
Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database.
There are three basic DML commands:
INSERT
UPDATE
DELETE
Selecting Data
Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows:
SELECT
This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16.
A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt.
Data Control Language
Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows:
ALTER PASSWORD
GRANT
REVOKE
CREATE SYNONYM
You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book.
Data Administration Commands
Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows:
START AUDIT
STOP AUDIT
Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language.
Transactional Control Commands
In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions.
COMMIT Saves database transactions
ROLLBACK Undoes database transactions
SAVEPOINT Creates points within groups of transactions in which to ROLLBACK
SET TRANSACTION Places a name on a transaction
Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."
sql interview questions,sql interview questions and answers,interview questions for freshers,SQL,sql tutorial BEGINNERS,oracle,pl sql,pl/sql,mysql,oracle interview,google interview question,trigger in oracle,dbms,rdbms, oracle tutorial,pl sql basics,pl sql tutorials, pl sql example,sql,sql server ,query,sql query,questions,interview questions,coding interview,sql coding, code , database interview questions and answers,interview questions sql, interview questions,sql server,sql interview,interview sql,interview question sql join ,inner join, group by,select sql,interview questions ,sql basic,
PL SQL Programs,PL SQL,PL SQL block,PL SQL Function,PL SQL Package,PL SQL Package body,PL SQL Procedure
,PL SQL Trigger,PL SQLType,PL SQL Type body,CREATE OR REPLACE PROCEDURE,database interview questions and answers,interview questions sql, interview questions,sql server,Procedural Language,interview sql,interview question sql join ,inner join, group by,select sql,interview questions ,sql basic,pl sql variable,oraclecoach,claire rajan,
PL SQL,PL SQL block,PL SQL Function,PL SQL Package,PL SQL Package body,PL SQL Procedure,PL SQL Trigger,PL SQLType,PL SQL

CREATE TABLE command in sql/oracle,INSERT command in sql/oracle
UPDATE,ALTER PASSWORD command in sql,
GRANT command,
REVOKE command i,
CREATE SYNONYM command in sql/oracle,
DELETE command in sql/oracle,
ALTER TABLE command in sql/oracle,
DROP TABLE command in sql/oracle,
CREATE INDEX command in sql/oracle,
ALTER INDEX command in sql/oracle,
DROP INDEX command in sql/oracle,
CREATE VIEW command in sql/oracle,
DROP VIEW command in sql/oracle,
Types of SQL Commands
The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration.
The main categories are
DDL (Data Definition Language)
DML (Data Manipulation Language)
DQL (Data Query Language)
DCL (Data Control Language)
Data administration commands
Transactional control commands
Defining Database Structures
Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table.
Some of the most fundamental DDL commands discussed during following hours include the following:
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
ALTER INDEX
DROP INDEX
CREATE VIEW
DROP VIEW
These commands are discussed in detail during Hour 3, "Managing Database Objects," Hour 17, "Improving Database Performance," and Hour 20, "Creating and Using Views and Synonyms."
Manipulating Data
Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database.
There are three basic DML commands:
INSERT
UPDATE
DELETE
These commands are discussed in detail during Hour 5, "Manipulating Data."
Selecting Data
Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows:
SELECT
This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16.
A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt.
Data Control Language
Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows:
ALTER PASSWORD
GRANT
REVOKE
CREATE SYNONYM
You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book.
Data Administration Commands
Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows:
START AUDIT
STOP AUDIT
Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language.
Transactional Control Commands
In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions.
COMMIT Saves database transactions
ROLLBACK Undoes database transactions
SAVEPOINT Creates points within groups of transactions in which to ROLLBACK
SET TRANSACTION Places a name on a transaction
Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."

CREATE TABLE command in sql/oracle,INSERT command in sql/oracle
UPDATE,ALTER PASSWORD command in sql,
GRANT command,
REVOKE command i,
CREATE SYNONYM command in sql/oracle,
DELETE command in sql/oracle,
ALTER TABLE command in sql/oracle,
DROP TABLE command in sql/oracle,
CREATE INDEX command in sql/oracle,
ALTER INDEX command in sql/oracle,
DROP INDEX command in sql/oracle,
CREATE VIEW command in sql/oracle,
DROP VIEW command in sql/oracle
USING SQL COMMAND
Types of SQL Commands
The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration.
The main categories are
DDL (Data Definition Language)
DML (Data Manipulation Language)
DQL (Data Query Language)
DCL (Data Control Language)
Data administration commands
Transactional control commands
Defining Database Structures
Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table.
Some of the most fundamental DDL commands discussed during following hours include the following:
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
ALTER INDEX
DROP INDEX
CREATE VIEW
DROP VIEW
Manipulating Data
Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database.
There are three basic DML commands:
INSERT
UPDATE
DELETE
Selecting Data
Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows:
SELECT
This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16.
A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt.
Data Control Language
Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows:
ALTER PASSWORD
GRANT
REVOKE
CREATE SYNONYM
You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book.
Data Administration Commands
Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows:
START AUDIT
STOP AUDIT
Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language.
Transactional Control Commands
In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions.
COMMIT Saves database transactions
ROLLBACK Undoes database transactions
SAVEPOINT Creates points within groups of transactions in which to ROLLBACK
SET TRANSACTION Places a name on a transaction
Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."

CREATE TABLE command in sql/oracle,INSERT command in sql/oracle
UPDATE,ALTER PASSWORD command in sql,
GRANT command,
REVOKE command i,
CREATE SYNONYM command in sql/oracle,
DELETE command in sql/oracle,
ALTER TABLE command in sql/oracle,
DROP TABLE command in sql/oracle,
CREATE INDEX command in sql/oracle,
ALTER INDEX command in sql/oracle,
DROP INDEX command in sql/oracle,
CREATE VIEW command in sql/oracle,
DROP VIEW command in sql/oracle,
USING SQL COMMAND
Types of SQL Commands
The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration.
The main categories are
DDL (Data Definition Language)
DML (Data Manipulation Language)
DQL (Data Query Language)
DCL (Data Control Language)
Data administration commands
Transactional control commands
Defining Database Structures
Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table.
Some of the most fundamental DDL commands discussed during following hours include the following:
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
ALTER INDEX
DROP INDEX
CREATE VIEW
DROP VIEW
Manipulating Data
Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database.
There are three basic DML commands:
INSERT
UPDATE
DELETE
Selecting Data
Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows:
SELECT
This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16.
A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt.
Data Control Language
Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows:
ALTER PASSWORD
GRANT
REVOKE
CREATE SYNONYM
You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book.
Data Administration Commands
Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows:
START AUDIT
STOP AUDIT
Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language.
Transactional Control Commands
In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions.
COMMIT Saves database transactions
ROLLBACK Undoes database transactions
SAVEPOINT Creates points within groups of transactions in which to ROLLBACK
SET TRANSACTION Places a name on a transaction
Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."

CREATE TABLE command in sql/oracle,INSERT command in sql/oracle
UPDATE,ALTER PASSWORD command in sql,
GRANT command,
REVOKE command i,
CREATE SYNONYM command in sql/oracle,
DELETE command in sql/oracle,
ALTER TABLE command in sql/oracle,
DROP TABLE command in sql/oracle,
CREATE INDEX command in sql/oracle,
ALTER INDEX command in sql/oracle,
DROP INDEX command in sql/oracle,
CREATE VIEW command in sql/oracle,
DROP VIEW command in sql/oracle,
USING SQL COMMAND
Types of SQL Commands
The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration.
The main categories are
DDL (Data Definition Language)
DML (Data Manipulation Language)
DQL (Data Query Language)
DCL (Data Control Language)
Data administration commands
Transactional control commands
Defining Database Structures
Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table.
Some of the most fundamental DDL commands discussed during following hours include the following:
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
ALTER INDEX
DROP INDEX
CREATE VIEW
DROP VIEW
Manipulating Data
Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database.
There are three basic DML commands:
INSERT
UPDATE
DELETE
Selecting Data
Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows:
SELECT
This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16.
A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt.
Data Control Language
Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows:
ALTER PASSWORD
GRANT
REVOKE
CREATE SYNONYM
You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book.
Data Administration Commands
Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows:
START AUDIT
STOP AUDIT
Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language.
Transactional Control Commands
In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions.
COMMIT Saves database transactions
ROLLBACK Undoes database transactions
SAVEPOINT Creates points within groups of transactions in which to ROLLBACK
SET TRANSACTION Places a name on a transaction
Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."

CREATE TABLE command in sql/oracle,INSERT command in sql/oracle
UPDATE,ALTER PASSWORD command in sql,
GRANT command,
REVOKE command i,
CREATE SYNONYM command in sql/oracle,
DELETE command in sql/oracle,
ALTER TABLE command in sql/oracle,
DROP TABLE command in sql/oracle,
CREATE INDEX command in sql/oracle,
ALTER INDEX command in sql/oracle,
DROP INDEX command in sql/oracle,
CREATE VIEW command in sql/oracle,
DROP VIEW command in sql/oracle
USING SQL COMMAND
Types of SQL Commands
The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration.
The main categories are
DDL (Data Definition Language)
DML (Data Manipulation Language)
DQL (Data Query Language)
DCL (Data Control Language)
Data administration commands
Transactional control commands
Defining Database Structures
Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table.
Some of the most fundamental DDL commands discussed during following hours include the following:
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
ALTER INDEX
DROP INDEX
CREATE VIEW
DROP VIEW
Manipulating Data
Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database.
There are three basic DML commands:
INSERT
UPDATE
DELETE
Selecting Data
Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows:
SELECT
This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16.
A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt.
Data Control Language
Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows:
ALTER PASSWORD
GRANT
REVOKE
CREATE SYNONYM
You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book.
Data Administration Commands
Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows:
START AUDIT
STOP AUDIT
Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language.
Transactional Control Commands
In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions.
COMMIT Saves database transactions
ROLLBACK Undoes database transactions
SAVEPOINT Creates points within groups of transactions in which to ROLLBACK
SET TRANSACTION Places a name on a transaction
Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."

CREATE TABLE command in sql/oracle,INSERT command in sql/oracle
UPDATE,ALTER PASSWORD command in sql,
GRANT command,
REVOKE command i,
CREATE SYNONYM command in sql/oracle,
DELETE command in sql/oracle,
ALTER TABLE command in sql/oracle,
DROP TABLE command in sql/oracle,
CREATE INDEX command in sql/oracle,
ALTER INDEX command in sql/oracle,
DROP INDEX command in sql/oracle,
CREATE VIEW command in sql/oracle,
DROP VIEW command in sql/oracle
USING SQL COMMAND
Types of SQL Commands
The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration.
The main categories are
DDL (Data Definition Language)
DML (Data Manipulation Language)
DQL (Data Query Language)
DCL (Data Control Language)
Data administration commands
Transactional control commands
Defining Database Structures
Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table.
Some of the most fundamental DDL commands discussed during following hours include the following:
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
ALTER INDEX
DROP INDEX
CREATE VIEW
DROP VIEW
Manipulating Data
Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database.
There are three basic DML commands:
INSERT
UPDATE
DELETE
Selecting Data
Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows:
SELECT
This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16.
A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt.
Data Control Language
Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows:
ALTER PASSWORD
GRANT
REVOKE
CREATE SYNONYM
You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book.
Data Administration Commands
Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows:
START AUDIT
STOP AUDIT
Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language.
Transactional Control Commands
In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions.
COMMIT Saves database transactions
ROLLBACK Undoes database transactions
SAVEPOINT Creates points within groups of transactions in which to ROLLBACK
SET TRANSACTION Places a name on a transaction
Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."

CREATE TABLE command in sql/oracle,INSERT command in sql/oracle
UPDATE,ALTER PASSWORD command in sql,
GRANT command,
REVOKE command i,
CREATE SYNONYM command in sql/oracle,
DELETE command in sql/oracle,
ALTER TABLE command in sql/oracle,
DROP TABLE command in sql/oracle,
CREATE INDEX command in sql/oracle,
ALTER INDEX command in sql/oracle,
DROP INDEX command in sql/oracle,
CREATE VIEW command in sql/oracle,
DROP VIEW command in sql/oracle
USING SQL COMMAND
Types of SQL Commands
The following sections discuss the basic categories of commands used in SQL to perform various functions. These functions include building database objects, manipulating objects, populating database tables with data, updating existing data in tables, deleting data, performing database queries, controlling database access, and overall database administration.
The main categories are
DDL (Data Definition Language)
DML (Data Manipulation Language)
DQL (Data Query Language)
DCL (Data Control Language)
Data administration commands
Transactional control commands
Defining Database Structures
Data Definition Language, DDL, is the part of SQL that allows a database user to create and restructure database objects, such as the creation or the deletion of a table.
Some of the most fundamental DDL commands discussed during following hours include the following:
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
ALTER INDEX
DROP INDEX
CREATE VIEW
DROP VIEW
Manipulating Data
Data Manipulation Language, DML, is the part of SQL used to manipulate data within objects of a relational database.
There are three basic DML commands:
INSERT
UPDATE
DELETE
Selecting Data
Though comprised of only one command, Data Query Language (DQL) is the most concentrated focus of SQL for modern relational database users. The base command is as follows:
SELECT
This command, accompanied by many options and clauses, is used to compose queries against a relational database. Queries, from simple to complex, from vague to specific, can be easily created. The SELECT command is discussed in exhilarating detail during Hours 7 through 16.
A query is an inquiry to the database for information. A query is usually issued to the database through an application interface or via a command line prompt.
Data Control Language
Data control commands in SQL allow you to control access to data within the database. These DCL commands are normally used to create objects related to user access and also control the distribution of privileges among users. Some data control commands are as follows:
ALTER PASSWORD
GRANT
REVOKE
CREATE SYNONYM
You will find that these commands are often grouped with other commands and may appear in a number of different lessons throughout this book.
Data Administration Commands
Data administration commands allow the user to perform audits and perform analyses on operations within the database. They can also be used to help analyze system performance. Two general data administration commands are as follows:
START AUDIT
STOP AUDIT
Do not get data administration confused with database administration. Database administration is the overall administration of a database, which envelops the use of all levels of commands. Database administration is much more specific to each SQL implementation than are those core commands of the SQL language.
Transactional Control Commands
In addition to the previously introduced categories of commands, there are commands that allow the user to manage database transactions.
COMMIT Saves database transactions
ROLLBACK Undoes database transactions
SAVEPOINT Creates points within groups of transactions in which to ROLLBACK
SET TRANSACTION Places a name on a transaction
Transactional commands are discussed extensively during Hour 6, "Managing Database Transactions."