In this video I use the GROUP BY clause to organize the results of a function by groups or categories. If you are looking to run a function on a column and have those results grouped together then you will need to use the GROUP BY clause to run the query. 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.

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

This video is to understand how we can update a column of a table, based on the data present on the other table, and both the tables having a common column. Its a complicated update statement that can be used to update with different conditions.

http://www.informit.com/store/oracle-sql-livelessons-video-training-downloadable-9780134275741?WT.mc_id=Social_YT
Oracle SQL: Understanding Multiple Table Joins is an excerpt from Oracle SQL LiveLessons Video Training -- 6+ Hours of Video -- Oracle SQL LiveLessons Video Training covers the basics of the Oracle SQL programming language. This course covers both Oracle standard SQL and the ANSI approved SQL that Oracle supports. The focus of the course is to give students working knowledge of the Oracle SQL language and at the conclusion of this course, students should be able to query the Oracle database.
Description
In this LiveLessons video course, Oracle ACE Director Dan Hotka will teach you how to use the SQL query language, interpret business questions into SQL code, and how to use Where clauses sub-queries, complex table join conditions, and how to create table objects and populate tables with data. Students will also learn how to access Oracle from Microsoft products such as Excel. In addition, they will learn how analytical SQL can be used for business analysis. This course will use both Toad and SQL Developer for SQL examples.
About the Instructor
Dan Hotka is a training specialist and an Oracle ACE director who has more than 37 years in the computer industry and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and well over 200 published articles. He is also the video author for Oracle SQL Performance Tuning for Developers LiveLessons and Oracle PL/SQL Programming Fundamentals. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world. Visit his website at www.DanHotka.com.
Skill Level
Beginner
Learn How To
Use the SQL query language
Interpret business questions into SQL code
Understand Oracle standard SQL and ANSI SQL
Work with Where clauses, sub-queries, and complex table join conditions
Create table objects and populate these tables with data
Access Oracle from Microsoft products such as Excel
Use analytical SQL, useful for business analysts
Who Should Take This Course
Students who are new to SQL and want to learn Oracle SQL
Course Requirements
Basic knowledge of what is a database, especially RDBMS and what is a computer programming language
http://www.informit.com/store/oracle-sql-livelessons-video-training-downloadable-9780134275741?WT.mc_id=Social_YT

The ninth part of a mini-series of videos showing the basics of SQL. In this episode we take a look at some of the variations on the UPDATE statement. For more information see:
https://oracle-base.com/articles/misc/sql-for-beginners-the-update-statement
Website: https://oracle-base.com
Blog: https://oracle-base.com/blog
Twitter: https://twitter.com/oraclebase
Cameo by Frits Hoogland :
Blog: https://fritshoogland.wordpress.com/
Twitter: https://twitter.com/fritshoogland
Cameo appearances are for fun, not an endorsement of the content of this video.

In this video I use the UPDATE command to change existing data within a table. When using the UPDATE command you also need to use the keyword SET to choose the field column you wish to change and also a WHERE statement to choose the individual record that needs changed. The command I used is:
UPDATE BOOKS
SET BINDING = 'P'
WHERE BOOK_ID = '11';
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.

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

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

You may also like this: http://bc393wylrusazm13hj275jax02.hop.clickbank.net/
This video will allow you to update the staff wage within a relational database. The instructions are suitable for a Microsoft Access, SQL Server, MySQL, Oracle or any other relational database out there.
Easy steps on how to create an advance query in Microsoft Access which can be also applied on other relational databases.
Updating wages based on a specific amount e.g. £10 or $10 or 10 euro or even based on a percentage e.g. increase the wage by 10% (ten percent).
https://a-webdesign.com/

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

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

MySQL LESSON 3 (HD WITH VOICE)
RENAME DATABASE TABLES
DELETE FROM Using ID
Query Using COUNT clause
Query Using COUNT AS column name
Query Using ORDER BY clause
Query Using ORDER BY DESCENDING
Query Using ORDER BY ASCENDING
Query Using ORDER BY ASC & DESC
Query Using SUM AS FROM
Query Using AVERAGE AS FROM
Query Using MINIMUM FROM
Query Using MAXIMUM AS FROM
SCRIPT FOR THE COMPLETE READY FOR THE NEXT LESSON
http://goo.gl/OtTvWh
•••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••
PSN► HaKDMoDz
Skype► HaKDMoDz
Youtube► https://www.youtube.com/channel/UCVIdbizKGf1GKYXwZb8VpWw?sub_confirmation=1
Gmail► [email protected]
Twitter► @HaKDMoDz
About me► https://about.me/HaKDMoDz
☺▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬☺
Comment what you guys want to see in my next video.
For more HaKDMoDz™ Video's and Tutorials PLEASE click ■Subscribe■Like■Comment■
Thank you for watching now Subscribe and Like if this helped you out and share my video and dont forget to check out my other videos with Modded ps3 account giveaways and Game unlocks and platinum trophy offers and other cool tutorials. ­­­»
••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••••• Check out my website http://hakdmodz.com

This Video Tutorial Will Describe how to update a row or update column or update particular value which is already inserted into the table in oracle 12C version. This command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on.
This command is used to update or modify the inserted data into the table. You can update single column, single row, multiple columns or multiple rows with this command.
Full Syntax will be given in this video tutorial about how to update data in oracle database table.
Along with the live example to update rows or columns from the table.
All the keywords, format, mandatory clauses etc are described in this video.

In this tutorial, you'll learn the difference between delete/drop and truncate.
PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database.
PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces.
PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard.
The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3]
PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables.
PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7]
The StepSqlite product is a PL/SQL compiler for the popular small database SQLite.
PL/SQL Program Unit
A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database.
The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label.
Package
Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are:
Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation.
Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.

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

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

UKOUG Oracle Database & Associated Technologies OpenWorld Update Webinar
About Dominic Giles - Master Product Manager for the Oracle Database
Dominic is a Master Product Manager for the Oracle Database, responsible for the overall product offering. He’s worked at Oracle for over 27 years since the release of Oracle Database 5. One of Dominic’s primary roles is to update customers on new functionality and gather feedback for future releases. You can follow him on twitter @dominic_giles. In his spare time, Dominic has created swingbench a popular load generator for the Oracle Database. If he finds any other time Dominic also enjoys tennis, electronics and woodworking.