Home
Search results “Savepoint oracle loop”
SQL: Transaction Part-1
 
06:05
In this tutorial, you'll learn what are transaction and nature of transaction. 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.
Views: 2590 radhikaravikumar
Savepoint, Rollback and Commit in Oracle
 
06:47
SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations. Watch this Video to learn basics of SQL. This Video covers below topics about SQL. What is Database What is Database Table What is Database Fields and Records What is Oracle What is RDBMS and how it is different from flat files What is SQL Is SQL common for all RDBMS packages, prove it Installing Oracle CREATE, INSERT and SELECT commands DELETE and UPDATE commands SELECT command with WHERE condition LIKE 'pattern' Operator IN Operator BETWEEN Operator Pseudo Columns Data Types in Oracle ORDER BY Clause in Oracle RENAME Table and DROP Table in Oracle Savepoint, Rollback and Commit in Oracle Create Tablespace, Create User, Create Role, Drop Role, Drop User, Drop Tablespace in Oracle Tablespace and Datafile in Oracle Alter Tablespace in Oracle Insert multiple records in one or more tables at once in Oracle Grant, Revoke and Grant Table View to other user in Oracle Referential Integrity in Oracle Column Alias in Oracle Table Alias in Oracle Equi Join and Non Equi Join in Oracle Self Join in Oracle Natural Join in Oracle Cross Join in Oracle Outer Join - (Left Outer Join, Right Outer Join and Full Outer Join) in Oracle Anti Join in Oracle Column Format in Oracle Aggregate Functions in Oracle Character Functions in Oracle Number Functions in Oracle Conversion Functions To Char, To Date, NVL, Decode in Oracle Date Functions - Add Months, Last Day, Months Between, Next Day, To Date, New Time in Oracle SQL Commands Type in Oracle SQL Buffer Commands in Oracle Ed or Edit Buffer Command in Oracle IN and NOT IN Operators in Oracle Not Null Constraint in Oracle Unique Constraint in Oracle Primary Key and Foreign Key Constraints in Oracle Check Constraint in Oracle Order By Clause in Oracle Group By Clause in Oracle Having Clause in Oracle Subquery or Inner Query or Nested Query in Oracle Union, Union All, Intersect and Minus Operators in Oracle Data Dictionaries TAB, ALL TABLES, ALL SEQUENCES, ALL VIEWS etc in Oracle What are SQL, PLSQL, TSQL and SQL Plus ALTER TABLE ADD new column and DROP existing column in Oracle ALTER TABLE to Modify existing column in Oracle ALTER TABLE to ADD and DROP integrity constraints in Oracle Create, Alter and Drop Sequence in Oracle Create, Alter and Drop named constraints in Oracle Subquery in Oracle Set Union, Union All, Intersect, Minus Operators in Oracle Execute commands written in physical file Getting started with SQL Plus Reports - Part 1 Getting started with SQL Plus Reports - Part 2 Getting started with SQL Plus Reports - Part 3 Views in Oracle Input Variables in Oracle SQL Plus Define Variables in Oracle Bind Variables in Oracle Introduction to PLSQL in Oracle IF ELSE construct in PLSQL Oracle FOR LOOP Looping Command in PLSQL Oracle LOOP Looping Command in PLSQL Oracle WHILE Looping Command in PLSQL Oracle PLSQL Table in Oracle Exception in PLSQL Oracle Tax Calculator and Exception Handling in PLSQL Oracle Introduction to Cursor in PLSQL Oracle Cursor Examples in PLSQL Oracle UPDATE and DELETE using Cursor in PLSQL Oracle Introduction to TRIGGER in PLSQL Oracle AFTER INSERT fire UPDATE Command in Trigger AFTER INSERT or UPDATE or DELETE Commands in Trigger Statement Level Trigger in PLSQL Oracle
Views: 85 Aap Koun
PL/SQL tutorial 59: PL/SQL Collection Method COUNT in Oracle Database by Manish Sharma
 
04:53
RebellionRider presents PL/SQL tutorial explaining the concepts of Collection Method COUNT in Oracle Database. This tutorial will help you in learning the basics of COUNT function. This video will also help you in learning – What is collection method Count in Oracle Database • How to use COUNT function • How to use COUNT function with IF Condition • How to use COUNT function with For-Loop Hope you will enjoy. Do make sure to Like, Share & Subscribe. Thanks Tweet Link: https://twitter.com/OracleSQLDev/status/872441483223281664 Follow me on Twitter: https://twitter.com/RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/count-function Previous Tutorial ► Introduction to collection methods https://youtu.be/8V40IaOkGcU ► Tut 51. How to create nested table https://youtu.be/EUYyiFCzU0I ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 5691 Manish Sharma
Cursor FOR Loop In Oracle Database
 
04:33
Cursor for loop in Oracle Database..Original uploaded by Mr.Manish.
Views: 92 Learn & Share
026 - Oracle SQL Arabic Course - DCL -Commit - Rollback  اوراكل ديفلوبر
 
12:24
أهلا بكم فى درس جديد من سلسلة دروس أوراكل ديفلوبر شرح SQL فى درس اليوم نتحدث عن Data Control Language Commit - Save point - Rollback - For Update .......................................­.................... تواصل معانا علي الفيس بوك من هنا : https://www.facebook.com/askgad .......................................­.................... تواصل معانا علي موقعنا من هنا : https://www.askgad.com
Views: 1220 Ask Gad
Introduction to Oracle: PL-SQL - WHILE Statement
 
