Home
Search results “Loop update oracle”
PL/SQL tutorial 13: PL/SQL FOR Loop In Oracle Database by Manish Sharma RebellionRider.com
 
06:14
3rd and the last tutorial in Iterative/loop statement in Oracle PL/SQL series explaining concepts of FOR loop with examples by Manish Sharma RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/numeric-for-loop-in-pl-sql Previous Tutorial ► While Loop https://youtu.be/IIlc4Sr7kFE ------------------------------------------------------------------------- ►►►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
Views: 56899 Manish Sharma
PL/SQL tutorial 30: Cursor FOR Loop In Oracle Database By Manish Sharma
 
04:33
Learn How To Work with Database (Explicit or Implicit) Cursors using Cursor For Loop in Oracle Database With Example By Manish Sharma on RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/cursor-for-loop-1 Previous Tutorial ► Numeric For Loop: https://youtu.be/DfAmnj2j7WI ►Install SQL Developer: https://youtu.be/zliF8kXVmeE ------------------------------------------------------------------------- ►►►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
Views: 40075 Manish Sharma
PL/SQL: Cursors using FOR loop
 
05:10
In this tutorial, you'll learn h.ow to write a cursor using for loop and the advantage of it. 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: 18064 radhikaravikumar
69- Oracle PL SQL Loops - While Loop تعليم أوراكل
 
09:01
by Mohamed El Desouki - محمد الدسوقى [email protected] Tel :00966 553450836 جامعة سلمان بن عبد العزيز - السعودية - الخرج Database 2 - PL/SQL - While Loop Statement in Arabic Text Book: Fundamentals of Database Systems, 5th Edition, by Elmasri/Navathe, published by Addison-W
81/125 Oracle PLSQL: Design consideration  / Bulk Binding 2
 
14:03
Learn Oracle PLSQL EXAM 1Z0-144 Bulk Binding Bulk collect begin dbms_output.put_line(sqlerrm (-12899)); end; ------------------------------------------------------------- -------------------------------------------------------------- drop table ename; create table ename as select distinct first_name from employees; select first_name from ename; declare type ename_t is table of varchar2(100); ename_table ename_t:=ename_t(); c number:=0; errors number; begin for i in (select * from ename ) loop c:=c+1; ename_table.extend; ename_table(c):=i.first_name; end loop; forall i in ename_table.first.. ename_table.last save exceptions update ename set first_name=first_name||' to be added:)' --14 char where first_name=ename_table(i); exception when others then errors := sql%bulk_exceptions.count; dbms_output.put_line ('The total number of errors occured are '|| errors); for j in 1..errors loop dbms_output.put_line ('The error iteration is ' || sql%bulk_exceptions(j).error_index || ' and the error code is ' || sql%bulk_exceptions(j).error_code || ' and the error message is ' || sqlerrm ( -sql%bulk_exceptions(j).error_code) ); end loop; end; select * from ename ----------------------------- drop table ename; create table ename as select distinct first_name from employees; select first_name from ename; declare type ename_t is table of varchar2(100); ename_table ename_t:=ename_t(); c number:=0; errors number; begin /* for i in (select * from ename ) loop c:=c+1; ename_table.extend; ename_table(c):=i.first_name; end loop; */ select first_name bulk collect into ename_table from ename; forall i in ename_table.first.. ename_table.last save exceptions update ename set first_name=first_name||' to be added:)' --14 char where first_name=ename_table(i); exception when others then errors := sql%bulk_exceptions.count; dbms_output.put_line ('The total number of errors occured are '|| errors); for j in 1..errors loop dbms_output.put_line ('The error iteration is ' || sql%bulk_exceptions(j).error_index || ' and the error code is ' || sql%bulk_exceptions(j).error_code || ' and the error message is ' || sqlerrm ( -sql%bulk_exceptions(j).error_code) ); end loop; end; select * from ename
Views: 527 khaled alkhudari
👶 3D Baby, Looping a Blanket, 🤰🏼Thoughts on Pregnancy and Motherhood
 
