Home
Search results “Oracle bind param”
PL/SQL tutorial 6: Bind Variable in PL/SQL By Manish Sharma RebellionRider.com
 
07:56
Watch and learn what are bind variables in PL/SQL how to declare or create them using Variable command, Initialize them using Execute (exec)command and different ways of displaying current values of a bind variable for example using AutoPrint parameter. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/bind-variable Previous Tutorial ► Constants in PL/SQL https://youtu.be/r1ypg7WH4GY ►User Variables :https://youtu.be/2MNmodawvnE ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- ►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: 90695 Manish Sharma
ADF Query with Bind Parameter
 
02:52
Creating a search screen using Bind Parameters
Views: 22942 ShayJDev
017D ExecuteWithParams SearchForm  -View Criteria and Bind variables
 
09:24
In this video I show how to create a custom search screen based on specific fields you designate with the View Criteria.
Views: 2726 Stuart Fleming
Oracle Report  parameter
 
10:41
Creating Oracle Report Parameter, Oracle Training in Bangladesh Oracle Developer and Database Training in Bangladesh Oracle Training at Dev Net IT Oracle forms Training Oracle SQL Training Oracle PL SQL Training Oracle BI Training Oracle Web Logic Training Oracle Reports Training for details http://www.devnet-it.com
Views: 15027 devnetbd devnetit
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: 54339 kudvenkat
Oracle execute immediate dynamic sql procedure in and out parameters Part 7
 
07:45
Oracle SQL PLSQL and Unix Shell Scripting
Views: 857 Sridhar Raghavan
Adding an LOV to a query parameter (executeWithParams)
 
05:21
How to set a parameter field used in an executewithparams operation to use an LOV type of control
Views: 9201 ShayJDev
Oracle Jdeveloper12c ADF - 6) How to execute Vo with parameter
 
08:01
1) what is NVL() in Oracle? 2) How to make View Object 3) How to execute parameter through Programmatically. Visit my Blog for more information .. https://parasshahjdeveloper12c.blogspot.in/2016/06/8-how-to-make-vo-parameterise.html
Views: 825 Paras Shah
Lexical parameters in Report Builder | D2K Forms and Reports Tutorial | Mr. Vijay Kumar
 
05:58
Lexical parameters in Report Builder | D2K Tutorial | Mr. Vijay Kumar ►For Registration : https://goo.gl/r6kJbB ►Call: +91-8179191999 ► Visit Our Website: http://nareshit.in/ http://nareshit.com/ ► About NareshIT: "Naresh IT is the Best Software Training Institute for Hadoop, Salesforce, AWS, DevOps, Sprak, 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 Hyderabad, Chennai and Vijayawada, India which provides online and classroom training classes" ►For Registration : https://goo.gl/r6kJbB ►Call: India- 8179191999, USA- 404-232-9879 Email: [email protected] ►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 Video's of each and every session. 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 ► Visit Our Website: http://nareshit.in/ http://nareshit.com/
Views: 1256 Naresh i Technologies
PL/SQL Tutorial | Accepting User input |Prompt input in Oracle Database
 
03:55
Learn how we can accept user input or prompt a popup box to accept input from user in oracle database using promot and accept syntax. How to accept user input in oracle, How to prompt for user input in oracle, Pop up box for user input in oracle, How to get popup box in oracle, What is accept and prompt syntax in oracle, Linkedin: https://www.linkedin.com/in/aditya-kumar-roy-b3673368/ Facebook: https://www.facebook.com/SpecializeAutomation/
Views: 3914 Specialize Automation
All About Passing Parameters SQL Task - SSIS
 
17:53
https://www.youtube.com/user/masterkeshav This explains SQL Task in SSIS and draws a comparison between how to pass parameter for an ADO.Net Vs OLEDB Connection.
Views: 34979 Keshav Singh
Two Queries with one parameter and one button using ADF
 
06:36
How to combine two queries that use the same parameter into a simple form with one parameter and one button when using Oracle ADF.
Views: 5961 ShayJDev
Passing Parameters to a TaskFlow on the URL
 