03:55
Introduction to Oracle: PL-SQL - WHILE Statement
Views: 85 David Hays
Introduction to PL/SQL Transactions
 
02:52
Introduces PL/SQL transaction statements like commit, Rollback and savepoint. Shows how PL/SQL transactions can be used as recovery units.
Views: 120 Victor
Using Savepoint, Commit and Rollback in SQL,  Class 12 IP
 
13:45
This video explains what are transactions, How transactions work, their properties and how to solve output questions using Commit, Rollback and Savepoints. Also explain the purpose of Autocommit.
Views: 1486 Anjali Luthra
PL/SQL: Mutating Triggers Part-1
 
06:24
In this tutorial, you'll learn... 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.
Views: 21834 radhikaravikumar
Nesting transactions and SAVE TRANSACTION command in SQL Server
 
10:31
Do you know how transactions can be nested in SQL Server? Have you ever used the SAVE TRANSACTION command? If not, watch this video. I show case by case how transactions work, how they behave if they are nested and rolled back or committed. I hope you will enjoy it.
Views: 2366 DBA presents
Tutorial 52 - Transactions in PostgreSQL.
 
07:39
Learn about Transactions in PostgreSQL
Views: 2732 Programming Guru
Top 10 PL/SQL Interview Questions
 
04:04
http://career.guru99.com/top-50-plsql-interview-questions/ Questions covered in this video are 1) What is PL SQL ? 2) Differentiate between % ROWTYPE and TYPE RECORD. 3) Explain Commit, Rollback and Savepoint. 4) Explain polymorphism in PL/SQL. 5) What are the cursor attributes of PL/SQL. 6) How functions and procedures are called in a PL/SQL block. 7) Show code of a cursor for loop. 8) Explain the uses of database trigger. 9) How is a process of PL/SQL compiled? 10) Define Implicit and Explicit Cursors.
Views: 53261 Guru99
merge command
 
03:42
in this video I'm going to demonstrate you how to use Oracle SQL merge command.
Views: 1019 OCP Technology
4  merge statement
 
18:16
Video from our Oracle SQL course. Check out the full course at.. http://learn.hackpress.co/courses/oracle-sql-learning-by-example
Views: 11653 etldeveloper
PL/SQL: Explicit Cursors
 
09:21
In this tutorial, you'll learn how to create explicit cursor and the difference between explicit & implicit cursors...
Views: 19230 radhikaravikumar
Learn Oracle | How to use the Merge Statement in SQL
 
04:13
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
Views: 1464 Pebbles Tutorials
WHILE Looping Command in PLSQL Oracle, PLSQL Table in Oracle, Exception in PLSQL Oracle, Tax Calcu
 
52:31
SQL is a special purpose programming language designed for managing data in a relational database, , is used by a huge number of apps , organizations. Watch this Video to learn basics of SQL. This Video covers below topics about SQL. …………………..LIKE…….SUB………SHARE……….. What is Database , What is Database Table , What is Database Fields , Records , What is Oracle , What is RDBMS , how it is different from flat files , What is SQL Is SQL common for all RDBMS packages, prove it , Installing Oracle , CREATE, INSERT , SELECT comm,s , DELETE , UPDATE comm,s , SELECT comm, with WHERE condition , LIKE 'pattern' Operator , IN Operator , BETWEEN Operator , Pseudo Columns , Data Types , ORDER BY Clause , RENAME Table , DROP Table , Savepoint, Rollback , Commit , Create Tablespace, Create User, Create Role, Drop Role, Drop User, Drop Tablespace , Tablespace , Datafile , Alter Tablespace , Insert multiple records in one or more tables at once , Grant, Revoke , Grant Table View to other user , Referential Integrity , Column Alias , Table Alias , Equi Join , Non Equi Join , Self Join , Natural Join , Cross Join , Outer Join Left Outer Join, Right Outer Join , Full Outer Join , Anti Join , Column Format , Aggregate Functions , Character Functions , Number Functions , Conversion Functions To Char, To Date, NVL, Decode , Date Functions Add Months, Last Day, Months Between, Next Day, To Date, New Time , SQL Comm,s Type , SQL Buffer Comm,s , Ed or Edit Buffer Comm, , IN , NOT IN Operators , Not Null Constraint , Unique Constraint , Primary Key , Foreign Key Constraints , Check Constraint , Order By Clause , Group By Clause , Having Clause , Subquery or Inner Query or Nested Query , Union, Union All, Intersect , Minus Operators , Data Dictionaries TAB, ALL TABLES, ALL SEQUENCES, ALL VIEWS etc , What are SQL, PLSQL, TSQL , SQL Plus , ALTER TABLE ADD new column , DROP existing column , ALTER TABLE to Modify existing column , ALTER TABLE to ADD , DROP integrity constraints , Create, Alter , Drop Sequence , Create, Alter , Drop named constraints , Subquery , Set Union, Union All, Intersect, Minus Operators , Execute comm,s written in physical file , Getting started with SQL Plus Reports Part 1 , Getting started with SQL Plus Reports Part 2 , Getting started with SQL Plus Reports Part 3 , Views , Input Variables SQL Plus , Define Variables , Bind Variables , Introduction to PLSQL , IF ELSE construct in PLSQL Oracle , FOR LOOP Looping Comm, in PLSQL Oracle , LOOP Looping Comm, in PLSQL Oracle , WHILE Looping Comm, in PLSQL Oracle , PLSQL Table , Exception in PLSQL Oracle , Tax Calculator , Exception H,ling in PLSQL Oracle , Introduction to Cursor in PLSQL Oracle , Cursor Examples in PLSQL Oracle , UPDATE , DELETE using Cursor in PLSQL Oracle , Introduction to TRIGGER in PLSQL Oracle , AFTER INSERT fire UPDATE Comm, in Trigger , AFTER INSERT or UPDATE or DELETE Comm,s in Trigger , Statement Level Trigger in PLSQL Oracle.
Views: 45 Aap Koun
77. Introduction to Cursor in PL/SQL Oracle
 