20:47
01:22 - On week 34 we got to see little baby in 3D and confirm the gender :) 03:00 - I'll show you a looped blanket that I'm making while sharing some thoughts on pregnancy thus far. 15:58 - Getting a bit frustrated and overwhelmed on week 35. Thanks for sharing our journey with us! :D Please like, comment and subscribe! :) ♥ #34weeks #35weeks #pregnancy
Views: 138671 Sassy Masha Vlogs
12- Oracle PL/SQL Arabic Course  Cursor for loop اوراكل  ديفلوبر
 
14:01
أهلا بكم فى درس جديد من سلسلة دروس أوراكل ديفلوبر شرح PL SQL فى درس اليوم نتحدث عن Cursor for loop for update current of .......................................­.................... تواصل معانا علي الفيس بوك من هنا : https://www.facebook.com/askgad .......................................­.................... تواصل معانا علي موقعنا من هنا : https://www.askgad.com
Views: 3672 Ask Gad
loops in plsql
 
22:32
for loop in plSql while Loop in plSql Exit loop infinite loop in plSql
Views: 176 Wael Albetar
UPDATE ON EAT READ LOVE! BE ON THE LOOP!
 
01:49
EXTENDED READING VIMEO LINK :https://vimeo.com/ondemand/EATREADLOVE BOOK A READING www.salbiadora.com ONLINE SHOP : https://www.jupiterincancer.com/ CHITCHAT CHANNEL LINK: https://www.youtube.com/channel/UCh8PzIjMog8sWs1D6e9lduw GO FUND ME: https://www.gofundme.com/SOULORACLE Hi Everyone! I will be going on a journey to make Soul Inspirational Oracle Cards by donating you will be touching peoples lives the way that I have touch your lives, we will spread inspiration, dreams and love it all starts with this little channel and your donation =) PURCHASE TAROT LEVEL 1 CLASS: https://www.salbiadora.com/product-page/tarot-class-level-1 ONLINE SHOP : https://www.jupiterincancer.com/ GET YOUR ASTROLOGY CHART HERE: http://www.horoscopeswithin.com/birthchart.php GET YOUR ASTROLOGY CHART HERE: http://www.horoscopeswithin.com/birthchart.php TAROT FOR ENTERTAINMENT ONLY
Views: 46089 EAT READ LOVE INC
21/125 Oracle PLSQL: Nested Loops & Labels
 
09:01
تعلم اوراكل دورات اوراكل learn Oracle
Views: 1315 khaled alkhudari
Fix  Kali Linux Login Loop [Solved]
 
04:00
***********Login Screen fix************ LIKE | COMMENT | SHARE | SUBSCRIBE This video shows how to quickly fix the login screen loop in the Kali Linux. The fix is very easy: While at the login screen press Ctrl+Alt+F1 or Ctrl+Alt+F2 to open terminal after that type the username and password in terminal. Now follow commands as below 1 -sudo apt-get update 2 -sudo apt-get upgrade 3 -dpkg --configure -a 4 -sudo apt-get install cinnamon-control-center-data 5 -gdm3 --version 6 -apt-get --reinstall install gdm3 7 -apt-get --reinstall install gnome 8 -apt-get --reinstall install gnome-shell 9 -dpkg-reconfigure gdm3 10-reboot Fix Kali Linux sources.list Repositories http://www.kalitut.com/2014/06/fix-kali-linux-sourceslist-repositories.html
Views: 9775 KaliTut
72. LOOP Looping Command in PL/SQL Oracle
 
02:20
In this video you will learn about LOOP Looping Command 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: 3510 ITORIAN
Oracle SQL MERGE Statement
 
