Stored Procedures:- A Stored Procedure is also a Named PL/SQL block the accepts some input in the form of parameters and performs some task and many or many not returns a value Procedures are created to perform one or more dml operations over database.
Views: 51117 Naresh i Technologies
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: 34997 Ram N
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Views: 42615 Durga Software Solutions
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo.......
Views: 44242 Durga Software Solutions
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: 54642 Manish Sharma
Learn in depth about stored procedure in oracle,usage of SP in Database. Creating Stored Procedure using in, out ,in/out parameter and handling exception inside with example. Stored Procedure in Oracle, Stored Procedure in PL/SQL, Oracle Stored Procedure, PL/SQL Stored Procedure, What is Stored Procedure in pl/sql, How to use Stored Procedure in pl/sql, How to write a Stored Procedure in oracle, How to create Stored Procedure in pl/sql, Parameterized stored procedure in pl/sql, Benefit of using stored procedure in oracle, Advantages of Using Stored Procedures: Maintainability (because scripts are in one location, updates and tracking of dependencies based on schema changes becomes easier) Can be tested independent of the application Isolation of Business Rules,(Having Stored Procedures in one location means that there’s no confusion of having business rules spread over potentially disparate code files in the application) Speed / Optimization ( Stored procedures are cached on the server Execution plans for the process are easily reviewable without having to run the application) Utilization of Set-based Processing (The power of SQL is its ability to quickly and efficiently perform set-based processing on large amounts of data; the coding equivalent is usually iterative looping, which is generally much slower) Security ( Limit direct access to tables via defined roles in the database, provide an “interface” to the underlying data structure so that all implementation and even the data itself is shielded. Securing just the data and the code that accesses it is easier than applying that security within the application code itself ). Drawbacks to Using Stored Procedures: Limited Coding Functionality Stored procedure code is not as robust as app code, particularly in the area of looping (not to mention that iterative constructs, like cursors, are slow and processor intensive) Portability issue for complex and large Stored Procedure. Testing :Any data errors in handling Stored Procedures are not generated until runtime Cost :Stored Procedure development could potentially require a dedicated database developer. Some businesses will not allow developers access to the database at all, requiring instead a separate DBA. Alternatives to Stored Procedures: In-line or Parameterized Queries (These are written within the application code itself) Object Relational Mapping (ORM) (Provides an abstraction to the database without having to manually write data ) Linkedin: https://www.linkedin.com/in/aditya-kumar-roy-b3673368/ Facebook: https://www.facebook.com/SpecializeAutomation/
Views: 4463 Specialize Automation
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: 41565 Manish Sharma
This is a video tutorial on creating procedures, with input parameters types such as IN , OUT and IN OUT . Also the video demonstrates the way we can use default value with any parameter, and at the end the video demonstrates exception handling in PL/SQL procedures
Views: 7888 Kishan Mashru
In this video you will learn in a simple way how to Call PLSQL Procedure using CallableStatement in java
Views: 9236 Programming Lifestyle
Calling a Stored Procedure from another Stored Procedure - DB2 UDB, Oracle, SQL Server, MySQL
Views: 6187 Professor Saad
This video tutorial is a demonstration on different ways that a subroutine can be called / executed in Oracle PL/SQL. The video demonstrates the Position notation call, Named notation call and Mixed Notation call with proper examples.
Views: 3617 Kishan Mashru
Newsletter signup (with exclusive discounts): https://iamtimcorey.com/general-sign-up (your email will be kept safe and you will not be spammed). Facebook Page: https://www.facebook.com/IAmTimCorey/ Want to see a full C# application built from scratch? Check out this course: https://iamtimcorey.com/courses/csharp-from-start-to-finish/ Microsoft SQL can be confusing. There are a TON of features, options, and settings to consider when attempting to use it. One of my favorite features is stored procedures. These pre-compiled queries allow you to safely and securely access and modify data. In this video, you will learn the basics of how to build a stored procedure, as well as what the benefits and drawbacks of stored procedures are. You will also learn some best practices, including how to secure your entire database in just a few simple commands.
Views: 45195 IAmTimCorey
PL-SQL Procedure, How to Create Procedure, Calling Procedure in Oracle 11g Database PL-SQL tutorial for Beginners in Hindi and English
Views: 30489 Easy Engineering Classes
Learn about PL/SQL Blocks by watching videos What is Stored Procedure in PL/SQL: A procedure is a group of PL/SQL statements that you can call by name. In my next video i will be explaining further concepts of PL/SQL. Make sure you SUBSCRIBE and be the 1st one to see my videos! For HCL interview question : https://youtu.be/Pf0lRerwF5U For Global Analytics interview questions : https://youtu.be/joRTF8ZhVwg For CTS interview questions: https://www.youtube.com/watch?v=ISpHa... For accenture interview questions: https://www.youtube.com/watch?v=lojdZA7pT4o For 3i infotech interview questions: https://www.youtube.com/watch?v=aI7_45hSb5o For Infosys interview questions: https://www.youtube.com/watch?v=l4hfRvcnyxk For top 30 PLSQL interview questions: https://www.youtube.com/watch?v=pNiVsMHTk68 Please subscribe to my channel here for more videos on recent interview questions of MNC companies. https://www.youtube.com/channel/UCofh... Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Oracle PLSQL group from http://techroundinterviewque.blogspot.in/ ------------------------------------------------------------------------ Blog : http://techroundinterviewque.blogspot.in/ FB: https://www.facebook.com/jobupdates.necg/ Google+: https://plus.google.com/u/0/105097188725173992509 twitter: https://twitter.com/Oracle_pl_sql -------------------------------------------------------------------------- Thanks to my subscribers !!
Views: 1730 Oracle PL/SQL
In this tutorial, you'll learn what are stored procedures 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). 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, 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. 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, 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, CEITON MSSQL/Oracle Compiler  and SwisSQL. 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: 16282 radhikaravikumar
Manish from RebellionRider.com presents PL/SQL Tutorial 42 on How To Create PL/SQL Stored Procedure With Parameters In Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/create-procedure-2 Previous Tutorial ► PL/SQL Tutorial 40: https://youtu.be/buaSuEMi4lw ► PL/SQL Tutorial 41: https://youtu.be/Uld8eE016Kg ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 30523 Manish Sharma
This video will teach you the simple way to debug your Oracle Procedure | Package with Oracle SQL Developer..
Views: 12084 Oracle PL/SQL World
The audio and video now synced. This video is a free tutorial on the 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 judgment on when to use procedure and when to use a 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: 4606 Kishan Mashru
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Views: 13966 Durga Software Solutions
Views: 5193 Learning Programming
PLSQL Tutorials for Beginners : PLSQL Procedure with example SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 333 TechLake
Parameters in PL/SQL Procedure For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=5 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 38113 Oresoft LWC
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: 386 Hồng Duyên Đào
This video tutorial explains how an oracle procedure can return multiple values with a proper example. The video tutorial shows how this problem can be tacked using simple and easy to understand out parameters!!!
Views: 13347 Kishan Mashru
In this Video I show you the simple and efficient way to Debugging your PL/SQL Procedure | Package with Toad For Oracle.
Views: 9840 Oracle PL/SQL World
Get more recipes like this one in my new book Hibernate Tips: More than 70 solutions to common Hibernate problems: https://goo.gl/XfywNk The Hibernate Tips series provides quick answers to common questions. This time, I will show you how to use a @NamedStoredProcedureQuery to call a stored procedure with Hibernate. 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: http://www.thoughts-on-java.org/hibernate-tips-call-stored-procedure/ Want to connect with me? Blog: http://www.thoughts-on-java.org/ Twitter: https://twitter.com/thjanssen123 Facebook: https://www.facebook.com/thoughtsonjava
Views: 4453 Thoughts On Java
In this Video, You will learn How to call Stored Procedure in Hibernate. Below is the GitHub link to download source: https://github.com/kishanjavatrainer/CallingStoredprocedureInHibernate.git
Views: 2685 KK JavaTutorials
This video explains about the Basic PL/SQL Programs used in ETL Projects.Also covers Stored Procedure transformation in informatica
Views: 59867 TEK CLASSES
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: 22914 Edward Honour
Views: 27486 Questpond
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: 744048 kudvenkat
Course Content ======================= 1) JDBC In Simple Way 2) Storage Areas 3) JDBC 4) JDBC Architecture 5) JDBC API 6) Types of Drivers 7) Standard Steps For Developing JDBC Application 8) Select Operations And Non-Select Operations 9) Programs On Database Operations 10) Aggregate Functions 11) Real Time Coding Standards For JDBC Application 12) Working With MySQL Database 13) Life Cycle of SQL Query Execution 14) PreparedStatement (I) 15) SQL Injection Attack 16) Stored Procedures and CallableStatement 17) Cursors 18) Functions 19) Batch Updates 20) Handling Date Values For Database Operations 21) Working with Large Objects (BLOB and CLOB) 22) Connection Pooling 23) Properties 24) Transaction Management in JDBC ============================================= jdbc jdbc java tutorila jdbc java examples jdbc mysql examples Java Database Connectivity (JDBC) Adv Java JDBC Tutorial Java JDBC Tutorial jdbc tutorial for beginners JDBC Tutorial Introduction to JDBC Advanced Java Tutorial JDBC Tutorial in depth JAVA Database Tutorial JDBC with MySql Complete Course JDBC in Simple Way ============================== You an see more Java videos following link: Java tutorial by durga sir https://goo.gl/XWb4RL Java 9 by durga sir https://goo.gl/hXGyBW Java 1.8 Version New Features by Durga sir https://goo.gl/iHXXYU Adv Java JDBC Tutorial by Durga sir https://goo.gl/8q16Eo OCJA 1.8 Java SE 8 Programmer - I (1Z0 - 808 ) By Durga sir https://goo.gl/gC6R7f Core Java by NagoorBabu sir https://goo.gl/s6Nvj1 Advenced Java by Nagoorbabu sir https://goo.gl/ZZonzJ CoreJava by Ratan https://goo.gl/3VM19v Advanced Java jdbc by Ratan https://goo.gl/Rn2UXr Advjava tutorials - JSP by Ratan https://goo.gl/Z6ytxm Adv java servlets tutorial by ratan https://goo.gl/zTwi9y Servlet and JSP Tutorial by anji reddy https://goo.gl/jZMRUv Advanced Java Jdbc by Anjireddy https://goo.gl/16CGzX Hibernate byAnjireddy https://goo.gl/qQojvZ Struts by Anjireddy https://goo.gl/nE1Eof Spring by Mr.AnjiReddy https://goo.gl/NfN14R ADV JAVA by Naveen https://goo.gl/bhSsXF Spring by Mr.Naveen https://goo.gl/huVwFN Hibernate by Mr. Naveen https://goo.gl/TY3Wpd Struts by Mr.Naveen https://goo.gl/Vkmiw7
Views: 4242 Durga Software Solutions
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: 84630 luv2code
Creating And Modifying Stored Procedure In Oracle PL/SQL. using SQL Plus.
Views: 4023 Subhroneel Ganguly