11:21
In this video you will learn about Introduction to Cursor in PL/SQL Oracle. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 7996 ITORIAN
transaction project
 
09:40
Oracle Isolation Level in Tamil Help us caption & translate this video! http://amara.org/v/DWVB/
SQL: Transaction Part-2
 
06:40
In this tutorial, you'll learn what are transaction and nature of transaction. 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.
Views: 1303 radhikaravikumar
PL/SQL: Mutating Triggers Part-2
 
08:41
In this tutorial, you'll learn... 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.
Views: 13328 radhikaravikumar
Types of commits in Oracle (implicit & explicit)
 
02:05
types of commits 's in oracle (implicit &explicit commit)
Views: 100 sreetheja amilineni
What is Oracle
 
01:17
SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations. Watch this Video to learn basics of SQL. This Video covers below topics about SQL. What is Database What is Database Table What is Database Fields and Records What is Oracle What is RDBMS and how it is different from flat files What is SQL Is SQL common for all RDBMS packages, prove it Installing Oracle CREATE, INSERT and SELECT commands DELETE and UPDATE commands SELECT command with WHERE condition LIKE 'pattern' Operator IN Operator BETWEEN Operator Pseudo Columns Data Types in Oracle ORDER BY Clause in Oracle RENAME Table and DROP Table in Oracle Savepoint, Rollback and Commit in Oracle Create Tablespace, Create User, Create Role, Drop Role, Drop User, Drop Tablespace in Oracle Tablespace and Datafile in Oracle Alter Tablespace in Oracle Insert multiple records in one or more tables at once in Oracle Grant, Revoke and Grant Table View to other user in Oracle Referential Integrity in Oracle Column Alias in Oracle Table Alias in Oracle Equi Join and Non Equi Join in Oracle Self Join in Oracle Natural Join in Oracle Cross Join in Oracle Outer Join - (Left Outer Join, Right Outer Join and Full Outer Join) in Oracle Anti Join in Oracle Column Format in Oracle Aggregate Functions in Oracle Character Functions in Oracle Number Functions in Oracle Conversion Functions To Char, To Date, NVL, Decode in Oracle Date Functions - Add Months, Last Day, Months Between, Next Day, To Date, New Time in Oracle SQL Commands Type in Oracle SQL Buffer Commands in Oracle Ed or Edit Buffer Command in Oracle IN and NOT IN Operators in Oracle Not Null Constraint in Oracle Unique Constraint in Oracle Primary Key and Foreign Key Constraints in Oracle Check Constraint in Oracle Order By Clause in Oracle Group By Clause in Oracle Having Clause in Oracle Subquery or Inner Query or Nested Query in Oracle Union, Union All, Intersect and Minus Operators in Oracle Data Dictionaries TAB, ALL TABLES, ALL SEQUENCES, ALL VIEWS etc in Oracle What are SQL, PLSQL, TSQL and SQL Plus ALTER TABLE ADD new column and DROP existing column in Oracle ALTER TABLE to Modify existing column in Oracle ALTER TABLE to ADD and DROP integrity constraints in Oracle Create, Alter and Drop Sequence in Oracle Create, Alter and Drop named constraints in Oracle Subquery in Oracle Set Union, Union All, Intersect, Minus Operators in Oracle Execute commands written in physical file Getting started with SQL Plus Reports - Part 1 Getting started with SQL Plus Reports - Part 2 Getting started with SQL Plus Reports - Part 3 Views in Oracle Input Variables in Oracle SQL Plus Define Variables in Oracle Bind Variables in Oracle Introduction to PLSQL in Oracle IF ELSE construct in PLSQL Oracle FOR LOOP Looping Command in PLSQL Oracle LOOP Looping Command in PLSQL Oracle WHILE Looping Command in PLSQL Oracle PLSQL Table in Oracle Exception in PLSQL Oracle Tax Calculator and Exception Handling in PLSQL Oracle Introduction to Cursor in PLSQL Oracle Cursor Examples in PLSQL Oracle UPDATE and DELETE using Cursor in PLSQL Oracle Introduction to TRIGGER in PLSQL Oracle AFTER INSERT fire UPDATE Command in Trigger AFTER INSERT or UPDATE or DELETE Commands in Trigger Statement Level Trigger in PLSQL Oracle
Views: 40 Aap Koun
pl-sql tutorial in hindi lec 12 (while loop in plsql)
 