03:04
Shows how to create an ADF taskflow and pass a parameter to it from the URL
Views: 12408 ShayJDev
Stored Procedure with Output Parameter In ASP.Net C#
 
11:00
This video demonstrates the stored procedure with Output Parameter being used in Asp.net C#.
Views: 5047 Gautam Mokal
ADF - Passing Parameter Value between Pages
 
07:15
ADF - Passing Parameter Value between Pages
Views: 33092 ShayJDev
Oracle Forms Lesson 9 (Working with Parameters)
 
03:56
how to add and work with parameter in Oracle Forms
Views: 35199 Shahid Patel
TaskFlow invoking and Parameter passing in Oracle ADF
 
15:12
This video explain how you can create task flow, invoke task flow ,pass parameter and return from taskflow,
Views: 8473 vinay kumar
Hibernate Tip: How to Call a Function that returns a SYS_REFCURSOR
 
04:42
Get more recipes like this one in my new book Hibernate Tips: More than 70 solutions to common Hibernate problems: https://goo.gl/XfywNk Today I will answer a question about calling a function on an Oracle database that returns a SYS_REFCURSOR. But before we start, please subscribe and hit the bell icon to get notified about new hibernate tip videos. I upload a new one every week. If you like this video, please give me your thumbs up and share it with your friends and co-workers. Like my channel? Subscribe! ➜ http://bit.ly/2cUsid8 Join the free Member Library: https://goo.gl/dtyIIC Read the accompanying post: https://www.thoughts-on-java.org/hibernate-tips-function-returns-sys_refcursor/ Want to connect with me? Blog: http://www.thoughts-on-java.org/ Twitter: https://twitter.com/thjanssen123 Facebook: https://www.facebook.com/thoughtsonjava
Views: 331 Thoughts On Java
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: 186595 kudvenkat
How to perform data-driven testing of PL/SQL code in Toad for Oracle
 
05:01
https://www.quest.com/products/toad-for-oracle/ Quest’s Code Tester for Oracle offers you a simple way of producing data-driven unit tests for your PL/SQL code.
Views: 468 Quest
Stored procedures with output parameters   Part 19
 
18:20
In this video we will learn 1. Creating and executing stored procedures with output parameters 2. Learn about some of the useful system stored procedures Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedures-with-output.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-19-stored-procedures-with-output.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: 398079 kudvenkat
How to pass parameters from one form to another in Oracle forms.
 
12:37
This tutorial is about oracle forms parameter passing while calling it from another form. How to pass parameters from one form to another form in Oracle forms, passing and manipulating parameters dynamically from one form to another.
Views: 10542 Subhroneel Ganguly
pl-sql tutorial in Hindi lec 7 (pl sql procedure param and non param)
 
15:10
http://www.bitsinfotec.in/ procedures in pl-sql, parameterized procedures in plsql,what is plsql procedures, why to use plsql procedures, where to use plsql procedures.
Views: 827 JavaTreePoint
Part 7   Using stored procedures with entity framework
 
