Learn how to create a table based record type variable in Oracle Database By Manish Sharma from RebellionRider.com
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog : http://bit.ly/table-based-records
Previous Tutorial
► Introduction To Records: https://youtu.be/1iHbZDuDbis
► SELECT-INTO Statement: https://youtu.be/Zt0vlmTqhP4
-------------------------------------------------------------------------
►►►Let's Get Free Uber Cab◄◄◄
Use Referral Code UberRebellionRider and get $20 free for your first ride.
-------------------------------------------------------------------------
►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
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/rebellionrider/
___Facebook Official Page___
https://www.facebook.com/RebellionRider.official/
You can also Email me at
for E-mail address please check 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

Learn Table Auditing using DML Triggers in Oracle Database and Increase the level of security by keep an eye on user tempering your table data.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog : http://bit.ly/table-auditing
Previous Tutorial
► DML Triggers with Examples https://youtu.be/-OR7zLzCh_I
► Select-Into Statement: https://youtu.be/F5eMJhwmCQs
►Sysdate Blog : http://bit.ly/sysdate-in-oracle-by-rebellionrider
-------------------------------------------------------------------------
►►►Let's Get Free Uber Cab◄◄◄
Use Referral Code UberRebellionRider and get $20 free for your first ride.
-------------------------------------------------------------------------
►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
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/rebellionrider/
You can also Email me at
for E-mail address please check 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

“External tables can be a fantastic tool for reading files into your database using SQL,” says Oracle SQL Developer advocate Chris Saxon. “However, they can be a bit tricky to work with.” In this 2 Minute Tech Tip recorded at ODTUG Kscope 2018, Chris explains how using the external table parameter override clause can make things a lot less tricky, and, even better, how Oracle Database 18c allows you to create inline external tables.
https://developer.oracle.com/
https://cloud.oracle.com/en_US/tryit

Christopher Jones, Senior Principal Product Manager, Oracle
Anthony Tuininga, Software Developer 5, Oracle
Python is hot and desirable. The cx_Oracle API for Oracle Database adds spice that hotness. In this session see how cx_Oracle can be used to build functional, high-performance Python apps that make the best use of database functionality and resources. The cx_Oracle interface is arguably the most popular way of accessing Oracle Database. This session shows how to use its features in the best possible way.

PL/SQL Tutorial 1 (Oracle): Importing data from an Excel Spreadsheet
In this tutorial I show you how to import data from excel into a table in Oracle PL/SQL Developer.
Source Code: https://github.com/mitchtabian/SQL-tutorials
Subscribe to my Blog and YouTube channel to get notifications when new FREE coding tutorials are posted!
Blog: http://www.codingwithmitch.com/

This video will show you " Oracle tutorial: What is Virtual column in Oracle PL SQL "
sql calculated field
computed column
oracle-11g-new-feature-virtual-column
Oracle tutorial : What is Virtual column in oracle
Syntax :
column_name [datatype] [GENERATED ALWAYS] AS [expression] [VIRTUAL]
1)The values of the virtual column are not stored in the database.
2)You can not update the values of virtual column.
3)when you try to modify it will give oracle error.
4)These are read only values.
5)Virtual columns used in the WHERE clause of UPDATE and DELETE statement
6)Constraints can be created on them.
#techquerypond
https://techquerypond.wordpress.com
https://twitter.com/techquerypond

Manish Sharma from RebellionRider presents you the latest PL/SQL tutorial on Collection ASSOCIATIVE ARRAY. In this video, you will learn –
- What are Associative Arrays?
- How to create Associative Arrays?
- How to Insert & Update the data of Associative Array and
- How to retrieve the data from an Associative array using two different ways?
So if you are wondering whether associative array is a persistent form of collection or not; Is it bounded or unbounded in nature; why should we use this specific collection over others such as VARRAY or Nested Table; What are the differences or similarities between associative array and other collections? Then go ahead and watch the video to find out the answers to all these questions.
Hope you will enjoy watching. Do make sure to Like and Share this post/video because that will help others in learning as well as help me and my channel in reaching out. This way we can educate more and more people for FREE. Most importantly SUBSCRIBE to the channel as many such interesting tutorials are coming your way. Thanks.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/associative-array
Previous Tutorial
►While Loop: https://youtu.be/IIlc4Sr7kFE
-------------------------------------------------------------------------
►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

