Home
Search results “Oracle get list of procedures”
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: 62480 Manish Sharma
Stored Procedure with Input and Output Parameters | Oracle DB
 
04:04
Java Source Code here: http://ramj2ee.blogspot.com/2015/07/oracle-stored-procedure-with-input-and.html Oracle : Stored Procedure with Input and Output Parameters JavaEE Tutorials and Sample code - Click here : http://ramj2ee.blogspot.in/
Views: 42019 Ram N
PL/SQL tutorial 41: How To Create PL/SQL Stored Procedure Without Parameters in Oracle Database
 
06:30
RebellionRider.com present you the PL/SQL Tutorial 41 on How To Create PL/SQL Stored Procedure Without Parameters in Oracle Database By Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/create-procedure-1 Previous Tutorial ► PL/SQL Blocks: https://youtu.be/rbarR4_gaH8 ► Introduction To Stored Procedures: https://youtu.be/buaSuEMi4lw ------------------------------------------------------------------------- ►►►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 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: 48323 Manish Sharma
PL/SQL tutorial 38: Introduction to PL/SQL functions in Oracle Database
 
05:10
PL/SQL tutorial for beginners Introduction to PL/SQL functions in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/introduction-to-plsql-function Previous Tutorial ► Blocks in Oracle Database https://youtu.be/rbarR4_gaH8 ► ------------------------------------------------------------------------- ►►►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: 56446 Manish Sharma
Stored procedures in sql server   Part 18
 
20:11
In this video we will learn 1. What is a stored procedure 2. Stored Procedure example 3. Creating a stored procedure with parameters 4. Altering SP 5. Viewing the text of the SP 6. Dropping the SP 7. Encrypting stored procedure Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedures-part-18.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-18-stored-procedures.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 814063 kudvenkat
How to return multiple values from a function in oracle pl/sql ? (without using out parameter)
 
14:19
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.
Views: 24216 Kishan Mashru
Oracle Part 13 Foreign Key, Stored Procedures
 
25:31
Foreign Key, user_tables, Theory on Stored Procedures
Views: 1940 Free OpenMentor
Calling Stored Procedures From Spring Data JPA
 
17:07
In this video, I will demo how to Call Stored Procedures From Spring Data JPA To download all sources code for this demo. Please pay for me $5 to my PayPal Account: [email protected] ====================================================== You can see more detail and download source code demo from my apps at https://play.google.com/store/apps/developer?id=PMK+Lab ====================================================== You also can buy my apps in http://codecanyon.net/user/octopuscodes/portfolio ====================================================== You also can read my blog in http://learningprogramming.net/ ====================================================== You can use Free Online Tools For Developers at http://octopuscodes.com ====================================================== You also can learn Microsoft Office Programming in https://www.youtube.com/channel/UCFrMOR6KF4cpa92OOPRyOng ====================================================== Please visit my store at http://shoesreviews.net ====================================================== TODAY IS A GREAT DAY TO LEARN SOMETHING NEW! ====================================================== Learning Programming videos help teach you about programming languages:Joomla, wordpress, drupal, magento, html template, free admin template, free bootstrap admin templates, SilverStripe, Cake PHP, CodeIgniter, Concrete5, Modx, ExpressionEngine, Alfresco,TYPOlight, laravel, magento, angularjs, node.js, html, css, javascript, jquery, java, .net, wamp server, xampp, php, mysql, sql server, oracle, open sources, android, hibernate, jpa, html5, jquery
Views: 7607 Learning Programming
Learning PL/SQL programming
 
29:21
Download the session ppts @ https://drive.google.com/file/d/0B_2D199JLIIpLXp5cm9QMFpVS00/view?usp=sharing 3:05 - Procedures 6:48 - Cursors 15:13 - Functions 16:36 - Triggers 21:35 - Package 23:59 - Exceptions
Views: 185166 BBarters
List all tables in a sql server database using a query  Part 65
 
05:38
Text version of the video http://csharp-video-tutorials.blogspot.com/2013/06/part-65-list-all-tables-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-65-list-all-tables-in-sql-server.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video we will discuss, writing a transact sql query to list all the tables in a sql server database. This is a very common sql server interview question. Object explorer with in sql server management studio can be used to get the list of tables in a specific database. However, if we have to write a query to achieve the same, there are 3 system views that we can use. 1. SYSOBJECTS - Supported in SQL Server version 2000, 2005 & 2008 2. SYS.TABLES - Supported in SQL Server version 2005 & 2008 3. INFORMATION_SCHEMA.TABLES - Supported in SQL Server version 2005 & 2008 -- Gets the list of tables only Select * from SYSOBJECTS where XTYPE='U' -- Gets the list of tables only Select * from SYS.TABLES -- Gets the list of tables and views select * from INFORMATION_SCHEMA.TABLES To get the list of different object types (XTYPE) in a database Select Distinct XTYPE from SYSOBJECTS Executing the above query on my SAMPLE database returned the following values for XTYPE column from SYSOBJECTS IT - Internal table P - Stored procedure PK - PRIMARY KEY constraint S - System table SQ - Service queue U - User table V - View Please check the following MSDN link for all possible XTYPE column values and what they represent. http://msdn.microsoft.com/en-us/library/ms177596.aspx
Views: 98044 kudvenkat
دورة Oracle Developer - الدرس الحادي و العشرين - Procedures
 
