Home
Search results “Oracle cursor in out”
REF CURSOR AND SYS_REFCURSOR IN ORACLE PL/SQL WITH EXAMPLE
 
25:07
This video explains about ref cursor in oracle pl/sql, what are ref cursors, how are ref cursor different from simple cursors, what are the advantages of using a ref cursor etc. The video demonstrates proper and easy to understand examples on ref cursor.
Views: 9549 Kishan Mashru
PL/SQL tutorial 67: PL/SQL Ref Cursors In Oracle Database by Manish Sharma
 
04:33
RebellionRider.com presents introduction to PL/SQL Ref Cursors / Cursor Variable in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/ref-cursor-1 Previous Tutorial ►Database Cursor (Playlist): http://bit.ly/2x0JGXz ► Record Datatype (Playlist): http://bit.ly/2xkcHOr ------------------------------------------------------------------------- ►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: 12765 Manish Sharma
JDBC - CallableStatement Cursor and multiple out param(Oracle)
 
05:18
Java Source Code here: http://ramj2ee.blogspot.com/2015/07/jdbc-callablestatement-cursor-and.html To Download JDBCCallableStatementDemoOracleCursorMultiOutApp Project Click the below link: https://sites.google.com/site/javaee4321/jdbc/JDBCCallableStatementDemoOracleCursorMultiOutApp.zip?attredirects=0&d=1 Github link: https://github.com/ramram43210/Java/tree/master/JDBC/JDBCCallableStatementDemoOracleCursorMultiOutApp Bitbucket Link: https://bitbucket.org/ramram43210/java/src/92fc9016492af9d79a3335e7089fafc0c9b8cdcc/JDBC/JDBCCallableStatementDemoOracleCursorMultiOutApp/?at=master JDBC - CallableStatement Cursor and multiple out param(Oracle). JavaEE Tutorials and Sample code - Click here : http://ramj2ee.blogspot.in/
Views: 1623 Ram N
PL/SQL Oracle REF CURSOR and SYS_REFCURSOR tutorial
 
08:54
REF CURSOR declaration is not associated with any SQL query - different queries can be associated with the cursor programatically. More video tutorials http://www.learn-with-video-tutorials.com
PL/SQL: Ref cursor Types
 
07:57
In this tutorial, you'll learn the types of ref cursors.. 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: 12285 radhikaravikumar
Tutorial 33 : REF CURSOR Example || REF CURSOR in Procedure
 
09:26
Hi Friends, Here we learning about REF CURSOR in Procedure. How to OPEN CURSOR in one procedure and FETCH data in another procedure. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. Link (REF CURSOR Introduction, Strong Ref Cursor, Weak Ref Cursor, Sys_RefCursor) : https://youtu.be/myajCnmO1n4 Link (REF CURSOR Example || CURSOR with two different Select Statements) : https://youtu.be/5MwvkYtFbgQ Link (Cursor FOR LOOP with parameter) : https://youtu.be/AwrcCS0CmGU Link (Cursor FOR LOOP) : https://youtu.be/Y_W97kwSiJo Link (Cursor Parameter with default value) : https://youtu.be/YvLN8xum8TQ Link (How to pass parameter in CURSOR) : https://youtu.be/qYQr7oBHvxY Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks. Happy Coding :)
Views: 378 YourSmartCode
Oracle DBA Justin - PL/SQL # 1: How to display output in a PL/SQL program
 
07:04
How to display output in a PL/SQL program
Views: 5402 jbleistein11
PL/SQL tutorial 69: PL/SQL Strong Ref Cursor with User Defined Record Datatype in Oracle Database
 