12:09
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-7-using-stored-procedures-with.html In this video we will discuss using our own custom stored procedures to perform Insert, Update and Delete operations using entity framework. Step 1: Create and populate Employee table. Step 2: Create Insert, Update and Delete stored procedures Step 3: Create a new empty asp.net web application Step 4: Add a new ADO.NET Entity Data Model. a) On Choose Model Contents screen select "Generate from database" option and click Next b) On "Choose Your Data Connections" screen give a meaningful name for the connection string that will be stored in the web.config file. I have named it EmployeeDBContext. Click Next. c) On "Choose Your Database Objects" screen, select Employees Table and the 3 strored procedures (InsertEmployee, UpdateEmployee, DeleteEmployee). Provide a meaningful name for the Model namespace. I have named it EmployeeModel. CLick Finish. At this point on the ADO.NET Entity Model designer surface, we should be able to see the Employee entity but not the stored procedures. To view the stored procedures, 1. Right click on entity model designer surface and select "Model Broswer" from the context menu. 2. Expand Stored Procedures folder Step 5: Add a webform to the project. Drag and drop the following 3 controls and build the solution. 1. GridView 2. DetailsView 3. EntityDataSource Step 6: Configure EntityDataSource control a). Right click on EntityDataSource control and select "Show Smart Tag" option b) Click on Configure Data Source link c) Select EmployeeDBContext from the Named Connection dropdownlist and click Next d) Select the options on "Configure Data Selection" screen as shown in the video Step 7: Configure GridView control a). Right click on GridView control and select "Show Smart Tag" option b) Click on "Auto Format" link and select "Colourful" scheme c) Select "EntityDataSource1" from "Choose Data Source" dropdownlist d) Select Enable Editing and Enable Deleting checkboxes Step 8: Configure DetailsView control a) Right click on DetailsView control and select "Show Smart Tag" option b) Click on "Auto Format" link and select "Colourful" scheme c) Select "EntityDataSource1" from "Choose Data Source" dropdownlist d) Select Enable Inserting checkbox e) Set DeafultMode=Insert. Use properties window to set this. f) Set InsertVisible="false" for the ID BoundField. You can do this directly in the HTML Source. g) Generate ItemInserted event handler method for DetailsView control. Copy and paste the following code. protected void DetailsView1_ItemInserted(object sender, DetailsViewInsertedEventArgs e) { GridView1.DataBind(); } At this point if you run the application, and if you insert, update and delete employees, by default entity framework will use the sql it autogenerates and not our custom stored procedures. To tell the entity framework to use the stored procedures, we have to map them to the Employee entity. Here are the steps. 1. Right click on "Employee" entity on "EmployeeModel.edmx" and select "Stored Procedure Mapping" option from the context menu. 2. In the "Mapping Details" windows specify the Insert, Update and Delete stored procedures that you want to use with "Employee" entity At this point, 1. Run SQL Prrofiler 2. Run the application 3. Insert, Update and Delete Employee, and notice that the respective stored procedures are being called now.
Views: 133160 kudvenkat
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: 53037 Manish Sharma
Prevent sql injection with dynamic sql
 
10:28
Text version of the video http://csharp-video-tutorials.blogspot.com/2017/04/prevent-sql-injection-with-dynamic-sql.html Slides http://csharp-video-tutorials.blogspot.com/2017/04/prevent-sql-injection-with-dynamic-sql_5.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 prevent SQL injection when using dynamic SQL. In Part 140, we have implemented "Search Page" using dynamic SQL. Since we have used parameters to build our dynamic SQL statements, it is not prone to SQL Injection attack. This is an example of good dynamic SQL implementation. I have seen lot of software developers, not just the beginners but even experienced developers, buidling their dynamic sql queries by concatenating strings instead of using parameters without realizing that they are opening the doors for SQL Injection. Please check my blog at the following link for code used in the demo. http://csharp-video-tutorials.blogspot.com/2017/04/prevent-sql-injection-with-dynamic-sql.html Since we are concatenating the user input values to build the dynamic sql statement, the end user can very easily inject sql. Imagine, what happens for example, if the user enters the following in the "Firstname" textbox. ' Drop database SalesDB -- With the above SQL injected into the "Firstname" textbox, if you click the "Search" button, the following is the query which is sent to SQL server. This will drop the SalesDB. Select * from Employees where 1 = 1 AND FirstName = '' Drop database SalesDB --' On the other hand, if you use parameters to build your dynamic SQL statements, SQL Injection is not an issue. The following input in the "Firstname" textbox, would not drop the SalesDB database. ' Drop database SalesDB -- The text the user has provided in the "Firstname" textbox is treated as the value for @Firstname parameter. The following is the query that is generated and executed. exec sp_executesql N'Select * from Employees where 1 = 1 AND [email protected]',N'@FirstName nvarchar(26)',@FirstName=N''' Drop database SalesDB --' We don't have this problem of sql injection if we are using stored procedures. "SearchPageWithoutDynamicSQL.aspx" is using the stored procedure "spSearchEmployees" instead of dynamic SQL. The same input in the "Firstname" texbox on this page, would generate the following. Notice, whatever text we typed in the "Firstname" textbox is treated as the value for @FirstName parameter. exec spSearchEmployees @FirstName=N''' Drop database SalesDB --' An important point to keep in mind here is that if you have dynamic SQL in your stored procedure, and you are concatenating strings in that stored procedure to build your dynamic sql statements instead of using parameters, it is still prone to SQL injection. If this is not clear at the moment don't worry, we will discuss an example of this in out next video. So in summary, while dynamic sql provides great flexibility when implementing complicated logic with lot of permutations and combinations, if not properly implemented it may open doors for sql injection. Always use parameters to build dynamic sql statements, instead of concatenating user input values. Another benefit of using parameters to build dynamic sql statements is that it allows cached query plans to be reused, which greatly increases the performance. We will discuss an example of this in our upcoming videos.
Views: 19271 kudvenkat
Using Time in Parameters to Filter Data
 