23:08
في هذا الدرس سنتعرف على الأمور التالي حول ال procedures في ال PL/SQL : define procedure create procedure mode of parameters calling procedure show error
Difference between Procedure and Function
 
06:33
This Video is out of audio and video sync, please find the updated video on https://www.youtube.com/watch?v=pofSn7lzqxA This video is a free tutorial on difference between procedure and a function. The tutorial demonstrates the difference between oracle pl/sql stored procedure and a function, also it shows the different type of return statement in both of the database objects, and various ways to execute a procedure and a function. By learning the difference the users can make an effective judgement on when to use procedure and when to use function. If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below : union and union all : https://youtu.be/n9FqQOd8liY char and varchar2 : https://youtu.be/039qzwjWf4k replace and translate : https://youtu.be/HKYF77BGzOE in and exists : https://youtu.be/REX4IjRYlFw rank and dense_rank : https://youtu.be/WGSX998hZ9M delete and truncate : https://youtu.be/u76wMm2byXo %type and %rowtype : https://youtu.be/MlLUFeZ_3eM
Views: 14139 Kishan Mashru
SSRS - Multivalue Parameter Report
 
08:15
Multi - Value Parameter Report, ssrs multiple parameters ssrs multi value parameter join ssrs multi value parameter stored procedure ssrs multi value parameter expression ssrs parameter multiple values default select all ssrs multiple parameters not working how to pass multiple values in a single parameter sql ssrs display multi value parameter in textbox
Views: 5846 Mukesh Singh
Send datatable as parameter to stored procedure
 
09:27
how to pass datatable to stored procedure in c#.net pass datatable to stored procedure in sql server 2008 In this video we will discuss how to send datatable as parameter to stored procedure. This is continuation to Part 99. Please watch Part 99 from SQL Server tutorial before proceeding. In Part 99, we discussed creating a stored procedure that accepts a table as a parameter. In this video we will discuss how to pass a datatable from a web application to the SQL Server stored procedure. Here is what we want to do. 1. Design a webform to insert 5 employees at a time into the database table. 2. When "Insert Employees" button is clicked, retrieve the from data into a datatabe and then pass the datatable as a parameter to the stored procedure. 3. The stored procedure will then insert all the rows into the Employees table in the database. WebForm1.aspx.cs code using System; using System.Configuration; using System.Data; using System.Data.SqlClient; namespace Demo { public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) {} private DataTable GetEmployeeData() { DataTable dt = new DataTable(); dt.Columns.Add("Id"); dt.Columns.Add("Name"); dt.Columns.Add("Gender"); dt.Rows.Add(txtId1.Text, txtName1.Text, txtGender1.Text); dt.Rows.Add(txtId2.Text, txtName2.Text, txtGender2.Text); dt.Rows.Add(txtId3.Text, txtName3.Text, txtGender3.Text); dt.Rows.Add(txtId4.Text, txtName4.Text, txtGender4.Text); dt.Rows.Add(txtId5.Text, txtName5.Text, txtGender5.Text); return dt; } protected void btnInsert_Click(object sender, EventArgs e) { string cs = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spInsertEmployees", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter paramTVP = new SqlParameter() { ParameterName = "@EmpTableType", Value = GetEmployeeData() }; cmd.Parameters.Add(paramTVP); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } protected void btnFillDummyData_Click(object sender, EventArgs e) { txtId1.Text = "1"; txtId2.Text = "2"; txtId3.Text = "3"; txtId4.Text = "4"; txtId5.Text = "5"; txtName1.Text = "John"; txtName2.Text = "Mike"; txtName3.Text = "Sara"; txtName4.Text = "Pam"; txtName5.Text = "Todd"; txtGender1.Text = "Male"; txtGender2.Text = "Male"; txtGender3.Text = "Female"; txtGender4.Text = "Female"; txtGender5.Text = "Male"; } } Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/send-datatable-as-parameter-to-stored.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/send-datatable-as-parameter-to-stored_18.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 64674 kudvenkat
Calling a stored procedure with output parameters   Part 7
 
20:13
Text version of the video http://csharp-video-tutorials.blogspot.com/2012/10/calling-stored-procedure-with-output.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-7-calling-stored-procedure-with.html All ADO .NET Text Articles http://csharp-video-tutorials.blogspot.com/p/free-adonet-video-tutorial.html All ADO .NET Slides http://csharp-video-tutorials.blogspot.com/p/adonet-slides.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists In this video, we will learn about calling a stored procedure with output parameters from an asp.net web application.
Views: 203277 kudvenkat
Oracle LISTAGG Function
 