06:52
RebellionRider.com presents PL/SQL Strong Ref Cursor in Oracle Database. In this tutorial, you will learn how to create a Strong Ref Cursor using User-Defined record datatype variable. Enjoy! ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/ref-cursor-3 Previous Tutorial ►Strong Ref Cursor with Table based Record https://youtu.be/6fTdB_cMS6o ► Anchored Datatype https://youtu.be/Zt0vlmTqhP4 ►User Defined Record https://youtu.be/sy6H2ZLoZwg ------------------------------------------------------------------------- ►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: 6108 Manish Sharma
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: 18428 Kishan Mashru
79. UPDATE and DELETE using Cursor in PL/SQL Oracle
 
08:18
In this video you will learn about UPDATE and DELETE using Cursor in PL/SQL Oracle. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 4094 ITORIAN
Oracle : Stored Procedure with Input and Output Parameters
 
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: 33274 Ram N
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: 40177 Manish Sharma
Create A Cursor In Oracle By HemaLata
 
01:35
Create A Cursor In Oracle By HemaLata
Views: 90 Hemalata Mendes
PL-SQL tutorial 31 - What is implicit cursor in PLSQL ?
 
08:12
Hi guys today i am going to explain about implicit cursor in PLSQL its occur automatically when run SQL statement UPDATE DELETE AND INSERT #implicitcursor Oracle database Unbeatable,Unbreakable Platform..
Views: 232 Oracle World
PLS-11: Oracle PL/SQL Reference Cursor
 
08:43
Oracle 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: 73594 Oresoft LWC
Cursors in Oracle PLSQL
 
09:30
This Video Explains. 1. What is CURSOR in Oracle PLSQL 2. How to use cursor in Oracle PLSQL 3. How to declare,open and fetch values in CURSOR 4. CURSOR Attributes 5. Implicit cursor and explicit cursor 6. CURSOR TYPES
Views: 2560 yrrhelp
Call stored procedure which returns ref cursor from C#
 
01:49
Bu dersimizde C# ile plsql terefde yazilmis procedur ve ya funkyalari nece cagirirq onu goreceyik ...
Views: 2436 Horumcek Toru
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: 22737 Manish Sharma
HOW TO RETURN MULTIPLE VALUES FROM A PROCEDURE IN ORACLE PL/SQL? (USING OUT PARAMETERS)
 
04:46
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: 12580 Kishan Mashru
PL/SQL tutorial 71: PL/SQL SYS_RefCursor in Oracle Database by Manish Sharma
 
05:31
RebellionRider.com presents PL/SQL Sys_RefCursor in Oracle Database. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog:http://bit.ly/ref-cursor-5 What are actual and formal parameters in programming http://bit.ly/actual-vs-formal Find the Script here https://github.com/RebellionRider/pl-sql-tut-71 Previous Tutorial ►Weak Ref Cursor https://youtu.be/_u7xkaRzai8 ►Strong Ref Cursor https://youtu.be/81uJi_x-3sQ ------------------------------------------------------------------------- ►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: 6147 Manish Sharma
PL/SQL: Ref Cursors
 
09:28
In this tutorial, you'll learn what is ref cursors. 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: 27024 radhikaravikumar
PL/SQL tutorial 27: How To Create An Explicit Cursor In Oracle Database By Manish Sharma
 
05:03
Learn How To Create An Explicit Database Cursor In Oracle with easy to understand example by Manish Sharma RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/create-explicit-cursor Previous Tutorial ► Introduction To Database Cursor - https://youtu.be/_snAMqCBitg ► Simple Loop - https://youtu.be/AFx6QYcY1CU ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ ___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: 53184 Manish Sharma
71/125 Oracle PLSQL: Dynamic SQL / REF Cursor
 
09:22
تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144
Views: 777 khaled alkhudari
What is Parameterized Cursor in Oracle
 