07:52
https://www.databasestar.com/oracle-merge-sql/ In this video, we’ll learn what the Oracle MERGE statement does and how you can use it. What is the MERGE statement? It’s a statement that lets you either insert or update data in a table - all in a single statement! It’s helpful if you’re using an ETL (Extract Transform Load) process when creating or updating a data warehouse. It’s also helpful when loading data into your own database if you’re not creating a data warehouse. It allows you to prevent duplicate data and ensure you have up-to-date data in your table. The syntax looks like this: MERGE INTO table_name USING table_name ON (condition) WHEN MATCHED THEN update_clause DELETE where_clause WHEN NOT MATCHED THEN insert_clause [LOG ERRORS log_errors_clause reject_limit integer | unlimited ] In this video, I also show an Oracle SQL MERGE statement example, so watch the video to find out more. For more information on the MERGE statement and how you can use it in your queries, read the related article here: https://www.databasestar.com/oracle-merge-sql/
Views: 909 Database Star
SQL Server Programming Part 6 - WHILE Loops
 
14:48
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andrew Gould https://www.wiseowl.co.uk - In SQL Server there is only one type of loop: a WHILE loop. This video teaches you how to use them, from the basic syntax of the WHILE statement, through how to use a SELECT statement within a loop. We'll also cover how to use the BREAK command to exit from a loop, what to do when you inevitably find yourself in an endless loop and, finally, a quick introduction to using loops with cursors. You can download the script to create the Movies database used in this video at the following link: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip You can see the range of resources and courses we offer in SQL Server here: https://www.wiseowl.co.uk/sql/ Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Views: 74997 WiseOwlTutorials
Tutorial 47 - LOOP in PLPGSQL
 
07:58
Learns about loop in PLPGSQL
Views: 5226 Programming Guru
PL/SQL tutorial 31: Cursor For Loop With Parameterized Cursor In Oracle Database
 
04:24
PL/SQL tutorial 31 Database Cursor for loop part 2. Learn how to work with parameterized cursor using Cursor For Loop in Oracle Database By Manish Sharma at RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/cursor-for-loop-with-parameter-cursor Previous Tutorial ► Cursor For Loop with Simple Cursor https://youtu.be/abgVNjPaMVA ►PL/SQL For Loop: https://youtu.be/DfAmnj2j7WI ------------------------------------------------------------------------- ►►►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
Views: 28716 Manish Sharma
Oracle Pl/sql Cursors (Implicit, Explicit, Open-Fetch-Close, FOR LOOP cursors, Cursor Attributes)
 
21:53
This video is to understand the concept of Oracle PL/SQL Cursors (implicit and explicit ). The video includes tutorial on how to work with Oracle PL/SQL Cursor in everyday programming.
Views: 4354 Kishan Mashru
How to Fetch Data By Using Cursor for loop In Oracle Form
 
06:55
How to Fetch Data By Using Cursor for loop In Oracle Form
Views: 162 Young India
February 2019 UPDATE - FUTURE AZ Loop 202 - South Mountain Freeway - Pecos Rd Alignment Pre-Closure!
 