04:57
https://www.databasestar.com/oracle-listagg/ The Oracle LISTAGG function allows you to aggregate or combine string values from multiple rows into a single row. For example, it turns this data: FIRST_NAME Adam Brad Carrie Into this data: FIRST_NAME Adam, Brad, Carrie The same data is shown, but it’s in one row and not multiple. It’s a valuable string manipulation function, and once you know what it is and how it works, you’ll be able to use it in your queries as needed. So what does it look like? The function is: LISTAGG ( measure_expr [, delimiter]) WITHIN GROUP (order_by_clause) [OVER query_partition_clause] These parameters are: measure_expr: This is a column or expression that you want to concatenate the values of. In the example above, it was the first_name column. Mandatory. delimiter: This is the character between each of the measure_expr values. Optional, the default is a comma. order_by_clause: This is the order that the values from the measure_expr are listed. Mandatory. query_partition_clause: This allows you to use LISTAGG as an analytic function, allowing you to show LISTAGG in groups for different rows. One thing to be aware of is that the output of the Oracle LISTAGG function is limited to 4,000 bytes. If you get more than this, you’ll receive an error. The most common way around this that I’ve seen is to write a custom function and use a CLOB. Watch the video to find out more and see some examples. For more information about the Oracle LISTAGG function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-listagg/
Views: 3714 Database Star
PL SQL Procedure - Stored Procedures in PL/SQL - Stored Procedure in Oracle
 
26:04
PL SQL Procedure are stored procedures in Oracle database in PL/SQL code. They are written to perform some operations on the data fetched from the tables. #Crazy4DB #OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle Other PL/SQL videos : PL/SQL Functions : https://youtu.be/nKb-CFkIisA PL/SQL Weak Ref Cursor : https://youtu.be/cEqsglhsvfQ PL/SQL Strong Ref Cursor : https://youtu.be/fEkcMTPtvIs PL/SQL Ref cursor : https://youtu.be/23eDRcqKR0k PL/SQL Record %ROWTYPE : https://youtu.be/Ev7uriDI96A PL/SQL cursors : https://youtu.be/pZQMjWYpWSs PL/SQL implicit cursors : https://youtu.be/3PoXQOOH5Nc PL/SQL explicit cursors : https://youtu.be/uH2MQChSh7w PL/SQL conditional Statements : https://youtu.be/5e6eqYtgJAc PL/SQL Basic : https://youtu.be/5fXsfOTRSHc PL/SQL Exception : https://youtu.be/tahOBL8Ogss PL/SQL %TYPE Anchored type : https://youtu.be/tbKvzhdLmMU PL/SQL Record Data type : https://youtu.be/Ev7uriDI96A PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 SQL Transaction : https://youtu.be/ZjK31EuWFsY PL/SQL Loops : https://youtu.be/IVmbdR2Dbz4 complete SQL tutorial : https://www.youtube.com/playlist?list=PLdNnjIwbbBta7tveno_un-C7VVFY-F24Z My web site : http://www.oracletrainingnagpur.com My blog : https://crazy4db.blogspot.in My facebook page : https://www.facebook.com/crazy4db/
Views: 160 Crazy4 DB
Oracle Forms 11g - Creating a Block from a Stored Procedure
 
13:43
This video demonstrates the process of creating an Oracle Forms data block using a stored procedure as the data source. Includes the creation of the store procedures and linking the procedures to Oracle Forms.
Views: 24248 Edward Honour
Oracle Interview question How To Get unique records without using distinct in oracle
 
11:56
Oracle Interview question How To Get unique records without using distinct in oracle? http://easy-learning-tech.blogspot.com/2018/07/how-to-get-unique-records-without-using.html List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 3466 Siva Academy
Dynamic SQL in Stored Procedure
 