03:39
What is Parameterized Cursor in Oracle. In simple words a cursor with parameter is called parameterized cursor. PL/SQL allows developer to pass parameters into cursors. Same as like we can pass parameter into function and procedure. PL/SQL Parameterized cursor pass the parameters into a cursor and use them in to query. Cursor becomes more reusable using Cursor parameters. PL/SQL Parameterized cursor define only data type of parameter and not need to define it's length. In Parameterized cursor scope of the parameters are local within program only. Optionally, we can also give a default value for the parameter, which will take effect if no value is passed to the cursor. Key point 1. Scope of the parameters are locally 2. You can assign default value to a cursor parameter. 3. Cursor becomes more reusable with Cursor parameters. 4.PL/SQL Parameterized cursor define only data type of parameter and not need to define it's length. Please Leave your comments about this video and you can leave your question also for new videos. -------------------------------------------------------------------------------- Join our group on Facebook https://www.facebook.com/groups/146487615764170/ -------------------------------------------------------------------------------- Visit our blog http://oracletemple.blogspot.in/ -------------------------------------------------------------------------------- Useful plsql books link. http://goo.gl/XMy0tt ------------------------------------------------- Watch More... What is Parameterized Cursor in Oracle https://www.youtube.com/watch?v=JMKwHlVi6-A What is autonomous transaction in Oracle. https://www.youtube.com/watch?v=gyvFajpfoWE What are Constraints available in Oracle. https://www.youtube.com/watch?v=WivhdLXQklQ What is Mutation Error and How to avoid mutation. https://www.youtube.com/watch?v=CbWNCyW18Bs 5 Effective way to delete Duplicate rows https://www.youtube.com/watch?v=1wtTtnc87Oc What is Difference between Delete and Truncate https://www.youtube.com/watch?v=7b6wQ3Qumgg
Views: 6725 Ram Gupta
PL/SQL tutorial 68: PL/SQL Strong Ref Cursor in Oracle Database
 
07:27
RebellionRider.com presents the second tutorial in PL/SQL Ref Cursors series explaining the concepts of Strong Ref Cursors in Oracle Database by Manish Sharma. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/ref-cursor-2 Previous Tutorial ► Record Datatypes: https://youtu.be/8WqpqKUj9l8 ► Database Cursors: https://youtu.be/_snAMqCBitg ------------------------------------------------------------------------- ►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: 8883 Manish Sharma
Stored Procedures in PL/SQL | Oracle PL/SQL Tutorial Videos | Mr.Vijay Kumar
 
18:54
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: 46881 Naresh i Technologies
Oracle : Stored Procedure Cursor
 
01:46
Java Source Code here: http://ramj2ee.blogspot.com/2015/07/oracle-stored-procedure-cursor.html Oracle : Stored Procedure Cursor. JavaEE Tutorials and Sample code - Click here : http://ramj2ee.blogspot.in/
Views: 5107 Ram N
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
PL/SQL tutorial 70: PL/SQL Weak Ref Cursor in Oracle Database
 
04:54
RebellionRider.com presents how to create PL/SQL Weak Ref Cursor in Oracle Database with example by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/ref-cursor-4 Previous Tutorial ► Strong Ref Cursor with user defined record https://youtu.be/81uJi_x-3sQ ------------------------------------------------------------------------- ►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: 5313 Manish Sharma
Oracle dynamic sql select while opening ref cursor sys ref cursor Part 8
 
07:57
Oracle SQL PLSQL and Unix Shell Scripting
Views: 1415 Sridhar Raghavan
Procedures in Oracle PL/SQL
 
23:50
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: 7525 Kishan Mashru
PL/SQL: Weak Vs Strong RefCursor && Normal cursor Vs RefCursor
 
10:26
In this tutorial, you'll learn Weak Vs Strong Ref Cursor && Normal cursor Vs Ref Cursor... 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: 8832 radhikaravikumar
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: 133687 BBarters
Oracle tutorial : How to return multiple values from the Function in Oracle PL/SQL
 
08:49
Oracle tutorial : How to return multiple values from the Function in Oracle PLSQL pl sql function This video tutorial tell you How to return multiple rows from the Function in Oracle PLSQL Using the TYPE object you can able return multiple rows from the function.Here object concept of oracle is used. Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 6356 Tech Query Pond
PL/SQL Tutorial : REF CURSOR with USING Clause
 