05:33
**Expand for more detail on this road!!** IMPORTANT: Starting February 20th, 2018, my channel will no longer be eligible for monetization because I do not have 1,000 subscribers. I ask that if you enjoyed this video, and would like to see more from me, please consider subscribing or becoming a Patreon supporter. My goal is to reach 1,000 subscribers by the end of 2019. Please help us reach that goal! Well, here it is. The last, complete, final look at Pecos Road before traffic starts to be diverted off the old (and partly reconstructed road) and onto the new freeway. Starting today, February 11th 2019, the section of Pecos from Desert Foothills Parkway to 17th Ave will be closed permanently to traffic and will be diverted onto the eastbound lanes of the future freeway. This will be done to facilitate the building of not just the shared use Pecos Path, but also so construction can start on the Desert Foothills interchange, the last interchange to start construction on the entire South Mountain Freeway. The new light installed on Pecos Rd will move traffic onto the new alignment and serve the temporary intersection for Desert Foothills Parkway. With the completion date of the freeway set for the end of 2019, things are progressing quickly. Connect 202 Partners are firing on all cylinders to get the freeway done, as can be see in this video. The most staggering change is the new 32nd Street overpass, as well as the 32nd St interchange, which was just added to the project about a year ago due to community traffic concerns. That is the part shown in the thumbnail of the video. Look out for more updates on the South Mountain Freeway, and watch my old videos to look pack on how this area has changed. Thanks for watching! Follow and Support Me: Website: forgottenhwy.com Twitter: http://bit.ly/hwytweet Instagram: http://bit.ly/hwyinsta Facebook: http://bit.ly/hwyfacebook Patreon: http://bit.ly/hwypatreon Music: Track 1: Heartbeat (feat. Veronica Bravo) - Rival & Cadmium Cadmium: YouTube: www.youtube.com/c/Cadmiumsound Twitter: @cadmiumsound Facebook: www.facebook.com/cadmium.sound/ Instagram: www.instagram.com/Cadmium.sound/ Spotify: goo.gl/EhKdX5 Rival: @rival_official Facebook: www.facebook.com/sounds.rival YouTube: www.youtube.com/rivalofficial Twitter: twitter.com/rivaltweet Veronica Bravo Facebook: goo.gl/5TNNm1 Instagram: www.instagram.com/bravoveroni... Twitter: twitter.com/OfficialVBravo YouTube: goo.gl/SfdhK6 Track 2: I Gave It All (feat. Harley Bird) - Cadmium & Rival X Rogers & Dean Link: https://soundcloud.com/cadmiumsound/rival-cadmium-x-rogers-dean-i-gave-it-all-ft-harley-bird-master-5 Cadmium: YouTube: www.youtube.com/c/Cadmiumsound Twitter: @cadmiumsound Facebook: www.facebook.com/cadmium.sound/ Instagram: www.instagram.com/Cadmium.sound/ Spotify: goo.gl/EhKdX5 Rival: @rival_official Facebook: www.facebook.com/sounds.rival YouTube: www.youtube.com/rivalofficial Twitter: twitter.com/rivaltweet Harley Bird Facebook: facebook.com/harleybirdmusic Twitter: @harleybird Rogers & Dean Twitter: @rogersanddean Facebook: facebook.com/rogersanddean
Views: 726 Forgotten Hwy
PL/SQL tutorial 12: PL/SQL WHILE Loop in Oracle Database
 
06:33
Iterative statements/loop series learn the concepts of While Loop in PL/SQL or In Oracle Database with Examples. also learn how to handle boolean expression in while loop ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/while-loop-in-pl-sql Previous Tutorial ► Simple Loop: https://youtu.be/AFx6QYcY1CU ------------------------------------------------------------------------- ►►►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
Views: 59702 Manish Sharma
Learn Oracle | PL SQL Loops
 
02:17
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: 167 Pebbles Tutorials
How to Fetch Data By Using Cursor for loop with where clause In Oracle Form
 
08:56
How to Fetch Data By Using Cursor for loop with where clause In Oracle Form
Views: 67 Young India
Nested Loop Join on SQL
 
05:03
Nested Loop Join on SQl
Views: 84 TUTOR SC
PL/SQL tutorial 16: Table Auditing using DML Triggers in Oracle PL/SQL
 
09:55
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
Views: 73855 Manish Sharma
6. ORACLE OTM 6.3.6-Set-up a new loop adapter and update the HOST file
 
01:44
Complete instructions and details at: https://transportationintelligence.wordpress.com Please share your thoughts or questions in the comment section, I would be glad to help.
Views: 262 Balea Bogdan
usos de for loop en oracle 10 g
 
05:41
sencillo
Views: 139 Mario Diaz
Oracle PL/SQL Tutorials | Oracle FOR LOOP REVERSE | Mr.Vaman Deshmukh
 
02:53
** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 ► Visit Our Website for Classroom Training: https://nareshit.in ► For Online Training: https://nareshit.com/ #OraclePLSQLTutorials #OracleFORLOOPREVERSE -------------------------- ► About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA ,Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA,Hyderabad, Chennai and Vijayawada,Bangalore India which provides online training across all the locations -------------------------- ► Our Online Training Features: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at USA: +1404-232-9879 or India: +918179191999 ** Check The Below Links** ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitech ► Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ► Follow us on Instagram: https://www.instagram.com/nareshitech/ ------------------------------------------------------------------------------------------------------ #sqltrainingvideos #oraclevideos #oracletraining #oracletutorials #trending #sqltutorials
PL/SQL tutorial 15: DML Trigger With Before Insert, Update and Delete DML Examples
 