04:01
How to work with parameters that filter date fields by time in Oracle ADF Business Components.
Views: 1774 ShayJDev
Query Parameter Example in Power BI - Query Editor Tutorial
 
06:07
Learn how to use the query parameter feature inside of Power BI. By using this feature you can bring significant scale to your reporting. No need for duplicated reporting. Build a model once and then use this to add additional filters to your reports. ***** Learning Power BI? ***** All Enterprise DNA TV Resources - http://portal.enterprisedna.co/p/enterprise-dna-tv-resources FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE - Power BI Resources - http://enterprisedna.co/power-bi-resources Learn more about Enterprise DNA - http://www.enterprisedna.co/
Views: 16734 Enterprise DNA
Beyond Excel: Parameterized Query
 
03:27
Create a Parameterized Query in Excel without Add-ins, Macros, or Formulas
Views: 68047 Craig Hatmaker
ADF- Use ADF Variables to Transfer Data between Pges
 
09:14
----------------------------------------------------------------- Best regard Apps-Stuff Muhammad Yassein - Cairo - Egypt http://www.apps-stuff.com follow us on Facebook - Twitter with Appsstuff
Views: 3840 Appsstuff Middleware
Passing Parameters between Bounded Task Flow in Oracle ADF
 
03:06
This video will demonstrate how to pass parameters between bounded task flows in Oracle ADF using JDeveloper 11g Hope you like it.
Views: 17268 DataNext Solutions
Passing parameter to Bounded Task Flow Oracle ADF JDeveloper 11g 11.1.1.6
 
09:09
This video is a short (~9 min) video on how to pass values from a JSFF (page fragment) page to a bounded task flow using "input parameter" bound to the Task Flow - In the process, it also shows how to create an Application and setup a basic task flow and calling another task flow and then running as JSPX page. it uses Oracle ADF JDeveloper 11g v11.1.1.6
Views: 12161 Joel Thompson
Calling Webservice in Oracle ADF by Creating Webservice Data control
 
04:33
In this video we will call the webservice by creating webservice data control in Oracle fusion application Watch the last video How to create Webservice from java class: http://www.youtube.com/watch?v=QP20pmd9Hq8
Views: 19054 DataNext Solutions
Passing Parameters to ADF Application through the URL
 
06:29
How to pass a parameter to an ADF page using the page level parameters in the ADF controller. Also shows view object level service method. Blog here - https://blogs.oracle.com/shay/entry/passing_parameters_to_an_adf_p
Views: 13948 ShayJDev
Angular required route parameter vs optional route parameter
 