02:45
PL/SQL Tutorial : REF CURSOR with USING Clause SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 213 TechLake
PL/SQL Tutorial : SYS REFCURSOR Dynamic Cursor Variable
 
04:16
PL/SQL Tutorial : SYS REFCURSOR Dynamic Cursor Variable How to return Multiple values in Function using SYS_REFCURSOR SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 506 TechLake
FUNCTIONS IN ORACLE PL/SQL (basic to advance examples)
 
19:50
This video is to understand how to create an oracle pl/sql function, the video demonstrates the use of in, out and in out parameter types. The video also explains on how to call a function from a pl/sql block and from a select statement.
Views: 3856 Kishan Mashru
PL/SQL tutorial 30: Cursor FOR Loop In Oracle Database By Manish Sharma
 
04:33
Learn How To Work with Database (Explicit or Implicit) Cursors using Cursor For Loop in Oracle Database With Example By Manish Sharma on RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/cursor-for-loop-1 Previous Tutorial ► Numeric For Loop: https://youtu.be/DfAmnj2j7WI ►Install SQL Developer: https://youtu.be/zliF8kXVmeE ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 37387 Manish Sharma
Learn Oracle | How to Create a Package in PL SQL
 
07:54
Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials. Learn Oracle 10g Tutorial series contains the following videos : Learn Oracle - History of Oracle Learn Oracle - What is Oracle - Why do we need Oracle Learn Oracle - What is a Database Learn Oracle - What is Grid Computing Learn Oracle - What is Normalization Learn Oracle - What is ORDBMS Learn Oracle - What is RDBMS Learn Oracle - Alias Names, Concatenation, Distinct Keyword Learn Oracle - Controlling and Managing User Access (Data Control Language) Learn Oracle - Introduction to SQL Learn Oracle - Oracle 10g New Data Types Learn Oracle - How to Alter a Table using SQL Learn Oracle - How to Create a Package in PL SQL Learn Oracle - How to Create a Report in SQL Plus Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key Learn Oracle - How to Create a Table using SQL Learn Oracle - How to Create a Trigger in PL SQL Learn Oracle - How to Delete Data from a Table using SQL Learn Oracle - How to Drop and Truncate a Table using SQL Learn Oracle - How to Insert Data in a Table using SQL Learn Oracle - How to open ISQL Plus for the first time Learn Oracle - How to Open SQL Plus for the First Time Learn Oracle - How to Update a Table using SQL Learn Oracle - How to use Aggregate Functions in SQL Learn Oracle - How to use Functions in PL SQL Learn Oracle - How to use Group By, Having Clause in SQL Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL Learn Oracle - How to use the Character Functions, Date Functions in SQL Learn Oracle - How to use the Merge Statement in SQL Learn Oracle - How to use the ORDER BY Clause with the Select Statement Learn Oracle - How to use the SELECT Statement Learn Oracle - How to use the Transactional Control Statements in SQL Learn Oracle - How to use PL SQL Learn Oracle - Data Types in PL SQL Learn Oracle - Exception Handling in PL SQL Learn Oracle - PL SQL Conditional Logics Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor Learn Oracle - PL SQL Loops Learn Oracle - Procedure Creation in PL SQL Learn Oracle - Select Statement with WHERE Cause Learn Oracle - SQL Operators and their Precedence Learn Oracle - Using Case Function, Decode Function in SQL Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement Learn Oracle - Using Rollup Function, Cube Function Learn Oracle - Using Set Operators in SQL Learn Oracle - What are the Different SQL Data Types Learn Oracle - What are the different types of Databases Visit Pebbles Official Website - http://www.pebbles.in Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1 Engage with us on Facebook at https://www.facebook.com/PebblesChennai Please Like, Share, Comment & Subscribe
Views: 2362 Pebbles Tutorials
Top 30 PLSQL interview questions and answers
 