09:17
PL/SQL Tutorial 15 explaining DML Trigger with examples such as Before Insert, Update and Delete in Detail. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/dml-triggers Previous Tutorial ► Trigger Intro : https://youtu.be/R3fvX_xf5P4 ► SELECT-INTO : https://youtu.be/F5eMJhwmCQs ►IF-THEN-ELSIF: https://youtu.be/aW9XgUHSr0I ------------------------------------------------------------------------- ►►►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
Views: 107785 Manish Sharma
IF,While Loop in SQL Server
 
57:10
Website:https://www.eclasess.com loops in sql server If loop While Loop
Performance Anti-Patterns: Non-query DML inside loops
 
14:03
Lots of code follows patterns. Some of the patterns are good ones, some them are bad - and these we call "anti-patterns." In this video, Steven identifies a common and, for many, surprising anti-pattern - and then shows how to turn it into a design pattern worthy of use. The anti-pattern is the execution on non-query DML (inserts, updates, deletes) inside a loop. The refactored positive design is based on bulk processing in PL/SQL. Along the way, Steven shows how this involves moving from row-by-row to phased processing. ================================================== 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.
Learn how to do Two-handed Loops
 
01:42
Two-Handed Loops yoyo trick https://YoYoTricks.com Get the Oracle yoyos we recommend for learning this trick: https://yoyotricks.com/shop/oracle-yoyo-two-handed-pack/ It is a fun kids toy that is good enough to do most professional yoyo tricks. Two-handed looping is the gateway into two-handed yoyo tricks.
Views: 51284 YoTricks
Beat Making Review - Vocal Stems and Sound Loops
 
15:41
http://maschinemasters.com/shop In this video demonstration/review Marv4MoBeats loads up Beat Maker 2 iPad app with the new ‘Voice Of Reason' by Kenny Buttons and 'Oracle Loops' by Timbaland chief sound designer Sound Oracle. He also breaks down how he was able to chop up the vocals and use some loops to make a dope trap beat. Both of these popular sound kits come in wav format and compatible with major daw's like (Maschine, MPC, Ableton, FL Studio, Reason, Logic, Protools, Cubase and more). Visit us at Maschinemasters.com to get your copy today! Follow Marv4MoBeats http://instagram.com/marv1977 http://twitter.com/marv4mobeats http://facebook.com/marv1977 Follow Us http://maschinemasters.com http://twitter.com/maschinemasters http://facebook.com/maschinemasters http://facebook.com/maschinemaster Maschine Masters is an online music production community focusing on sharing knowledge to up and coming producers using modern day software and hardware instruments. Our members can learn through detailed video tutorial courses on Maschine, MPC Touch, Ableton and FL Studio. We also provide high quality sound kits to help take your beats to the next level. Why hesitate? Become a Maschine Masters today!
Views: 3273 Maschine Masters
Tutorial 49 - For Loop in PostgreSQL
 
08:36
Learn about For Loops in PostgreSQL
Views: 7099 Programming Guru
PL/SQL tutorial 14 : Introduction of PL/SQL Triggers in Oracle Database By Manish sharma
 
05:55
PL/SQL Tutorial explaining what are triggers in Oracle PL/SQL, it's syntax, uses and types of triggers along with the Events in Triggers ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/introduction-of-triggers Previous Tutorial ► For Loop: https://youtu.be/DfAmnj2j7WI ------------------------------------------------------------------------- ►►►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
Views: 149457 Manish Sharma
T-SQL: JOIN OPERATORS - NESTED LOOP JOIN, MERGE JOIN AND HASH JOIN
 
07:04
In this video, I will describe the 3 Join Operators SQL Server uses and the reason why it comes to the individual selections by the Optimizer. Please check my blog azizsharif.blogspot.com for more videos!
Fire Princess + DDD Oracle King D'arc Combo - (Loop Combo until your opponent lose)
 