09:32
In this video we will discuss, using dynamic sql in a stored procedure and it's implications from sql injection perspective. We will discuss performance implications of using dynamic sql in a stored procedure in a later video. Text version of the video http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure.html Slides http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure_11.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 Consider the following stored procedure "spSearchEmployees". We implemented this procedure in Part 139 of SQL Server tutorial. This stored procedure does not have any dynamic sql in it. It is all static sql and is immune to sql injection. Create Procedure spSearchEmployees @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Select * from Employees where (FirstName = @FirstName OR @FirstName IS NULL) AND (LastName = @LastName OR @LastName IS NULL) AND (Gender = @Gender OR @Gender IS NULL) AND (Salary = @Salary OR @Salary IS NULL) End Go Whether you are creating your dynamic sql queries in a client application like ASP.NET web application or in a stored procedure, you should never ever concatenate user input values. Instead you should be using parameters. Notice in the following example, we are creating dynamic sql queries by concatenating parameter values, instead of using parameterized queries. This stored procedure is prone to SQL injection. Let's prove this by creating a "Search Page" that calls this procedure. Create Procedure spSearchEmployeesBadDynamicSQL @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from Employees where 1 = 1' if(@FirstName is not null) Set @sql = @sql + ' and FirstName=''' + @FirstName + '''' if(@LastName is not null) Set @sql = @sql + ' and LastName=''' + @LastName + '''' if(@Gender is not null) Set @sql = @sql + ' and Gender=''' + @Gender + '''' if(@Salary is not null) Set @sql = @sql + ' and Salary=''' + @Salary + '''' Execute sp_executesql @sql End Go Add a Web Page to the project that we have been working with in our previous video. Name it "DynamicSQLInStoredProcedure.aspx". Copy and paste the HTML and code available on my blog at the following link http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure.html At this point, run the application and type the following text in the "Firsname" text and click "Search" 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. ' Drop database SalesDB -- In the following stored procedure we have implemented dynamic sql by using parameters, so this is not prone to sql injecttion. This is an example for good dynamic sql implementation. Create Procedure spSearchEmployeesGoodDynamicSQL @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Declare @sql nvarchar(max) Declare @sqlParams nvarchar(max) Set @sql = 'Select * from Employees where 1 = 1' if(@FirstName is not null) Set @sql = @sql + ' and [email protected]' if(@LastName is not null) Set @sql = @sql + ' and [email protected]' if(@Gender is not null) Set @sql = @sql + ' and [email protected]' if(@Salary is not null) Set @sql = @sql + ' and [email protected]' Execute sp_executesql @sql, N'@FN nvarchar(50), @LN nvarchar(50), @Gen nvarchar(50), @sal int', @[email protected], @[email protected], @[email protected], @[email protected] End Go On the code-behind page, use stored procedure spSearchEmployeesGoodDynamicSQL instead of spSearchEmployeesBadDynamicSQL. We do not have to change any other code. At this point run the application one more time and type the following text in the "Firstname" textbox and click the "Search" button. ' Drop database SalesDB -- Notice "SalesDB" database is not dropped, So in this case our application is not succeptible to SQL injection attack. Summary : Whether you are creating dynamic sql in a client application (like a web application) or in a stored procedure always use parameters instead of concatnating strings. Using parameters to create dynamic sql statements prevents sql injection.
Views: 41370 kudvenkat
PL/SQL tutorial 26: Introduction to PL/SQL Cursor in Oracle Database By Manish Sharma
 
05:10
Learn What are cursors, what are types(Explicit and implicit), and steps of cursor's creation in oracle database by Manish Sharma From RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/introduction-to-database-cursors Previous Tutorial ► Pl/SQL 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/ ___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: 114674 Manish Sharma
TSQL: Get Information From Stored Procedures
 
07:15
Need to find tables or other objects in stored procedures; this is how.
Views: 99 SQLInSix Minutes
Call Stored Procedure with multiple parameters from Excel
 
05:16
Call Stored Procedure with multiple parameters or different parameter values from Excel SYNTAX: {CALL uspGetManagerEmployees (?)} My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 15038 SQL with Manoj
Java JDBC Tutorial - Part 6.1: Calling MySQL Stored Procedures with Java
 
06:18
NEED TO LEARN JAVA - 5 FREE JAVA VIDEO COURSES - CLICK HERE - https://goo.gl/7i95F8 --- View more videos on my "Java JDBC Tutorial" Playlist: http://goo.gl/crT4nS Download Java Source Code: http://www.luv2code.com/?p=1012 Closed-Captioning and English subtitles available. Please SUBSCRIBE to this channel: http://goo.gl/EV6Kwv --- In this video we will learn how to call MySQL Stored Procedures with Java. ---- Follow luv2code: Website: http://www.luv2code.com YouTube: http://goo.gl/EV6Kwv Twitter: http://goo.gl/ALMzLG Facebook: http://goo.gl/8pDRdA --- Join my mailing list: Get advance notice on new tutorials. Emails about 1 per week. - http://www.luv2code.com/joinlist --- Questions or problems? Post them in the comments section below. --- Want to suggest a video? Leave a comment below. I'm always looking for new video ideas. Let me know what video you'd like for me to create. --- Transcript Time - 00:00 Hi, this is Chad (Shod) with luv2code.com. Welcome back to another tutorial on Java JDBC. In this video, we’ll learn how to use stored procedures. We’ll first define what stored procedures are, next we’ll use callable statements. Then we’ll learn how to pass parameters to stored procedures. I’ll actually break this up over 4 different videos. I’ll show each parameter type in a separate video, so in this section we’ll cover IN parameters and then in the follow on sections, I’ll cover IN OUT, OUT and also result sets. Please stay tuned and check out the following videos for this. Time - 00:39 A stored procedure is a group of SQL statements that perform a particular task. They are normally created by a DBA. The stored procedures are created in a SQL language that supported by the native database. Each database has its own language. For example, MySQL has stored procedures language, Oracle uses PL/SQL and Microsoft SQL Server uses Transact SQL. Finally, the stored procedures can also have any combination of input and output parameters. For this tutorial, we’ll use the following table employees. The table has sample data for testing. I have a SQL zip file that’s you can download. It will create the table, add sample data and also set up the stored procedures. You can download it from the link below. Time - 01:22 All right, let’s go and switch over to the MySQL workbench and what I’m going to do is open up that SQL file and run it. This is our JDBC stored procedures directory. I have a subdirectory called SQL, and has this file, table set up that SQL. I’ll open this file, what this file does it basically creates a table as we see here and then it goes through and inserts a lot of sample data. Then, it also goes through and creates all of the stored procedures that we need for this tutorial, right. I’ll just go ahead and select execute and this will run and so now should I have a new table over here called employees and this table also has a collection or this database has a collection of stored procedures for this tutorial series, so get count employees, greet and increase salaries and we’ll go through all these stored procedures during the actual tutorial itself. Time - 02:24 In JDBC, you make use of callable statements to make a call to the stored procedures. There is a special syntax to call stored procedures. You make use of curly braces inside of the string. You also make use of the JDBC keyword call and that’s followed by the name of the stored procedure. In this example, we’re not passing any params, so we’ll just use the open and closed parentheses. Finally, we execute the stored procedure. Let’s talk about the parameters on the next slide. The JDBC API support different types of parameters. You can make use of the IN parameter, INOUT and also the OUT. The stored procedures can also return a result set, during the code examples in this video, I’ll show you how to register different parameters types and also values. Time - 03:09 Let’s start with IN parameters. For this parameter, we’re only passing an input parameter and the parameter is read-only. Our DBA has created a stored procedure on the database. This stored procedure will increase the salary for everyone in the department, which is kind of cool. The procedure takes two parameters. The first parameter is the department name. The second parameter is the increase amount. For example, we can call this stored procedure and increase the salaries of employees in the engineering department by $10,000. In terms of Java coding, we need to make a call to the stored procedure. First, we prepare a callable statement, since the stored procedure takes two parameters, we’ll make use of our question mark place orders for the parameters. [snip] ... See Transcripts tab
Views: 89899 luv2code
oracle plsql records and collections two dimentional array
 