10:08
Most frequently asked questions: How to get distinct entries from the database? How to get results of any query which is sorted in any order? What is a mutating table error and how can you get around it? Describe the use of %ROWTYPE and %TYPE in PL/SQL What packages (if any) has Oracle provided for use by developers?Describe the use of PL/SQL tables When is a declare statement needed ? In what order should a open/fetch/loop set of commands in a PL/SQL block be implemented if you use the %NOTFOUND cursor variable in the exit when statement? Why? What are SQLCODE and SQLERRM and why are they important for PL/SQL developers? How can you find within a PL/SQL block, if a cursor is open? How can you generate debugging output from PL/SQL? What are the types of triggers? What are two parts of package ? what is the difference between to_char and to_date functions? How do you optimize SQL queries ? What are nested triggers ? What is a bitmap index? What is the usage of NVL? write a query for finding the length of the sting. please explain database architecture. How to get employee name from employee table which is the fifth highest salary of the table? Write a query to generate target column. Can we use out parameter in function? What will be the output for the below Query Select 'High' from dual where null = null; what is the difference between stored procedure and packaged procedure What are the steps you take to tune(performance tuning) the code in plsql? what is self join and how it works?? Can you alter procedure with in package? What is substr()&instr()? Difference between case and decode? Can you use sysdate in check constraints? If no, why? Difference between column level constraints & table level constraints? What is optimizer? What is nested_loop join? What is pivot operator? Tell me some oracle 10g features? What is m_view? What is master & detail tables? What is sqlcode and sqlerrm? Diff b/w procedure & packages? What are the dis_adv of packages? How to retrieve top 3 salaries from each departments? Can you update complex view? If no, why? When should rebuild one an index? Tell me some errors? Tell me some restrictions on cursor variables? What is context switching? What is bulk collect? What is nullif()? What is mutating error? What are the module's , you are working? Which will fire default first statement level or row level trigger? What is bulkcollect? And any restrictions in bulkcollect? What is the use of limit clause in bulkcollect? How to debugg your code? How to trace error handling? How to find which line error was raised? What are the methods there in save exceptions? What is functional based index? Write syntax? How to update complex view? Subscribe here : https://www.youtube.com/channel/UCofhGV_j_4cVGa9R08MsuXQ
Views: 8729 Oracle PL/SQL
Oracle Part 14 Stored Procedure Create and Execute
 
29:43
Create, replace, drop stored procedures, comment, variables, assignment, for loop, serveroutput, in parameter, execute SP
Views: 33769 Free OpenMentor
How To Use Explicit Cursor On Oracle PL/SQL
 
08:01
Main Components of Oracle PL/SQL are: BEGIN DECLARE END; / One of feature of Oracle PL/SQL is Cursor. There are two type of Cursor available, which are Implicit Cursor and Explicit Cursor. Implicit Cursor will only processing one record, meanwhile Explicit Cursor will process 1 or more records of data. To use Explicit Cursor we can use the 2+6 formula. 2 for two statements on declaration and 6 for six statements on the content (Begin-End). Please Subscribe
Views: 137 Boby Siswanto
PL/SQL tutorial 2 : PL/SQL Variables in Oracle Database By Manish Sharma RebellionRider
 
05:37
Watch and learn how to declare a variable and different ways of initialize a variable in PL/SQL by Manish Sharma Rebellion Rider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/variables-in-PL-SQL Previous Tutorial ► Block Types: 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/ 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: 159303 Manish Sharma
PL/SQL tutorial | Stored Procedure in Oracle Database 11g Complete guide
 
23:55
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: 3870 Specialize Automation
PL/SQL: Parameterized Cursors
 
06:03
In this tutorial, you'll learn what are parameterized cursors..
Views: 5465 radhikaravikumar
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: 52571 Manish Sharma

Fexofenadine hydrochloride 60 mg tablets
Crushing aricept 5mg
Amitriptyline 10mg for muscle pain
Tinidazole 500 mg used clothing
Ventolin hfa 90 mcg inhaler over the counter