01:05
YGOPRO - Fire Princess + DDD Oracle King D'arc Combo - (Loop Combo until your opponent lose) Watch my other Ygopro Combo https://www.youtube.com/watch?v=O-zLxpdHyDg Like & Subscribe for support next video...
Views: 1098 YgoPro Combo
Stored Procedures: Looping with the While Parameter
 
02:54
Looping is incredibly important in Stored Procedures. Check out this simple Loop using the While Parameter! For more education opportunities, visit CoffingDW.com The Query Tool being used in this film is the Nexus Query Chameleon. Read more about it here: https://www.coffingdw.com/software/nexus
Oracle SQL: Understanding Multiple Table Joins
 
08:10
http://www.informit.com/store/oracle-sql-livelessons-video-training-downloadable-9780134275741?WT.mc_id=Social_YT Oracle SQL: Understanding Multiple Table Joins is an excerpt from Oracle SQL LiveLessons Video Training -- 6+ Hours of Video -- Oracle SQL LiveLessons Video Training covers the basics of the Oracle SQL programming language. This course covers both Oracle standard SQL and the ANSI approved SQL that Oracle supports. The focus of the course is to give students working knowledge of the Oracle SQL language and at the conclusion of this course, students should be able to query the Oracle database. Description In this LiveLessons video course, Oracle ACE Director Dan Hotka will teach you how to use the SQL query language, interpret business questions into SQL code, and how to use Where clauses sub-queries, complex table join conditions, and how to create table objects and populate tables with data. Students will also learn how to access Oracle from Microsoft products such as Excel. In addition, they will learn how analytical SQL can be used for business analysis. This course will use both Toad and SQL Developer for SQL examples. About the Instructor Dan Hotka is a training specialist and an Oracle ACE director who has more than 37 years in the computer industry and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and well over 200 published articles. He is also the video author for Oracle SQL Performance Tuning for Developers LiveLessons and Oracle PL/SQL Programming Fundamentals. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world. Visit his website at www.DanHotka.com. Skill Level Beginner Learn How To Use the SQL query language Interpret business questions into SQL code Understand Oracle standard SQL and ANSI SQL Work with Where clauses, sub-queries, and complex table join conditions Create table objects and populate these tables with data Access Oracle from Microsoft products such as Excel Use analytical SQL, useful for business analysts Who Should Take This Course Students who are new to SQL and want to learn Oracle SQL Course Requirements Basic knowledge of what is a database, especially RDBMS and what is a computer programming language http://www.informit.com/store/oracle-sql-livelessons-video-training-downloadable-9780134275741?WT.mc_id=Social_YT
Views: 14926 LiveLessons
Linux - Control shell loop
 
01:34
Linux - Control shell loop Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Ms. Mamta Tripathi, Tutorials Point India Private Limited.
Articu8 Vocal Loops - Beatmaking Demonstration
 