08:48
https://easy-learning-tech.blogspot.com/2018/12/two-dimensional-array-in-plsql-using.html ------------------------------------------------------------------------------------------------------ Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 740 Siva Academy
Getting started With Toad for Oracle - in-depth tutorial
 
23:18
https://www.quest.com/toad-for-oracle/ See an in-depth tutorial on Toad for Oracle, the solution from Quest that helps you reduce the time and effort required to develop and manage Oracle databases. Logging into Oracle: 1:03 Key windows: 2:42 Options: 15:08 Customizing the UI: 17:38 Toad editions: 20:27 More information: 22:40
Views: 62205 Quest
IBM BPM How to connect Oracle Database and Use SQL Call Stored Procedure Service
 
19:38
IBM BPM How to connect Oracle Database and Use SQL Call Stored Procedure Service Insert into table and Get record in oracle DB by stored procedures
Views: 805 Hồng Duyên Đào
1 PLSQL Performance Tuning   Introduction to DBMS PROFILER
 
23:33
1 PLSQL Performance Tuning Introduction to DBMS PROFILER https://sivakacademy.blogspot.com/2019/06/profile-plsql-code-using-dbmsprofiler.html Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 1438 Siva Academy
MVC - Stored Procedure example - database first
 
07:36
Simple example that shows how to call stored procedure and display values on the page
Views: 40826 Vis Dotnet
List Oracle Database Schemas, Tables, Columns and table contents using Angularjs and JSP.
 
17:05
This is a basic dba tutorial about getting contents on Oracle database objects like procedures, functions, package spec, package bodies, triggers and many more. This application dynamically load schemas and load object type when schema selected and object name when object type selected and when object name is selected you get the content of the object. You can even compile the object with a little compile button below, although it might not work properly everytime. Link to source code : https://drive.google.com/open?id=0BznrW3lgX0ozcElkeTVzREdFeUU
Views: 459 Subhroneel Ganguly
Toad for Oracle Schema browser how you will get the detail of database object ,log on schema
 
06:35
Toad for Oracle Schema browser how you will get the detail of database object ,log on schema,others schema,user
Views: 9948 Abinash Sahoo
Call Stored Procedure from Excel and show results
 
03:22
Call Stored Procedure from Excel and show results My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 10157 SQL with Manoj
Node.js + MySQL CRUD - GET,POST,PUT and DELETE
 