PL/SQL tutorial for beginners on Table Based Records Data types in Oracle Database By Manish Sharma at RebellionRider.com
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog : http://bit.ly/table-based-record-2
Previous Tutorial
► Introduction To Records: https://youtu.be/1iHbZDuDbis
► Table Based Record Part 1: https://youtu.be/8WqpqKUj9l8
-------------------------------------------------------------------------
►►►Let's Get Free Uber Cab◄◄◄
Use Referral Code UberRebellionRider and get $20 free for your first ride.
-------------------------------------------------------------------------
►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
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/rebellionrider/
___Facebook Official Page___
https://www.facebook.com/RebellionRider.official/
You can also Email me at
for E-mail address please check 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

This video demonstrates how a function can return multiple values to the calling environment, but without using multiple out parameters, the video shows an example on how we can create a object, a nested table based on the object and then returning the nested table type from the function.

RebellionRider.com presents a PL/SQL tutorial on how to use the BULK COLLECT clause with SELECT INTO statement in Oracle Database by Manish Sharma. In this tutorial, you will also learn how to overcome the overhead caused by context switch and improve the query performance.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/bulk-collect-2
Previous Tutorial
►Introduction to Bulk Collect: https://youtu.be/CrJSlf_m3yA
►PL/SQL Tutorial 51-Nested Table: https://youtu.be/EUYyiFCzU0I
►Collection Method Count:https://youtu.be/NNq80CcC5K8
-------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
-------------------------------------------------------------------------
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on
https://twitter.com/rebellionrider
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
___Facebook Official Page of Manish Sharma___
https://www.facebook.com/TheRebellionRider/
___Facebook Official Page of RebellionRider.com___
https://www.facebook.com/RebellionRider.official/
You can also Email me at
for E-mail address please check the About section
Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

Introduction to PL/SQL VARRAYs in Oracle Database by Manish Sharma from RebellionRider.com. Make sure to subscribe as in next tutorial we will do some example and learn how to create VARRAYs
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog : http://bit.ly/varrays
Previous Tutorial
► Create Nested Table: https://youtu.be/cv-WdeFLCvk
-------------------------------------------------------------------------
►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

www.RebellionRider.com- Learn How To Create Cursor Based Record Datatype Variable in Oracle Database with easy Examples.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog : http://bit.ly/cursor-records
Previous Tutorial
►Table Based Record https://youtu.be/8WqpqKUj9l8
► Simple Explicit Cursor https://youtu.be/3q7dW_d2KVc
-------------------------------------------------------------------------
►►►Let's Get Free Uber Cab◄◄◄
Use Referral Code UberRebellionRider and get $20 free for your first ride.
-------------------------------------------------------------------------
►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
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/rebellionrider/
___Facebook Official Page___
https://www.facebook.com/RebellionRider.official/
You can also Email me at
for E-mail address please check 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

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

Learn in depth about trigger in oracle database 11g, and usage of trigger in Database, different types of trigger with syntax for various events along with writing advance trigger and capturing all details regarding authentication. Explained Instead of trigger.
Trigger in Oracle,
Trigger in PL/SQL,
Oracle Trigger,
PL/SQL Trigger,
What is Trigger in pl/sql,
How to use Trigger in pl/sql,
How to write a Trigger in oracle,
How to design Trigger in pl/sql,
DDL trigger,
DML trigger,
Instead of trigger,
Compound trigger,
Logon trigger,
Introduction to Triggers
You can write triggers that fire whenever one of the following operations occurs:
DML statements (INSERT, UPDATE, DELETE) on a particular table or view, issued by any user
DDL statements (CREATE or ALTER primarily) issued either by a particular schema/user or by any schema/user in the database
Database events, such as logon/logoff, errors, or startup/shutdown, also issued either by a particular schema/user or by any schema/user in the database
Triggers are similar to stored procedures. A trigger stored in the database can include SQL and PL/SQL or Java statements to run as a unit and can invoke stored procedures. However, procedures and triggers differ in the way that they are invoked. A procedure is explicitly run by a user, application, or trigger. Triggers are implicitly fired by Oracle when a triggering event occurs, no matter which user is connected or which application is being used.
How Triggers Are Used
Triggers supplement the standard capabilities of Oracle to provide a highly customized database management system. For example, a trigger can restrict DML operations against a table to those issued during regular business hours. You can also use triggers to:
Automatically generate derived column values
Prevent invalid transactions
Enforce complex security authorizations
Enforce referential integrity across nodes in a distributed database
Enforce complex business rules
Provide transparent event logging
Provide auditing
Maintain synchronous table replicates
Gather statistics on table access
Modify table data when DML statements are issued against views
Publish information about database events, user events, and SQL statements to subscribing applications
Linkedin: https://www.linkedin.com/in/aditya-kumar-roy-b3673368/
Facebook: https://www.facebook.com/SpecializeAutomation/