07:21
In this video we will discuss some of the common differences between required route parameters and optional route parameters in Angular. This is continuation to Part 43. Please watch Part 43 from Angular CURD tutorial. 1. Required route parameters are part of route configuration where as optional route parameters are not 2. Required route parameters are used in pattern matching i.e when mapping an incoming URL to a named route in our application. Optional route parameters are not used in pattern matching. 3. Optional route parameters must be passed after the required route parameters if any. 4. In general, prefer a required route parameter when the value is simple and mandatory. For example, to view a specific employee details, the ID parameter is mandatory and it is a simple integer. On the other hand, prefer an optional route parameter when the value is optional and complex. For example you want to send many search parameters like NAME, AGE, DEPARTMENT, DOB etc...from the SEARCH PAGE to LIST PAGE. Text version of the video http://csharp-video-tutorials.blogspot.com/2018/04/angular-required-route-parameter-vs.html Slides http://csharp-video-tutorials.blogspot.com/2018/04/angular-required-route-parameter-vs_23.html Angular CRUD Tutorial https://www.youtube.com/playlist?list=PL6n9fhu94yhXwcl3a6rIfAI7QmGYIkfK5 Angular CRUD Tutorial Text Articles & Slides http://csharp-video-tutorials.blogspot.com/2017/12/angular-crud-tutorial.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: 5992 kudvenkat
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: 82482 Guy in a Cube
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: 40310 Manish Sharma
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: https://gofile.me/2kEOD/PaRdrp3aG Looking for a download file? Go to our Download Center: 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: 39361 Curbal
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: 10826 SQL with Manoj
ADF Taskflow Call and Return Activity - Tutorial 1
 
11:27
ADF Taskflow Call and Return Activity
Views: 6988 Navaneetha Nataraj
GridView insert update delete in asp.net - Part 23
 
23:47
Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for text version of this video http://csharp-video-tutorials.blogspot.com/2013/03/gridview-insert-update-delete-in-aspnet.html In this video we will discuss about performing an insert, update and delete on asp.net gridview control using sqldatasource. We will be using tblEmployee table for this demo. SQL script to create and populate this table with sample data is available in Part 13 of asp.net gridview tutorial. Create an asp.net web application. Drag and drop a gridview and a sqldatasource control on WebForm1.aspx. Configure "SqlDataSource1" control 1. Right click on "SqlDataSource1" control and select "Show Smart Tag" 2. Now click on "Configure Data Source" link 3. Select connection string, from the dropdownlist on "Choose your data connection" screen. You need to have a connection string specified in web.config file. 4. Click Next 5. On "Configure the Select Statement" screen, select "tblEmployee" table from dropdownlist. 6. Click on "Advanced" button 7. Select "Generate INSERT, UPDATE and DELETE statements" checkbox and click OK 8. Click Next and Finish Drag and drop gridview control on WebForm1.aspx. Now let us associate "SqlDataSource1" control with "GridView1" control 1. Right click on "GridView1" control and select "Show Smart Tag" 2. Select "SqlDataSource1" from "Choose Data Source" dropdownlist 3. Select "Enable Deleting" and "Enable Editing" checkboxes. At this point "Delete" and "Edit" buttons should appear on the gridview control. We will be using gridview control's footer for inserting a new record. Set "ShowFooter" property of the GridView1 control to "true". This can be done from the properties window, or in the HTML. By default GridView control has generated bound fields to display EmployeeId, Name, Gender and City columns. We need to convert these bound fields into template fields. This can be done very easily using the designer. 1. On the "GridView Tasks" pane click on "Edit Columns" link button. 2. Select "EmployeeId" from "Selected Fields" section and click on "Convert this field into a template field" link 3. Do the same for Name, Gender and City Now modify the template fields in the HTML. Please note 1. In every TemplateField, along with EditItemTemplate and ItemTemplate, we also need FooterTemplate. 2. A dropdownlist is used in EditItemTemplate and FooterTemplate of "Gender" template field, instead of a textbox control. 3. To validate data during edit and insert operations, notice that, we are using validation controls, in EditItemTemplate and FooterTemplate. 4. A linkbutton is used in the footer template of "EmployeeId" template field, to enable the user to insert a new employee row 5. We have used ValidationGroup="Insert" for all the validation controls in FooterTemplates. LinkButton's ValidationGroup is aslo set to "Insert", so that all the validation controls in in FooterTemplates are fired only on Insert LinkButton click. 6. We have set LinkButton's OnClick="lbInsert_Click". 7. After the closing tag of GridView, notice that we are using 2 validationsummary controls, to display all the validation messages in one place. ValidationSummary1 control's ValidationGroup is set to "Insert". ValidationSummary1 control displays all insert related validation errors, and edit related validation errors are displayed using ValidationSummary2 control. Finally copy and paste the following event handler method in WebForm1.aspx.cs protected void lbInsert_Click(object sender, EventArgs e) { SqlDataSource1.InsertParameters["Name"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtName")).Text; SqlDataSource1.InsertParameters["Gender"].DefaultValue = ((DropDownList)GridView1.FooterRow.FindControl("ddlGender")).SelectedValue; SqlDataSource1.InsertParameters["City"].DefaultValue = ((TextBox)GridView1.FooterRow.FindControl("txtCity")).Text; SqlDataSource1.Insert(); }
Views: 392208 kudvenkat
018c Send Parameter to Dynamic Region Using Managed Bean: Jdeveloper ADF
 