28:25
MySQL CRUD Operations in Node.js application. In this tutorial, we'll discuss how to implement crud operation insert update delete and view all in node.js with mysql database. Content Discussed : - How to Connect MySQL DB from Node.js - Execute MySQL Query From Node.js - Use of MySQL Store Procedure in Node.js. Best Node.JS Book from Amazon (Affiliate) : ➤ http://geni.us/UvK8B Download Project From : ➤ https://goo.gl/3JKBNM Buy me a Coffee (Channel Support By Donation) ➤ https://goo.gl/bPcyXW Subscribe to this channel ➤ https://goo.gl/RFY5C2 Link to this video ➤ https://youtu.be/4fWWn2Pe2Mk Our Website ➤ http://www.codaffection.com __ $ Purchase for Programmers ➤ Laptop MacBook Air : https://geni.us/fHZzRiB Dell XPS 9570 : https://geni.us/rYB6 ASUS ZenBook 13 : https://geni.us/LDKE Lenovo Ideapad : https://geni.us/Mwvg2 ➤ Keyboard Das Keyboard 4 Professional : https://geni.us/hkAdzi ➤ Mouse VicTsing Mouse : https://geni.us/tjIM48M ➤ Headphones Mpow 059 Bluetooth Headphones: https://geni.us/wAPDmP ______________ ⌘ Social Media Links ________________ Blog : http://www.codaffection.com Facebook : https://www.facebook.com/codaffection Google plus : https://plus.google.com/+codaffection Twitter : https://twitter.com/codaffection Youtube : https://youtube.com/codaffection ______________ ↪ About this Channel ________________ CodAffection - for passionate programmers. This channel is all about teaching and inspiring developers to build applications/ websites in various technologies like Angular, NodeJS, Asp.Net MVC, JavaScript, SQL, React, Python etc. 2 Videos per Week - 12:30 PM UTC On MON and THU ______________ ₪ All Playlist ________________ https://goo.gl/gvjUJ7 : Asp.Net MVC https://goo.gl/ahk39S : Angular 5 https://goo.gl/viJcFs : Node JS https://goo.gl/itVayJ : Web API https://goo.gl/YJPPAH : MEAN Stack https://goo.gl/s1zJxo : C# Tutorial https://goo.gl/GXC2aJ : Asp.Net WebForm https://goo.gl/vHS9Hd : C# WinForm https://goo.gl/MLYS9e : MS SQL https://goo.gl/Ha71kq : Angular 4 https://goo.gl/5Vou7t : Crystal Report https://goo.gl/EPZ69B : Common C# Excercises https://goo.gl/qEWJCs : CG Exercises in C Program
Views: 95340 CodAffection
Search for an Object (Table,View,Stored Procedure etc.)  in SQL Server Instance - TSQL Tutorial
 
15:35
How to Find Object ( Table.View,Stored Procedure,Function etc.) in All the Database in SQL Server - TSQL Tutorial / SQL Server Tutorial On daily basis we come across different questions and scenarios as Database developers and DBAs. Sometime users just stop by and they ask us questions and tell us that they have a table in one of the database and if we can take a look for them. When we try to find out the table, we don't see the table.The table might be in different Database and user is not providing correct information. The below script can be used to find out any object on Entire SQL Server Instance. you can use this script To find a Table in all the Databases on SQL Server Instance To find a Stored Procedure in All the Databases on SQL Server Instance To find a view on entire SQL Server Instance To find a function in any database on SQL Server Instance. In short any object can be found by using below script. You only have to provide the name of object and it will return you information with Database Name, Schema Name, Object Name, Type and Type Description. The below code is also one of the example where we need to change the database name in our query and we can use Dynamic SQL to perform that. Blog post link the video with scripts http://sqlage.blogspot.com/2015/03/how-to-find-object-tableviewstored.html
Views: 7422 TechBrothersIT
Tune Your Proc! - SQL Stored Procedure Performance Optimization  - SQL 2008 Tutorial
 
02:35
Tune a stored procedure by viewing the execution plan. Based on that information, make corrections to the code. Improve performance and optimize the core of your applications. Tuning, troubleshooting, optimizing, and improving your software. Try our free sales and customer reporting web service at http://www.reportingsales.com
Views: 23574 Edward Kench
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: 280869 The Bad Tutorials
Call Stored Procedure in ASP.NET MVC Controller
 
17:41
7 Steps Easy video Tutorial for call Stored Procedure in MVC Step: 1 Configure Application like Create Model & add Controller etc... Step: 2 Create Stored Procedure Step: 3 Syntax to call SQL Statement Step: 4 Loading data From Simple SQL Statement Step: 5 Loading data From Stored Procedure Step: 6 Pass Parameters to Stored Procedure Step: 7 Select Particular Field data For more details watch this tutorial Hope this video tutorial make sense regarding call Stored Procedure in ASP.NET MVC Controller. Thanks! Learn Everyday!! DIPAK TALAVIYA
Views: 12646 Dipak Talaviya
PL/SQL tutorial 35: Cursor Based Record Datatype Variable in Oracle Database By Manish Sharma
 
06:28
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
Views: 27350 Manish Sharma
63. Getting started with SQL Plus Reports in PL/SQL Oracle - Part 2
 
10:17
In this video you will learn about Getting started with SQL Plus Reports. 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: 3694 ITORIAN
SQL Server tutorial: Comparing triggers, functions, and procedures | lynda.com
 