01:01
This is a demonstration of how the Articul8 vocal loop pack can be used in your production and song arrangement. This demonstration was done by producer Marv4MoBeats. To learn more visit SoundOracle.net. Introducing Sound Oracle's New Sound Library: VOCAL LOOPS ARTICUL8 Learn more: http://articul8kit.pagedemo.co/ Introducing Sound Oracle's New Sound Library: VOCAL LOOPS ARTICUL8 Learn more: http://articul8kit.pagedemo.co/ Introducing Articul8 Vocal Loops Available at Soundoracle.net I’d like to proudly present to you all, a new era in sound design here at SoundOracle.net with the release of my first ever Vocal Pack, Articul8. Using powerful tools like “Top Of The Line” Microphones, Preamps, Equalizers, and Compressors. Each loop was recorded at McNally Smith College of Music by students that major in production, vocal performance, and songwriting. I was able to capture harmonically rich and warm vocal takes from these world class, singers for you to use as you see fit in your musical creations. These harmonically rich and saturated vocals can serve as the perfect contrast to help give your beats more movement and melodic variation. More specifically, the Vocal Chain used in this process contained a Telefunken U-47 Tube Condenser Mic ran through Great River Mic Preamps, into an Empirical Labs Distressor into an API 550b EQ. To add even more contrast, I have also created two versions of each vocal loop. These include, one vocal loop that is ran through FXs and another that is just the original natural vocal untreated. COMPATIBLE WITH ALL DAWS Whatever your DAW of choice may be, feel free to chop, reverse, and rearrange these 21 loops available as 2 track stereo mixes or as stereo mix stems for added control. They are also available in WAV format, Royalty free, and BPM and Key Labeled. I bring to you…Articul8. Enjoy!! Articulat8 is a downloadable (WAV Format) kit containing 21 vocal loops available as 2 track stereo mixes or as stereo mixes with individual stems for added control that will incite sheer creativity for any Music Producer. Whether your genre is Trap, EDM, R&B, or Boom Bap Hip Hop, look no further to quench your musical ambitions. Each loop was recorded at McNally Smith College of Music by students that major in Production, Vocal Performance, and Songwriting. DETAILS ● Instant Download ● 21 vocal loops available as 2 track stereo mixes or as stereo mixes with individual stems for added control ● Each vocal loop comes in 2 different versions. You get the natural (Dry) version and a (Wet) version with FX. This gives you a total of 42 loops ● All vocals were recorded using vintage tube mics and classic analog gear such as the API 512c, 550b, GML EQ, & EL8 Distressors ● Compatible with all DAWs (Ableton, Fruity Loops, Protools, Reason, Logic, etc) ● All sounds are Royalty-Free REALISTIC PRODUCTION & VOCALISTS ERIC MICHAEL - REALISTIC PRODUCTIONS (Engineer) Realistic is a Music Producer and Engineer located in the Twin Cities. He started out playing guitar and piano in 2003 and has been producing and recording music since 2004. He produces Hip-Hop, R&B, Pop, & Dance music. CONNECT WITH ERIC ● Website - RealisticProductions.net ● Twitter - @Realistic_Pro ● IG - @RealisticProductions ● YouTube - @RealisticProductions ● SoundCloud - Realistic Productions HAILEY J. WARD – VOCALIST Hailey is a 20-year-old indie-folk singer-songwriter from Williston, Vermont. Her vocals are sweet and sassy, accompanied by her skills on piano, ukulele and guitar. CONNECT WITH HAILEY ● Twitter - @HaileyWardMusic ● FB - @HaileyWardMusic ● IG - @HaileyWardMusic ● YouTube - @HaileyWardMusic ● SoundCloud - Hailey-Ward ALEXIS KRYSTINE – VOCALIST Alexis is a full-time nanny, part-time Pop and Rock cover band Vocalist, and some-times a princess. Singing is her passion. Music is her life. She lives, breathes, and sleeps music. CONNECT WITH ALEXIS ● Twitter - @AlexisKrystine ● FB - @AlexisKrystineSinger ● IG - @alexis_krystine_ ● YouTube - Alexis Krystine JEFF SKIDMORE – VOCALIST Jeff or Jeffoncé...is a Pop Singer based in Minnesota. #BeyHive #BritneyArmy - Just about as crazy as a Scorpio can be #Berklee #McNallySmith as well. CONNECT WITH JEFF ● Twitter - @Jeffonce ● IG - @Jeffonce ● Soundcloud - @jeffskidmore ASIA DEVINE – VOCALIST Asia is a Minnesota base Artist, Songwriter, and Traveler. The soul is that of pure energy, the soul has no gender. Love who you love. CONNECT WITH ASIA ● Website: Asia Divine Music ● Twitter - @AsiaDevine_ ● FB - @divinethestorm ● IG - @eyesofasia_ ● SoundCloud - Asia DeVine This demonstration was performed by Producer Marv4MoBeats. ● Instagram: @marv1977 ● Twitter: @Marv4Mobeats ● Website: www.marv4mobeats.com ● YouTube: youtube.com/Marv4MoBeats
Views: 1704 SoundOracle
How to Iterate Over Each Rows in a DataFrame in Python (pandas)
 