04:54
http://www.bitsinfotec.in/
Views: 162 JavaTreePoint
Grant, Revoke and Grant Table View to other user in Oracle
 
10:02
SQL is a special purpose programming language designed for managing data in a relational database, , is used by a huge number of apps , organizations. Watch this Video to learn basics of SQL. This Video covers below topics about SQL. …………………..LIKE…….SUB………SHARE……….. What is Database , What is Database Table , What is Database Fields , Records , What is Oracle , What is RDBMS , how it is different from flat files , What is SQL Is SQL common for all RDBMS packages, prove it , Installing Oracle , CREATE, INSERT , SELECT comm,s , DELETE , UPDATE comm,s , SELECT comm, with WHERE condition , LIKE 'pattern' Operator , IN Operator , BETWEEN Operator , Pseudo Columns , Data Types , ORDER BY Clause , RENAME Table , DROP Table , Savepoint, Rollback , Commit , Create Tablespace, Create User, Create Role, Drop Role, Drop User, Drop Tablespace , Tablespace , Datafile , Alter Tablespace , Insert multiple records in one or more tables at once , Grant, Revoke , Grant Table View to other user , Referential Integrity , Column Alias , Table Alias , Equi Join , Non Equi Join , Self Join , Natural Join , Cross Join , Outer Join Left Outer Join, Right Outer Join , Full Outer Join , Anti Join , Column Format , Aggregate Functions , Character Functions , Number Functions , Conversion Functions To Char, To Date, NVL, Decode , Date Functions Add Months, Last Day, Months Between, Next Day, To Date, New Time , SQL Comm,s Type , SQL Buffer Comm,s , Ed or Edit Buffer Comm, , IN , NOT IN Operators , Not Null Constraint , Unique Constraint , Primary Key , Foreign Key Constraints , Check Constraint , Order By Clause , Group By Clause , Having Clause , Subquery or Inner Query or Nested Query , Union, Union All, Intersect , Minus Operators , Data Dictionaries TAB, ALL TABLES, ALL SEQUENCES, ALL VIEWS etc , What are SQL, PLSQL, TSQL , SQL Plus , ALTER TABLE ADD new column , DROP existing column , ALTER TABLE to Modify existing column , ALTER TABLE to ADD , DROP integrity constraints , Create, Alter , Drop Sequence , Create, Alter , Drop named constraints , Subquery , Set Union, Union All, Intersect, Minus Operators , Execute comm,s written in physical file , Getting started with SQL Plus Reports Part 1 , Getting started with SQL Plus Reports Part 2 , Getting started with SQL Plus Reports Part 3 , Views , Input Variables SQL Plus , Define Variables , Bind Variables , Introduction to PLSQL , IF ELSE construct in PLSQL Oracle , FOR LOOP Looping Comm, in PLSQL Oracle , LOOP Looping Comm, in PLSQL Oracle , WHILE Looping Comm, in PLSQL Oracle , PLSQL Table , Exception in PLSQL Oracle , Tax Calculator , Exception H,ling in PLSQL Oracle , Introduction to Cursor in PLSQL Oracle , Cursor Examples in PLSQL Oracle , UPDATE , DELETE using Cursor in PLSQL Oracle , Introduction to TRIGGER in PLSQL Oracle , AFTER INSERT fire UPDATE Comm, in Trigger , AFTER INSERT or UPDATE or DELETE Comm,s in Trigger , Statement Level Trigger in PLSQL Oracle.
Views: 206 Aap Koun
Transaction SQL Tutorial | SQL Commit and Rollback | ACID Property in SQL | Edureka
 