03:59
This SQL Server tutorial discusses the similarities and differences between triggers, functions, and procedures. Watch more at http://www.lynda.com/SQL-Server-tutorials/SQL-Server-Triggers-Stored-Procedures-Functions/104964-2.html?utm_medium=viral&utm_source=youtube&utm_campaign=videoupload-dev-bus-VpJyzd5BY3Y. This tutorial is a single movie from the first chapter of the SQL Server: Triggers, Stored Procedures, and Functions course presented by lynda.com author Martin Guidry. The complete course is 2 hours long and investigates several key database-programming concepts: triggers, stored procedures, functions, and .NET CLR (Common Language Runtime) assemblies Introduction 1. Getting Started 2. Installing SQL Server 3. Stored procedures 4. User-defined functions 5. Triggers 6. Putting it all together 7. Using CLR assemblies 8. Exploring an ASP.NET web application Conclusion
Views: 30662 LinkedIn Learning
Debugging sql server stored procedures
 
15:11
debugging in ssms debugging t-sql code t sql debug stored procedure sql server management studio debug stored procedure how to debug t sql debug in sql server management studio In this video we will discuss how to debug stored procedures in SQL Server. Setting up the Debugger in SSMS : If you have connected to SQL Server using (local) or . (period), and when you start the debugger you will get the following error Unable to start T-SQL Debugging. Could not connect to computer. To fix this error, use the computer name to connect to the SQL Server instead of using (local) or . For the examples in this video we will be using the following stored procedure. Create procedure spPrintEvenNumbers @Target int as Begin Declare @StartNumber int Set @StartNumber = 1 while(@StartNumber [ @Target) Begin If(@StartNumber%2 = 0) Begin Print @StartNumber End Set @StartNumber = @StartNumber + 1 End Print 'Finished printing even numbers till ' + RTRIM(@Target) End Connect to SQL Server using your computer name, and then execute the above code to create the stored procedure. At this point, open a New Query window. Copy and paste the following T-SQL code to execute the stored procedure. DECLARE @TargetNumber INT SET @TargetNumber = 10 EXECUTE spPrintEvenNumbers @TargetNumber Print 'Done' Starting the Debugger in SSMS : There are 2 ways to start the debugger 1. In SSMS, click on the Debug Menu and select Start Debugging 2. Use the keyboard shortcut ALT + F5 At this point you should have the debugger running. The line that is about to be executed is marked with an yellow arrow Step Over, Step into and Step Out in SSMS : You can find the keyboard shortcuts in the Debug menu in SSMS. Let us understand what Step Over, Step into and Step Out does when debugging the following piece of code 1. There is no difference when you STEP INTO (F11) or STEP OVER (F10) the code on LINE 2 2. On LINE 3, we are calling a Stored Procedure. On this statement if we press F10 (STEP OVER), it won't give us the opportunity to debug the stored procedure code. To be able to debug the stored procedure code you will have to STEP INTO it by pressing F11. 3. If the debugger is in the stored procedure, and you don't want to debug line by line with in that stored procedure, you can STEP OUT of it by pressing SHIFT + F11. When you do this, the debugger completes the execution of the stored procedure and waits on the next line in the main query, i.e on LINE 4 in this example. To stop debugging : There are 2 ways to stop debugging 1. In SSMS, click on the Debug Menu and select Stop Debugging 2. Use the keyboard shortcut SHIFT + F5 Show Next Statement shows the next statement that the debugger is about to execute. Run to Cursor command executes all the statements in a batch up to the current cursor position Locals Window in SSMS : Displays the current values of variables and parameters If you cannot see the locals window or if you have closed it and if you want to open it, you can do so using the following menu option. Locals window is only available if you are in DEBUG mode. Watch Window in SSMS : Just like Locals window, Watch window is used to watch the values of variables. You can add and remove variables from the watch window. To add a variable to the Watch Window, right click on the variable and select "Add Watch" option from the context menu. Call Stack Window in SSMS : Allows you to navigate up and down the call stack to see what values your application is storing at different levels. It's an invaluable tool for determining why your code is doing what it's doing. Immediate Window in SSMS : Very helpful during debugging to evaluate expressions, and print variable values. To clear immediate window type ]cls and press enter. Breakpoints in SSMS : There are 2 ways to set a breakpoint in SSMS. 1. By clicking on the grey margin on the left hand side in SSMS (to remove click again) 2. By pressing F9 (to remove press F9 again) Enable, Disable or Delete all breakpoints : There are 2 ways to Enable, Disable or Delete all breakpoints 1. From the Debug menu 2. From the Breakpoints window. To view Breakpoints window select Debug =] Windows =] Breakpoints or use the keyboard shortcut ALT + CTRL + B Conditional Breakpoint : Conditional Breakpoints are hit only when the specified condition is met. These are extremely useful when you have some kind of a loop and you want to break, only when the loop variable has a specific value (For example loop varible = 100). How to set a conditional break point in SSMS : 1. Right click on the Breakpoint and select Condition from the context menu 2. In the Breakpoint window specify the condition Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/debugging-sql-server-stored-procedures.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/debugging-sql-server-stored-procedures_28.html
Views: 122855 kudvenkat
Database - Calling Stored Procedures from Visual Studio
 