This video demonstrates examples on how to find and delete duplicate records from a table. The video gives simple and easy to understand examples on finding duplicate records from a table using group by and having clause and row_number function. It also shows the ways in which duplicates can be deleted very efficiently using the rowid of that record.
You can get the code from our website
http://oracleplsqlblog.com/FullBlog/FullBlog/21

How to initialize the variable by fetching values from the table of the database or by using SELECT INTO statement in PL/SQL by Manish Sharma RebellionRider
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog : http://bit.ly/select-into-statement-pl-sql
Previous Tutorial
► Variables: https://youtu.be/2MNmodawvnE
-------------------------------------------------------------------------
►►►Let's Get Free Uber Cab◄◄◄
Use Referral Code UberRebellionRider and get $20 free for your first ride.
--------------------------------------------------------------------------
►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
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/rebellionrider/
You can also Email me at
for E-mail address please check 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

Learn how to create a DDL Trigger in Oracle Database with Schema Auditing Example where we will learn how to keep an any on which object is created, altered or drop and by who. Manish Sharma From RebellionRider
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog : http://bit.ly/DDL-Trigger
Previous Tutorial
►PL/SQL Tut 14 Triggers Introduction
https://youtu.be/R3fvX_xf5P4
► PL/SQL Tut 17 Table Backup Using DML Trigger
https://youtu.be/jSv1LIlNKU0
-------------------------------------------------------------------------
►►►Let's Get Free Uber Cab◄◄◄
Use Referral Code UberRebellionRider and get $20 free for your first ride.
-------------------------------------------------------------------------
►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
https://www.facebook.com/imthebhardwaj
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
http://rebellionrider.tumblr.com/
http://www.pinterest.com/rebellionrider/
You can also Email me at
for E-mail address please check 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

RebellionRider.com presents PL/SQL Tutorial on How to Create PL/SQL Package in Oracle Database by Manish Sharma
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog : http://bit.ly/create-package
Previous Tutorial
►PL/SQL Function - https://youtu.be/6OJIrPx61mU
► PL/SQL Procedure - https://youtu.be/buaSuEMi4lw
-------------------------------------------------------------------------
►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___
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

This video tutorial explains how an oracle procedure can return multiple values with a proper example. The video tutorial shows how this problem can be tacked using simple and easy to understand out parameters!!!

This video tutorial talks about the frequently asked oracle sql interview question of changing rows to the column. Based on the given scenario, we are asked to change the presentation of data in a table with 3 rows and 2 column to 3 columns and 2 rows.
Decode Function in oracle
https://youtu.be/YUAjPMjqMws
Pivot and unpivot in oracle
https://youtu.be/6s0DI1YcWIM

The audio and video now synced.
Ever tried creating a table inside a PL SQL block, or a function or a procedure? If yes, then you would know that it would raise an error, as DDL statements are not allowed inside a PL/SQL Block. So the solution to such a case, where you want to generate tables, or sequences or want to execute any DDL statement on the fly, then use synamic sql. Dynamic SQL statment will allow you to create state statements on the fly and then you can execute them using the execute immediate statement. This video tutorial demonstrates on this topic of using synamic sql with execute immediate in a PL/SQL block.