13:24
( PHP & MySQL with MVC Frameworks Certification Training - https://www.edureka.co/php-mysql-self-paced ) Watch Sample Class recording: http://www.edureka.co/php-mysql?utm_source=youtube&utm_medium=referral&utm_campaign=transaction-sql-php A transaction is the propagation of one or more changes to the database. For example, if you are creating a record or updating a record or deleting a record from the table, then you are performing transaction on the table. It is important to control transactions to ensure data integrity and to handle database errors. Practically, you will club many SQL queries into a group and you will execute all of them together as a part of a transaction. this video helps you to learn about transaction and transaction manipulation. Related Posts : http://www.edureka.co/blog/php-tutorial-web-concepts-in-php?utm_source=youtube&utm_medium=referral&utm_campaign=transaction-sql-php http://www.edureka.co/blog/php-tutorial-data-types-declaration?utm_source=youtube&utm_medium=referral&utm_campaign=transaction-sql-php http://www.edureka.co/blog/php-tutorial-differentiating-php-code-in-html-script?utm_source=youtube&utm_medium=referral&utm_campaign=transaction-sql-php Edureka is a New Age e-learning platform that provides Instructor-Led Live, Online classes for learners who would prefer a hassle free and self paced learning environment, accessible from any part of the world. The topics related to Transaction have extensively been covered in our course 'PHP & MySQL’. For more information, please write back to us at [email protected] Call us at US: 1800 275 9730 (toll free) or India: +91-8880862004
Views: 11643 edureka!
CTS interview questions on Oracle SQL and PLSQL
 
06:45
Here are the CTS interview questions on SQL and PLSQL. PL/SQL: What are the activities are you doing daily in your project? Tell me ratio's of sql, pl/sql & Unix? Diff b/w primary key & unique key + not null? What is the use of views? If table dropped, then what happen view? What is index? types of indexes? Which functions are not supported to index? What is save point? What is ora-1555? What are the data types available in pl/sql, not in sql? What is the main use of %type,%rowtype? What is cursor? Types of cursors? Diff b/w explicit cursor & for loop cursor? What is exception? Types of exceptions? What is raise_application_error? How many LONG columns are allowed in a table? What cursor type do you use to retrieve multiple record sets? What is normalization ? What is an index and types of indexes. How many number of indexes can be used per table ? how can we find the select statement is indexed or not? What are wait events. Describe the wait event tables. How do u count no of rows in a table? When do we create bitmap indexes sql query to get zero records from a table having n no of records function can return multiple value? how give give sample coding Difference between NVL, NVL2 and NULLIF Name Salary Abc 50000 Abc 50000 xyz 20000, find the max salary using aggregate function? What are the Diff B/W Cursor and REF Cursor What is pragma_exception_init? Diff b/w triggers & procedures? Can you call procedure in select statement? Restrictions in functions? What is the use of packages? How to drop package body only? Can use pragma_autonamous_tranctions in packages? What is bulk collect? What is nullif()? What is mutating error?  What are the module's , you are working Which will fire default first statement level or row level trigger? What is bulk collect? And any restrictions in bulk collect? What is the use of limit clause in bulk collect? How to debug your code? How to trace error handling? How to find which line error was raised? What are the methods there in save exceptions? What is functional based index? Write syntax? In my next video i will be providing you the answers for each on of this questions. For HCL interview question : https://youtu.be/Pf0lRerwF5U For Global Analytics interview questions : https://youtu.be/joRTF8ZhVwg Please subscribe to my channel here for more videos on recent interview questions of MNC companies. https://www.youtube.com/channel/UCofhGV_j_4cVGa9R08MsuXQ thanks to my subscribers !!
Views: 11524 Oracle PL/SQL
PL/SQL: Cursors (Implicit)
 
08:28
In this tutorial, you'll learn what is a cursor and the types of cursors available in the pl/sql...
Views: 18901 radhikaravikumar
Oracle || Transaction control statements by Siva
 
13:30
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo............
102/125 Oracle PLSQL: PLSQL Compiler / plsql_code_type
 
17:11
PLSQL Compiler plsql_code_type INTERPRETED and native Learn Oracle PLSQL EXAM 1Z0-144
Views: 379 khaled alkhudari
BLK1: Introduction to Bulk Processing (PL/SQL Channel)
 
13:44
The first lesson in the bulk processing series, this video discusses why bulk processing is needed to improve SQL performance from PL/SQL blocks. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
SQL: ACID (Transaction properties)
 
06:34
In this tutorial, you'll learn what is ACID 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.
Views: 2332 radhikaravikumar
postgresql savepoint
 
20:01
PostgreSQL de savepoint'in anlaşılması için örnekli uygulama video'su dur. Videolar tamamen eğitim amaçlı olup herhangi bir ticari amaç içermemektedir. pg_egitim=# Ali Karakaya pg_egitim=# [email protected]
Views: 81 pg_egitim
MySQL Tutorial How to use Commit and Rollback TCL in Workbench
 
06:16
In this video we will see How to use commit How to use Rollback. MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X. COMMIT: Commit statement commits the current transaction, which means making the changes permanent. A transaction may involve update and or delete and or insert statements. ROLLBACK: Rollback statement rolls back the present transaction, which means cancelling a transaction’s changes. Check out our website: http://www.telusko.com Follow Telusko on Twitter: https://twitter.com/navinreddy20 Follow on Facebook: Telusko : https://www.facebook.com/teluskolearnings Navin Reddy : https://www.facebook.com/navintelusko Follow Navin Reddy on Instagram: https://www.instagram.com/navinreddy20 Subscribe to our other channel: Navin Reddy : https://www.youtube.com/channel/UCxmkk8bMSOF-UBF43z-pdGQ?sub_confirmation=1 Telusko Hindi : https://www.youtube.com/channel/UCitzw4ROeTVGRRLnCPws-cw?sub_confirmation=1
Views: 17371 Telusko Learnings
SQL: Views Part-1
 
06:31
In this tutorial, you'll learn what are views and the types of views..
Views: 12386 radhikaravikumar
Commit and rollback
 
01:43
Transacciones SQL en Oracle 11g
Views: 178 Eduardo Eduardoo
CREATE, INSERT and SELECT commands
 
15:57
SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations. Watch this Video to learn basics of SQL. This Video covers below topics about SQL. What is Database What is Database Table What is Database Fields and Records What is Oracle What is RDBMS and how it is different from flat files What is SQL Is SQL common for all RDBMS packages, prove it Installing Oracle CREATE, INSERT and SELECT commands DELETE and UPDATE commands SELECT command with WHERE condition LIKE 'pattern' Operator IN Operator BETWEEN Operator Pseudo Columns Data Types in Oracle ORDER BY Clause in Oracle RENAME Table and DROP Table in Oracle Savepoint, Rollback and Commit in Oracle Create Tablespace, Create User, Create Role, Drop Role, Drop User, Drop Tablespace in Oracle Tablespace and Datafile in Oracle Alter Tablespace in Oracle Insert multiple records in one or more tables at once in Oracle Grant, Revoke and Grant Table View to other user in Oracle Referential Integrity in Oracle Column Alias in Oracle Table Alias in Oracle Equi Join and Non Equi Join in Oracle Self Join in Oracle Natural Join in Oracle Cross Join in Oracle Outer Join - (Left Outer Join, Right Outer Join and Full Outer Join) in Oracle Anti Join in Oracle Column Format in Oracle Aggregate Functions in Oracle Character Functions in Oracle Number Functions in Oracle Conversion Functions To Char, To Date, NVL, Decode in Oracle Date Functions - Add Months, Last Day, Months Between, Next Day, To Date, New Time in Oracle SQL Commands Type in Oracle SQL Buffer Commands in Oracle Ed or Edit Buffer Command in Oracle IN and NOT IN Operators in Oracle Not Null Constraint in Oracle Unique Constraint in Oracle Primary Key and Foreign Key Constraints in Oracle Check Constraint in Oracle Order By Clause in Oracle Group By Clause in Oracle Having Clause in Oracle Subquery or Inner Query or Nested Query in Oracle Union, Union All, Intersect and Minus Operators in Oracle Data Dictionaries TAB, ALL TABLES, ALL SEQUENCES, ALL VIEWS etc in Oracle What are SQL, PLSQL, TSQL and SQL Plus ALTER TABLE ADD new column and DROP existing column in Oracle ALTER TABLE to Modify existing column in Oracle ALTER TABLE to ADD and DROP integrity constraints in Oracle Create, Alter and Drop Sequence in Oracle Create, Alter and Drop named constraints in Oracle Subquery in Oracle Set Union, Union All, Intersect, Minus Operators in Oracle Execute commands written in physical file Getting started with SQL Plus Reports - Part 1 Getting started with SQL Plus Reports - Part 2 Getting started with SQL Plus Reports - Part 3 Views in Oracle Input Variables in Oracle SQL Plus Define Variables in Oracle Bind Variables in Oracle Introduction to PLSQL in Oracle IF ELSE construct in PLSQL Oracle FOR LOOP Looping Command in PLSQL Oracle LOOP Looping Command in PLSQL Oracle WHILE Looping Command in PLSQL Oracle PLSQL Table in Oracle Exception in PLSQL Oracle Tax Calculator and Exception Handling in PLSQL Oracle Introduction to Cursor in PLSQL Oracle Cursor Examples in PLSQL Oracle UPDATE and DELETE using Cursor in PLSQL Oracle Introduction to TRIGGER in PLSQL Oracle AFTER INSERT fire UPDATE Command in Trigger AFTER INSERT or UPDATE or DELETE Commands in Trigger Statement Level Trigger in PLSQL Oracle
Views: 64 Aap Koun
Learn Oracle | How to use the Transactional Control Statements in SQL
 
04:32
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
Views: 77 Pebbles Tutorials
SQL: Oracle Architecture Physical Layout Part-2
 
07:09
In this tutorial, you'll learn physical layout in oracle architecture..
Views: 1996 radhikaravikumar
What is Database
 
03:02
SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations. Watch this Video to learn basics of SQL. This Video covers below topics about SQL. What is Database What is Database Table What is Database Fields and Records What is Oracle What is RDBMS and how it is different from flat files What is SQL Is SQL common for all RDBMS packages, prove it Installing Oracle CREATE, INSERT and SELECT commands DELETE and UPDATE commands SELECT command with WHERE condition LIKE 'pattern' Operator IN Operator BETWEEN Operator Pseudo Columns Data Types in Oracle ORDER BY Clause in Oracle RENAME Table and DROP Table in Oracle Savepoint, Rollback and Commit in Oracle Create Tablespace, Create User, Create Role, Drop Role, Drop User, Drop Tablespace in Oracle Tablespace and Datafile in Oracle Alter Tablespace in Oracle Insert multiple records in one or more tables at once in Oracle Grant, Revoke and Grant Table View to other user in Oracle Referential Integrity in Oracle Column Alias in Oracle Table Alias in Oracle Equi Join and Non Equi Join in Oracle Self Join in Oracle Natural Join in Oracle Cross Join in Oracle Outer Join - (Left Outer Join, Right Outer Join and Full Outer Join) in Oracle Anti Join in Oracle Column Format in Oracle Aggregate Functions in Oracle Character Functions in Oracle Number Functions in Oracle Conversion Functions To Char, To Date, NVL, Decode in Oracle Date Functions - Add Months, Last Day, Months Between, Next Day, To Date, New Time in Oracle SQL Commands Type in Oracle SQL Buffer Commands in Oracle Ed or Edit Buffer Command in Oracle IN and NOT IN Operators in Oracle Not Null Constraint in Oracle Unique Constraint in Oracle Primary Key and Foreign Key Constraints in Oracle Check Constraint in Oracle Order By Clause in Oracle Group By Clause in Oracle Having Clause in Oracle Subquery or Inner Query or Nested Query in Oracle Union, Union All, Intersect and Minus Operators in Oracle Data Dictionaries TAB, ALL TABLES, ALL SEQUENCES, ALL VIEWS etc in Oracle What are SQL, PLSQL, TSQL and SQL Plus ALTER TABLE ADD new column and DROP existing column in Oracle ALTER TABLE to Modify existing column in Oracle ALTER TABLE to ADD and DROP integrity constraints in Oracle Create, Alter and Drop Sequence in Oracle Create, Alter and Drop named constraints in Oracle Subquery in Oracle Set Union, Union All, Intersect, Minus Operators in Oracle Execute commands written in physical file Getting started with SQL Plus Reports - Part 1 Getting started with SQL Plus Reports - Part 2 Getting started with SQL Plus Reports - Part 3 Views in Oracle Input Variables in Oracle SQL Plus Define Variables in Oracle Bind Variables in Oracle Introduction to PLSQL in Oracle IF ELSE construct in PLSQL Oracle FOR LOOP Looping Command in PLSQL Oracle LOOP Looping Command in PLSQL Oracle WHILE Looping Command in PLSQL Oracle PLSQL Table in Oracle Exception in PLSQL Oracle Tax Calculator and Exception Handling in PLSQL Oracle Introduction to Cursor in PLSQL Oracle Cursor Examples in PLSQL Oracle UPDATE and DELETE using Cursor in PLSQL Oracle Introduction to TRIGGER in PLSQL Oracle AFTER INSERT fire UPDATE Command in Trigger AFTER INSERT or UPDATE or DELETE Commands in Trigger Statement Level Trigger in PLSQL Oracle
Views: 43 Aap Koun
Data Types in Oracle
 
05:11
SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations. Watch this Video to learn basics of SQL. This Video covers below topics about SQL. What is Database What is Database Table What is Database Fields and Records What is Oracle What is RDBMS and how it is different from flat files What is SQL Is SQL common for all RDBMS packages, prove it Installing Oracle CREATE, INSERT and SELECT commands DELETE and UPDATE commands SELECT command with WHERE condition LIKE 'pattern' Operator IN Operator BETWEEN Operator Pseudo Columns Data Types in Oracle ORDER BY Clause in Oracle RENAME Table and DROP Table in Oracle Savepoint, Rollback and Commit in Oracle Create Tablespace, Create User, Create Role, Drop Role, Drop User, Drop Tablespace in Oracle Tablespace and Datafile in Oracle Alter Tablespace in Oracle Insert multiple records in one or more tables at once in Oracle Grant, Revoke and Grant Table View to other user in Oracle Referential Integrity in Oracle Column Alias in Oracle Table Alias in Oracle Equi Join and Non Equi Join in Oracle Self Join in Oracle Natural Join in Oracle Cross Join in Oracle Outer Join - (Left Outer Join, Right Outer Join and Full Outer Join) in Oracle Anti Join in Oracle Column Format in Oracle Aggregate Functions in Oracle Character Functions in Oracle Number Functions in Oracle Conversion Functions To Char, To Date, NVL, Decode in Oracle Date Functions - Add Months, Last Day, Months Between, Next Day, To Date, New Time in Oracle SQL Commands Type in Oracle SQL Buffer Commands in Oracle Ed or Edit Buffer Command in Oracle IN and NOT IN Operators in Oracle Not Null Constraint in Oracle Unique Constraint in Oracle Primary Key and Foreign Key Constraints in Oracle Check Constraint in Oracle Order By Clause in Oracle Group By Clause in Oracle Having Clause in Oracle Subquery or Inner Query or Nested Query in Oracle Union, Union All, Intersect and Minus Operators in Oracle Data Dictionaries TAB, ALL TABLES, ALL SEQUENCES, ALL VIEWS etc in Oracle What are SQL, PLSQL, TSQL and SQL Plus ALTER TABLE ADD new column and DROP existing column in Oracle ALTER TABLE to Modify existing column in Oracle ALTER TABLE to ADD and DROP integrity constraints in Oracle Create, Alter and Drop Sequence in Oracle Create, Alter and Drop named constraints in Oracle Subquery in Oracle Set Union, Union All, Intersect, Minus Operators in Oracle Execute commands written in physical file Getting started with SQL Plus Reports - Part 1 Getting started with SQL Plus Reports - Part 2 Getting started with SQL Plus Reports - Part 3 Views in Oracle Input Variables in Oracle SQL Plus Define Variables in Oracle Bind Variables in Oracle Introduction to PLSQL in Oracle IF ELSE construct in PLSQL Oracle FOR LOOP Looping Command in PLSQL Oracle LOOP Looping Command in PLSQL Oracle WHILE Looping Command in PLSQL Oracle PLSQL Table in Oracle Exception in PLSQL Oracle Tax Calculator and Exception Handling in PLSQL Oracle Introduction to Cursor in PLSQL Oracle Cursor Examples in PLSQL Oracle UPDATE and DELETE using Cursor in PLSQL Oracle Introduction to TRIGGER in PLSQL Oracle AFTER INSERT fire UPDATE Command in Trigger AFTER INSERT or UPDATE or DELETE Commands in Trigger Statement Level Trigger in PLSQL Oracle
Views: 8 Aap Koun
2. What are SQL Commands?
 
07:12
SQL Commands-Data Definition Language Commands, Data Manipulation Language Commands, Data Control Language Commands, and Transaction Control Language Commands. What are SQL Commands? SQL is a command based language, used for storing and managing data in RDBMS. SQL doesn't have Control Flow (Conditional, Loop, and Branching Statements., but SQL has Comments, Data Types, Operators, Functions etc...programming features. RDBMS(MySql, Oracle, Infomix, Sybase, MS Access. uses SQL as the standard database language. SQL is used to perform all type of data operations in RDBMS. SQL Commands can be divided into the following categories, 1. Data Definition Language (DDL. 2. Data Manipulation Language (DML. 3. Transaction Control Language (TCL. 4. Data Control Language (DCL. 1. Data Definition Language (DDL. Data Definition Language Commands are used to Create, Modify, and Drop the Structure of Database Objects like Table, View, and Index etc... Important DDL Commands i. Create ii. Alter iii. Drop iv. Truncate v. Rename Important DDL Operations i. Create a Database ii. Use Database iii. Rename a Database iv. Drop Database v. Create a Table vi. Rename Table vii. Add a Column to exiting Table viii. Add multiple columns to existing Table ix. Modify an existing column x. Rename a Column xi. Drop a Column xii. Truncate a Table xiii. Drop a Table 2. Data Manipulation Language (DML. Data Manipulation Language commands are used to store, modify, retrieve, and delete data from database tables. Important Data manipulation language Commands are, i. SELECT – Retrieves data from a table ii. INSERT – Inserts data into a table iii. UPDATE – Updates existing data into a table iv. DELETE – Deletes all records from a table 3. Transaction Control Language (TCL. These commands can annul changes made by other commands by rolling back to original state and also make changes permanent. Important Transaction Control Language are, i. Commit - To permanently save ii. Rollback To undo change iii. Savepoint To save temporarily 4. Data Control Language (DCL. These SQL Commands DCL are used to implement security on Database objects like Table, View, Stored Procedure etc... Important Data Control Language are, i. Grant - grant permission of right ii. Revoke - Take back permission. iii. Deny - Deny Permissions to a User
Views: 2351 G C Reddy
What is Database Fields and Records
 
01:34
SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations. Watch this Video to learn basics of SQL. This Video covers below topics about SQL. What is Database What is Database Table What is Database Fields and Records What is Oracle What is RDBMS and how it is different from flat files What is SQL Is SQL common for all RDBMS packages, prove it Installing Oracle CREATE, INSERT and SELECT commands DELETE and UPDATE commands SELECT command with WHERE condition LIKE 'pattern' Operator IN Operator BETWEEN Operator Pseudo Columns Data Types in Oracle ORDER BY Clause in Oracle RENAME Table and DROP Table in Oracle Savepoint, Rollback and Commit in Oracle Create Tablespace, Create User, Create Role, Drop Role, Drop User, Drop Tablespace in Oracle Tablespace and Datafile in Oracle Alter Tablespace in Oracle Insert multiple records in one or more tables at once in Oracle Grant, Revoke and Grant Table View to other user in Oracle Referential Integrity in Oracle Column Alias in Oracle Table Alias in Oracle Equi Join and Non Equi Join in Oracle Self Join in Oracle Natural Join in Oracle Cross Join in Oracle Outer Join - (Left Outer Join, Right Outer Join and Full Outer Join) in Oracle Anti Join in Oracle Column Format in Oracle Aggregate Functions in Oracle Character Functions in Oracle Number Functions in Oracle Conversion Functions To Char, To Date, NVL, Decode in Oracle Date Functions - Add Months, Last Day, Months Between, Next Day, To Date, New Time in Oracle SQL Commands Type in Oracle SQL Buffer Commands in Oracle Ed or Edit Buffer Command in Oracle IN and NOT IN Operators in Oracle Not Null Constraint in Oracle Unique Constraint in Oracle Primary Key and Foreign Key Constraints in Oracle Check Constraint in Oracle Order By Clause in Oracle Group By Clause in Oracle Having Clause in Oracle Subquery or Inner Query or Nested Query in Oracle Union, Union All, Intersect and Minus Operators in Oracle Data Dictionaries TAB, ALL TABLES, ALL SEQUENCES, ALL VIEWS etc in Oracle What are SQL, PLSQL, TSQL and SQL Plus ALTER TABLE ADD new column and DROP existing column in Oracle ALTER TABLE to Modify existing column in Oracle ALTER TABLE to ADD and DROP integrity constraints in Oracle Create, Alter and Drop Sequence in Oracle Create, Alter and Drop named constraints in Oracle Subquery in Oracle Set Union, Union All, Intersect, Minus Operators in Oracle Execute commands written in physical file Getting started with SQL Plus Reports - Part 1 Getting started with SQL Plus Reports - Part 2 Getting started with SQL Plus Reports - Part 3 Views in Oracle Input Variables in Oracle SQL Plus Define Variables in Oracle Bind Variables in Oracle Introduction to PLSQL in Oracle IF ELSE construct in PLSQL Oracle FOR LOOP Looping Command in PLSQL Oracle LOOP Looping Command in PLSQL Oracle WHILE Looping Command in PLSQL Oracle PLSQL Table in Oracle Exception in PLSQL Oracle Tax Calculator and Exception Handling in PLSQL Oracle Introduction to Cursor in PLSQL Oracle Cursor Examples in PLSQL Oracle UPDATE and DELETE using Cursor in PLSQL Oracle Introduction to TRIGGER in PLSQL Oracle AFTER INSERT fire UPDATE Command in Trigger AFTER INSERT or UPDATE or DELETE Commands in Trigger Statement Level Trigger in PLSQL Oracle
Views: 37 Aap Koun