07:54
How to call a SQL Server stored procedure from within Visual Studio 2010 This was created to support the Web Systems Programming courses at Daytona State College. http://www.daytonastate.edu/ More information including code is available at https://cop4834.pbworks.com/w/page/35926461/FrontPage
Dynamic Power BI reports using Parameters
 
12:21
In this video, Patrick shows you how you can use a parameter, within a Power BI report, to dynamically change the data in a report. This uses M Functions within Power Query and a second source that has the key values to pull. Then using a gateway to enable refresh. LET'S CONNECT! Guy in a Cube -- https://guyinacube.com -- http://twitter.com/guyinacube -- http://www.facebook.com/guyinacube -- Snapchat - guyinacube -- https://www.instagram.com/guyinacube/ ***Gear*** Check out my Tools page - https://guyinacube.com/tools/
Views: 117317 Guy in a Cube
Create Dynamic Query Parameters in Power BI Desktop  - Power BI Tips & Tricks #47
 
09:11
Create Dynamic Query Parameters, filter your reports with them and create a template using Power BI. Links mentioned in the video: Chris Webb blog: https://blog.crossjoin.co.uk/2016/08/30/data-driven-power-bi-desktop-parameters-using-list-queries/ Rio Summer Olympics Report: https://www.youtube.com/watch?v=tZXY9RZwd3U Download the sample report, #47 here: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1 Our PLAYLISTS: - Join our DAX Fridays! Series: https://goo.gl/FtUWUX - Power BI dashboards for beginners: https://goo.gl/9YzyDP - Power BI Tips & Tricks: https://goo.gl/H6kUbP - Power Bi and Google Analytics: https://goo.gl/ZNsY8l ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact ▼▼▼▼▼▼▼▼▼▼ If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running: https://curbal.com/product/sponsor-me Many thanks in advance! ▲▲▲▲▲▲▲▲▲▲ QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: ► Twitter: @curbalen, @ruthpozuelo ► Google +: https://goo.gl/rvIBDP ► Facebook: https://goo.gl/bME2sB #POWERBITIPS #CURBAL #POWERBI #MVP ► Linkedin: https://goo.gl/3VW6Ky
Views: 48585 Curbal
ASP NET Web API and SQL Server
 
11:17
In this video we will discuss creating ASP.NET Web API service that returns data from a SQL Server database. We will be using this service as the basis for understanding many of the Web API concepts in our upcoming videos. Text version of the video http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-and-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-and-sql-server_4.html Dot Net and SQL Server Tutorials https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All ASP.NET Web API Text Articles and Slides http://csharp-video-tutorials.blogspot.com/2016/09/aspnet-web-api-tutorial-for-beginners.html
Views: 373489 kudvenkat
SSRS Tutorial 37 - Use Stored Procedure with Multi value Parameter in SSRS Report
 
18:30
In this video of SSRS Tutorial, You will be learning How to create Stored Procedure with Multi value parameter How to configure Multi value parameter in SSRS Report How to provide values to Parameter by using Query link to the post for Stored Procedure used in the demo Use Stored Procedure with Multi value Parameter in SSRS Report Step by Step SSRS Tutorial by Tech Brothers http://www.techbrothersit.com/2015/07/ssrs-video-tutorial.html
Views: 28990 TechBrothersIT
Learn SQL in 1 Hour - SQL Basics for Beginners
 
01:02:23
A crash course in SQL. How to write SQL from scratch in 1 hour. In this video I show you how to write SQL using SQL Server and SQL Server Management Studio. We go through Creating a Database, Creating Tables, Inserting, Updating, Deleting, Selecting, Grouping, Summing, Indexing, Joining, and every basic you need to get starting writing SQL. TABLE OF CONTENTS Skip Intro/Discuss Management Studio 3:27 Create Database 5:10 Create Table 7:26 Insert Data 10:29 Select Statement 17:43 Where Clause 19:00 Update Statement 22:25 Delete Statement 24:33 Adding Comments 27:41 Adding Columns 29:33 Drop Table 32:38 Add Primary Key 33:17 Create Products Table 36:00 Create Orders Table 38:54 Foreign Keys 45:37 Joins 50:30 Functions/Group By 56:50 READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/learn-basic-sql-course/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Google+: http://gplus.to/SQLTrainingOnline Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 1306143 Joey Blue
PL/SQL tutorial 28: Cursor Parameter In Oracle Database By Manish Sharma
 
04:54
Learn How To Create Parameterized cursor in Oracle Database with easy to understand example by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/cursor-parameter Previous Tutorial ► Create Explicit Cursor: https://youtu.be/3q7dW_d2KVc ►Cursors : https://youtu.be/_snAMqCBitg ------------------------------------------------------------------------- ►►►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: 47590 Manish Sharma
SQLPLUS: LineSize & PageSize
 
03:49
In this tutorial, you'll learn how to set linesize and pagesize . 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: 21372 radhikaravikumar