03:23
Buy Me a Coffee? https://www.paypal.me/jiejenn/5 Your donation will help me to make more tutorial videos! How to use the pandas module to iterate each rows in Python. This is a common question I see on the forum and I thought I make a short video demonstrate how to do that.
Views: 11700 Jie Jenn
SQL Tutorial - 13: Inserting Data Into a Table From Another Table
 
07:00
In this tutorial we'll learn to use the INSERT Query to copy data from one table into another.
Views: 258159 The Bad Tutorials
All signs! THIRSTY THURSDAY 🤣🥂
 
59:31
I am still accepting tips and donations to the channel. They can be sent here    👇👇 https://paypal.me/RichmondL1111 (Please select goods and services) please like my Facebook page for extra content And live mini reads 👇👇👇 https://www.facebook.com/UniversalTarotZone/
Views: 20055 Rich Lopp
Tutorial 48 - While Loop in PostgreSQL
 
05:16
Learn about While Loop in PostgreSQL.
Views: 3536 Programming Guru
PL/SQL tutorial 40 : Introduction to PL/SQL Stored Procedure in Oracle Database By Manish Sharma
 
04:59
Learn what are "stored procedures" in Oracle Database By Manish Sharma from RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/stored-procedure Previous Tutorial ► How To Create PL/SQL function: https://youtu.be/93uqcFVtfWA ------------------------------------------------------------------------- ►►►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
Views: 56075 Manish Sharma
Dynamic sql table name variable
 
11:59
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable.html Slides http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable_20.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All SQL Server Tutorial Videos https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss how to pass table name dynamically for stored procedure in sql server. This is one of the sql questions that is very commonly asked. I have a web page with a textbox. When I enter a table name in the textbox and when I click "Load Data" button, we want to retrieve data from that respective table and display it on the page. Copy the SQL Script to create the tables from my blog using the link below http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable.html Create the following stored procedure. Notice we are passing table name as a parameter to the stored prcoedure. In the body of the stored procedure we are concatenating strings to build our dynamic sql statement. In our previous videos we discussed that this open doors for SQL injection. Create procedure spDynamicTableName @TableName nvarchar(100) As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from ' + @TableName Execute sp_executesql @sql End So the obvious question that comes to our mind is, why are we not creating parameterised sql statement instead. The answers is we can't. SQL Server does not allow table names and column names to be passed as parameters. Notice in the example below, we are creating a parameterised query with @TabName as a parameter. When we execute the following code, the procedure gets created successfully. Create procedure spDynamicTableName1 @TableName nvarchar(100) As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from @TabName' Execute sp_executesql @sql, N'@TabName nvarchar(100)', @TabName = @TableName End But when we try to execute it we get an error - Must declare the table variable "@TabName" Execute spDynamicTableName1 N'Countries' Add a Web Page to the project that we have been working with in our previous video. Name it "DynamicTableName.aspx". Copy and paste the HTML from my blog using the link below http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable.html Copy and paste the code from my blog in the code-behind page http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-table-name-variable.html At this point, run the application and type the following text in the "Table Name" textbox and click "Load Data" button. Notice "SalesDB" database is dropped. Our application is prone to SQL injection as we have implemented dynamic sql in our stored procedure by concatenating strings instead of using parameters. Employees; Drop database SalesDB One way to prevent SQL injection in this case is by using SQL Server built-in function - QUOTENAME(). We will discuss QUOTENAME() function in detail in our next video. For now understand that by default, this function wraps that string that is passed to it in a pair of brackets. SELECT QUOTENAME('Employees') returns [Employees] Modify the stored procedure to use QUOTENAME() function as shown below. Alter procedure spDynamicTableName @TableName nvarchar(100) As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from ' + QUOTENAME(@TableName) Execute sp_executesql @sql End At this point, type the following text in the "Table Name" textbox and click "Load Data" button. Notice you will see a message - Invalid object name 'Employees; Drop database SalesDB'. Also "SalesDB" database is not dropped. Employees; Drop database SalesDB The entire text in "Table Name" textbox is wrapped in a pair of brackets by the QUOTENAME function and is treated as table name. Since we do have a table with the specified name, we get the error - Invalid object name.
Views: 26812 kudvenkat