08:04
In this video, we explore how to set a parameter for a dynamic region using a bean.
Views: 3505 Stuart Fleming
How to create and utilize parameters in queries in Toad Data Point
 
05:41
http://quest.com/products/toad-data-point/ This video shows how to create and utilize parameters in queries in Toad Data Point. Solicit inputs by utilizing these parameters when posting views to Toad Intelligence Central, and reduce the amount of data that needs to be shared.
Views: 670 Quest
PL/SQL tutorial 57: PL/SQL Collection Associative Array in Oracle Database
 
08:05
Manish Sharma from RebellionRider presents you the latest PL/SQL tutorial on Collection ASSOCIATIVE ARRAY. In this video, you will learn – - What are Associative Arrays? - How to create Associative Arrays? - How to Insert & Update the data of Associative Array and - How to retrieve the data from an Associative array using two different ways? So if you are wondering whether associative array is a persistent form of collection or not; Is it bounded or unbounded in nature; why should we use this specific collection over others such as VARRAY or Nested Table; What are the differences or similarities between associative array and other collections? Then go ahead and watch the video to find out the answers to all these questions. Hope you will enjoy watching. Do make sure to Like and Share this post/video because that will help others in learning as well as help me and my channel in reaching out. This way we can educate more and more people for FREE. Most importantly SUBSCRIBE to the channel as many such interesting tutorials are coming your way. Thanks. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/associative-array Previous Tutorial ►While Loop: https://youtu.be/IIlc4Sr7kFE ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 12419 Manish Sharma
pl-sql tutorial in hindi lec 2 (identifiers and variables in pl-sql)
 
10:25
http://www.bitsinfotec.in/ what is identifiers in plsql in hindi. types of identifiers in pl-sql in hindi, how to use it, identifiers in pl-sql, pl-sql tutorial in hindi, pl-sql lectures, pl-sql in oracle in hindi, what is pl-sql in oracle in hindi.
Views: 2256 JavaTreePoint
004k Set the Where Clause of a View Object
 
10:10
In this video I show how to programmatically set the view object where clause using setWhereClause. This shows how to set the where clause in the view object java class, the application module, and from a button on a jsf page.
Views: 2761 Stuart Fleming
018b Send Parameter to Region on form: Jdeveloper ADF
 
06:56
In this video we use the completed version of 018a ( http://youtu.be/SfICieH4eU4 ) and transform it so instead of going to a form sitting in another taskflow, we put the taskflow on the main form as a region. We then pass the parameter to it.
Views: 1394 Stuart Fleming
Passing Parameters from ADF Task Flow with Fragments into ADF Bounded Task Flow
 
12:11
real post be on http://andrejusb.blogspot.com/2010/03/passing-parameters-from-adf-task-flow.html and http://juddi-oracle.blogspot.com/
Views: 10236 juddioracle

Zoloft weight gain 2012 movie
Claritin 10 mg dawkowanie antybiotykow
Erythromycin 250 mg syrup recipes
Tueurs a gages celebrex generic release
Voltaren emulgel 60 gr prezzo petrolio