Home
Search results “Create type in oracle procedure”
Table valued parameters in SQL Server
 
06:46
table valued parameters example send table variable to stored procedure pass table variable as parameter to stored procedure pass table variable to sql stored procedure In this video we will discuss table valued parameters in SQL Server. Table Valued Parameter is a new feature introduced in SQL SERVER 2008. Table Valued Parameter allows a table (i.e multiple rows of data) to be passed as a parameter to a stored procedure from T-SQL code or from an application. Prior to SQL SERVER 2008, it is not possible to pass a table variable as a parameter to a stored procedure. Let us understand how to pass multiple rows to a stored procedure using Table Valued Parameter with an example. We want to insert multiple rows into the following Employees table. SQL Script to create the Employees table Create Table Employees ( Id int primary key, Name nvarchar(50), Gender nvarchar(10) ) Go Step 1 : Create User-defined Table Type CREATE TYPE EmpTableType AS TABLE ( Id INT PRIMARY KEY, Name NVARCHAR(50), Gender NVARCHAR(10) ) Go Step 2 : Use the User-defined Table Type as a parameter in the stored procedure. Table valued parameters must be passed as read-only to stored procedures, functions etc. This means you cannot perform DML operations like INSERT, UPDATE or DELETE on a table-valued parameter in the body of a function, stored procedure etc. CREATE PROCEDURE spInsertEmployees @EmpTableType EmpTableType READONLY AS BEGIN INSERT INTO Employees SELECT * FROM @EmpTableType END Step 3 : Declare a table variable, insert the data and then pass the table variable as a parameter to the stored procedure. DECLARE @EmployeeTableType EmpTableType INSERT INTO @EmployeeTableType VALUES (1, 'Mark', 'Male') INSERT INTO @EmployeeTableType VALUES (2, 'Mary', 'Female') INSERT INTO @EmployeeTableType VALUES (3, 'John', 'Male') INSERT INTO @EmployeeTableType VALUES (4, 'Sara', 'Female') INSERT INTO @EmployeeTableType VALUES (5, 'Rob', 'Male') EXECUTE spInsertEmployees @EmployeeTableType That's it. Now select the data from Employees table and notice that all the rows of the table variable are inserted into the Employees table. In our next video, we will discuss how to pass table as a parameter to the stored procedure from an ADO.NET application Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/table-valued-parameters-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/table-valued-parameters-in-sql-server_17.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: 59391 kudvenkat
Oracle : Stored Procedure with Input and Output Parameters
 
04:04
Oracle : Stored Procedure with Input and Output Parameters JavaEE Tutorials and Sample code - Click here : http://ramj2ee.blogspot.in/
Views: 30700 Ram N
PL/SQL tutorial 14 : Introduction of PL/SQL Triggers in Oracle Database By Manish sharma
 
05:55
PL/SQL Tutorial explaining what are triggers in Oracle PL/SQL, it's syntax, uses and types of triggers along with the Events in Triggers ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/introduction-of-triggers Previous Tutorial ► For Loop: https://youtu.be/DfAmnj2j7WI ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 134515 Manish Sharma
14- Create type By Add Type Procedure in SQL Server
 
06:37
Create type By Add Type Procedure in SQL Server ----------------------------------------­---------------------------- أرجوا لو الفيديو عجبك تضغط أعجبني --- ولو في أي تعليق ممكن تبعتلي وشكرا خليك أيجابي متخليش المعلومة تقف عندك شير في الخير you can download samples files from this link : https://1drv.ms/f/s!AsTNG-tTWghAo1-8Ki7DZb4ADOhF
Views: 113 sayed hawas
Oracle Forms 11g - Creating a Block from a Stored Procedure
 
13:43
This video demonstrates the process of creating an Oracle Forms data block using a stored procedure as the data source. Includes the creation of the store procedures and linking the procedures to Oracle Forms.
Views: 22176 Edward Honour
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: 11421 Kishan Mashru
Oracle PL/SQL procedure function trigger Forms Reports
 
06:57
São masi de 2.500 vídeo aulas no site da Informaticon. Aprenda nessas mais de 160 video aulas: Oracle PL/SQL procedure function trigger Forms Reports
Views: 49057 Neri Neitzke
CTE in sql server   Part 49
 
12:57
In this video we will learn about creating and referencing CTE's in SQL server. We will also learn how to create multiple CTE's using a single WITH clause. Text version of the video http://csharp-video-tutorials.blogspot.com/2012/09/common-table-expressions-part-49.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-49-cte.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: 173087 kudvenkat
PL/SQL tutorial 4: Anchored Datatype (%TYPE) in PL/SQL By Manish Sharma RebellionRider
 
06:10
Anchored datatype or %TYPE in PL/SQL are those data type which you assign to a variable based on a database object. Watch this PL/SQL Tutorial 4 and leanr about %TYPE with examples By Manish Sharma from wwww.RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/anchored-datatype Previous Tutorial ► SELECT...INTO statement in PL/SQL https://youtu.be/F5eMJhwmCQs ------------------------------------------------------------------------- ►►►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: 96562 Manish Sharma
How to Parse XML in Oracle
 
13:54
This Video Shows 1. How to Read and parse XML in Oracle using EXTRACTVALUE and XMLTABLE. 2. When to use extractvalue and XMLTable. 3. Brief Introduction to XMLPATH
Views: 9408 yrrhelp
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: 121597 BBarters
OAF How to perform DML Operations Using PLSQL Procedure
 
45:22
1.How to invoke PLSQL procedure using callableStatement API in OAF
Views: 2799 Lead Technologies
59/125 Oracle PLSQL: Working with Packages / Array Example
 
02:32
Learn Oracle PLSQL EXAM 1Z0-144 -------------------------------------------- --using pl/sql tables in packages create or replace package emp_pkg is type emp_table_type is table of employees%rowtype index by binary_integer; procedure get_employees(p_emps out emp_table_type ); end; ------------------------------- create or replace package body emp_pkg is procedure get_employees(p_emps out emp_table_type ) is begin for emp_record in (select * from employees) loop p_emps( emp_record.employee_id):=emp_record; end loop; end; end; ----------------------------------- declare v_employees emp_pkg.emp_table_type; begin emp_pkg.get_employees(v_employees); dbms_output.put_line(v_employees(101).first_name); end;
Views: 554 khaled alkhudari
PL-SQL tutorial 23 - How to perform DML via %type datatype in PLSQL
 
08:10
Hi guys this videos very helpful for everyone i am going to explain How to perform DML via %type datatype in plsql. Oracle database Unbeatable,Unbreakable Platform..
Views: 133 Oracle World
DIFFERENCE BETWEEN PROCEDURE AND FUNCTION IN ORACLE PL/SQL WITH EXAMPLE
 
06:33
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: 4161 Kishan Mashru
How to Debug Oracle Procedure | Package step by step with Toad For Oracle
 
09:05
In this Video I show you the simple and efficient way to Debugging your PL/SQL Procedure | Package with Toad For Oracle.
Views: 8059 Oracle PL/SQL World
Stored procedures in sql server   Part 18
 
20:11
In this video we will learn 1. What is a stored procedure 2. Stored Procedure example 3. Creating a stored procedure with parameters 4. Altering SP 5. Viewing the text of the SP 6. Dropping the SP 7. Encrypting stored procedure Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedures-part-18.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-18-stored-procedures.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 698352 kudvenkat
Learn Oracle | What are the Different SQL Data Types
 
03:19
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: 1618 Pebbles Tutorials
Java JDBC Tutorial - Part 6.1: Calling MySQL Stored Procedures with Java
 
06:18
NEED TO LEARN JAVA - 5 FREE JAVA VIDEO COURSES - CLICK HERE - https://goo.gl/7i95F8 --- View more videos on my "Java JDBC Tutorial" Playlist: http://goo.gl/crT4nS Download Java Source Code: http://www.luv2code.com/?p=1012 Closed-Captioning and English subtitles available. Please SUBSCRIBE to this channel: http://goo.gl/EV6Kwv --- In this video we will learn how to call MySQL Stored Procedures with Java. ---- Follow luv2code: Website: http://www.luv2code.com YouTube: http://goo.gl/EV6Kwv Twitter: http://goo.gl/ALMzLG Facebook: http://goo.gl/8pDRdA --- Join my mailing list: Get advance notice on new tutorials. Emails about 1 per week. - http://www.luv2code.com/joinlist --- Questions or problems? Post them in the comments section below. --- Want to suggest a video? Leave a comment below. I'm always looking for new video ideas. Let me know what video you'd like for me to create. --- Transcript Time - 00:00 Hi, this is Chad (Shod) with luv2code.com. Welcome back to another tutorial on Java JDBC. In this video, we’ll learn how to use stored procedures. We’ll first define what stored procedures are, next we’ll use callable statements. Then we’ll learn how to pass parameters to stored procedures. I’ll actually break this up over 4 different videos. I’ll show each parameter type in a separate video, so in this section we’ll cover IN parameters and then in the follow on sections, I’ll cover IN OUT, OUT and also result sets. Please stay tuned and check out the following videos for this. Time - 00:39 A stored procedure is a group of SQL statements that perform a particular task. They are normally created by a DBA. The stored procedures are created in a SQL language that supported by the native database. Each database has its own language. For example, MySQL has stored procedures language, Oracle uses PL/SQL and Microsoft SQL Server uses Transact SQL. Finally, the stored procedures can also have any combination of input and output parameters. For this tutorial, we’ll use the following table employees. The table has sample data for testing. I have a SQL zip file that’s you can download. It will create the table, add sample data and also set up the stored procedures. You can download it from the link below. Time - 01:22 All right, let’s go and switch over to the MySQL workbench and what I’m going to do is open up that SQL file and run it. This is our JDBC stored procedures directory. I have a subdirectory called SQL, and has this file, table set up that SQL. I’ll open this file, what this file does it basically creates a table as we see here and then it goes through and inserts a lot of sample data. Then, it also goes through and creates all of the stored procedures that we need for this tutorial, right. I’ll just go ahead and select execute and this will run and so now should I have a new table over here called employees and this table also has a collection or this database has a collection of stored procedures for this tutorial series, so get count employees, greet and increase salaries and we’ll go through all these stored procedures during the actual tutorial itself. Time - 02:24 In JDBC, you make use of callable statements to make a call to the stored procedures. There is a special syntax to call stored procedures. You make use of curly braces inside of the string. You also make use of the JDBC keyword call and that’s followed by the name of the stored procedure. In this example, we’re not passing any params, so we’ll just use the open and closed parentheses. Finally, we execute the stored procedure. Let’s talk about the parameters on the next slide. The JDBC API support different types of parameters. You can make use of the IN parameter, INOUT and also the OUT. The stored procedures can also return a result set, during the code examples in this video, I’ll show you how to register different parameters types and also values. Time - 03:09 Let’s start with IN parameters. For this parameter, we’re only passing an input parameter and the parameter is read-only. Our DBA has created a stored procedure on the database. This stored procedure will increase the salary for everyone in the department, which is kind of cool. The procedure takes two parameters. The first parameter is the department name. The second parameter is the increase amount. For example, we can call this stored procedure and increase the salaries of employees in the engineering department by $10,000. In terms of Java coding, we need to make a call to the stored procedure. First, we prepare a callable statement, since the stored procedure takes two parameters, we’ll make use of our question mark place orders for the parameters. [snip] ... See Transcripts tab
Views: 80852 luv2code
SQL: WITH Clause
 
06:11
In this tutorial, you'll learn will learn how to use with clause 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: 11619 radhikaravikumar
PL/SQL - part 2 create procedure , exception, variable scope
 
27:06
create procedure, raise exception, nested block , variable scope
Views: 440 R.N.A. Creation
Mysql - Stored Procedure with Input and Output Parameters
 
03:52
Mysql - Stored Procedure with Input and Output Parameters. JavaEE Tutorials and Sample code - Click here : http://ramj2ee.blogspot.in/
Views: 54908 Ram N
Dynamic SQL in Stored Procedure
 
09:32
In this video we will discuss, using dynamic sql in a stored procedure and it's implications from sql injection perspective. We will discuss performance implications of using dynamic sql in a stored procedure in a later video. Text version of the video http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure.html Slides http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure_11.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All SQL Server Tutorial Videos https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists Consider the following stored procedure "spSearchEmployees". We implemented this procedure in Part 139 of SQL Server tutorial. This stored procedure does not have any dynamic sql in it. It is all static sql and is immune to sql injection. Create Procedure spSearchEmployees @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Select * from Employees where (FirstName = @FirstName OR @FirstName IS NULL) AND (LastName = @LastName OR @LastName IS NULL) AND (Gender = @Gender OR @Gender IS NULL) AND (Salary = @Salary OR @Salary IS NULL) End Go Whether you are creating your dynamic sql queries in a client application like ASP.NET web application or in a stored procedure, you should never ever concatenate user input values. Instead you should be using parameters. Notice in the following example, we are creating dynamic sql queries by concatenating parameter values, instead of using parameterized queries. This stored procedure is prone to SQL injection. Let's prove this by creating a "Search Page" that calls this procedure. Create Procedure spSearchEmployeesBadDynamicSQL @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Declare @sql nvarchar(max) Set @sql = 'Select * from Employees where 1 = 1' if(@FirstName is not null) Set @sql = @sql + ' and FirstName=''' + @FirstName + '''' if(@LastName is not null) Set @sql = @sql + ' and LastName=''' + @LastName + '''' if(@Gender is not null) Set @sql = @sql + ' and Gender=''' + @Gender + '''' if(@Salary is not null) Set @sql = @sql + ' and Salary=''' + @Salary + '''' Execute sp_executesql @sql End Go Add a Web Page to the project that we have been working with in our previous video. Name it "DynamicSQLInStoredProcedure.aspx". Copy and paste the HTML and code available on my blog at the following link http://csharp-video-tutorials.blogspot.com/2017/04/dynamic-sql-in-stored-procedure.html At this point, run the application and type the following text in the "Firsname" text and click "Search" button. Notice "SalesDB" database is dropped. Our application is prone to SQL injection as we have implemented dynamic sql in our stored procedure by concatenating strings instead of using parameters. ' Drop database SalesDB -- In the following stored procedure we have implemented dynamic sql by using parameters, so this is not prone to sql injecttion. This is an example for good dynamic sql implementation. Create Procedure spSearchEmployeesGoodDynamicSQL @FirstName nvarchar(100) = NULL, @LastName nvarchar(100) = NULL, @Gender nvarchar(50) = NULL, @Salary int = NULL As Begin Declare @sql nvarchar(max) Declare @sqlParams nvarchar(max) Set @sql = 'Select * from Employees where 1 = 1' if(@FirstName is not null) Set @sql = @sql + ' and [email protected]' if(@LastName is not null) Set @sql = @sql + ' and [email protected]' if(@Gender is not null) Set @sql = @sql + ' and [email protected]' if(@Salary is not null) Set @sql = @sql + ' and [email protected]' Execute sp_executesql @sql, N'@FN nvarchar(50), @LN nvarchar(50), @Gen nvarchar(50), @sal int', @[email protected], @[email protected], @[email protected], @[email protected] End Go On the code-behind page, use stored procedure spSearchEmployeesGoodDynamicSQL instead of spSearchEmployeesBadDynamicSQL. We do not have to change any other code. At this point run the application one more time and type the following text in the "Firstname" textbox and click the "Search" button. ' Drop database SalesDB -- Notice "SalesDB" database is not dropped, So in this case our application is not succeptible to SQL injection attack. Summary : Whether you are creating dynamic sql in a client application (like a web application) or in a stored procedure always use parameters instead of concatnating strings. Using parameters to create dynamic sql statements prevents sql injection.
Views: 28163 kudvenkat
SQLPLUS: LineSize & PageSize
 
03:49
In this tutorial, you'll learn how to set linesize and pagesize . PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 15517 radhikaravikumar
PL-SQL tutorial 11 How to use %rowtype data type in PLSQL
 
07:58
Hi guys today we learn about %rowtype data type in PLSQL its use to hole multiple column value in single variable. #rowtypeDatatype #PLSQLtutorial Oracle database Unbeatable,Unbreakable Platform..
Views: 1037 Oracle World
create record in pl sql
 
10:03
how to create record in pl sql
Views: 867 Jamaal Khan
Stored Procedure transnformation in Informatica
 
33:18
Video explains how to drop the indexes on target table using PL/SQL stored Proc
Views: 22381 TEK CLASSES
PL/SQL tutorial 9: IF THEN ELSE (IF-ELSE) Statement in PL/SQL by Manish Sharma
 
04:12
3rd tutorial in the series explaining IF-THEN-ELSE statement in Oracle PL/SQL with Example. Enjoy ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/if-then-else Previous Tutorial ► IF THEN Statement https://youtu.be/IWvuFD6eD30 ------------------------------------------------------------------------- ►►►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: 58246 Manish Sharma
Creating Stored Procedures and Functions
 
32:59
لمشاهدة كورس pl / sql كاملا http://gatewaycourses.com
Views: 834 it3lm
Oracle REST Data Services Development with Oracle SQL Developer
 
16:00
Version 4.2 of Oracle SQL Developer makes it very easy to develop and deploy your Oracle REST Data Services for your Oracle Database.
Views: 11549 Jeff Smith
Oracle execute immediate dynamic sql procedure in and out parameters Part 7
 
07:45
Oracle SQL PLSQL and Unix Shell Scripting
Views: 765 Sridhar Raghavan
SQL tutorials 18: SQL Foreign Key Constraint
 
10:23
SQL Tutorial 18: SQL foreign key constraint. Topic covered in this tutorial 1. Defining SQL foreign key using create table at column level 2. Defining SQL foreign key using create table at table level 1. Defining SQL foreign key using Alter Table statement Links Website article: http://www.rebellionrider.com/sql-foreign-key.htm Primary key tutorial: http://www.rebellionrider.com/sql-foreign-key.htm Create Table Tutorial: http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is SQL Developer. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Foreign key is an Input/output data constraint which is also known as referential integrity constraint. Foreign key represent a link or say a relationship between columns of tables. Similar to primary key constraint Foreign Key constraint is also of two types. Simple Foreign key constraint and Composite Foreign key constraint. Constraint which involves only one column in foreign key in child table and one column in reference key in parent table is called Simple Foreign Key. While the constraint which involves more than one column in foreign key in child table and more than one column in reference key in the parent table is called Composite Foreign Key.
Views: 99127 Manish Sharma
how to create storeprocedure using views wizard
 
06:52
how to create store-procedure using views wizard
Views: 22 ServiceProvider
Install and configure Sql Developer on Windows | Oracle Tutorial
 
05:12
How to Install SQL Developer on Windows 1) Download for the below link http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html 2) Make sure you have Java Development Kit installed with latest version. http://www.oracle.com/technetwork/java/javase/downloads/index.html 3) Install SQL developer as rpm -ihv sqldeveloper-xxx.noarch.rpm (replace xxx with exact version of your SQL developer) Run SQL developer on linux command prompt as $ sqldeveloper 4) Create a new connection to connect to user Technology Lair : www.technologylair.org Subscribe : http://www.youtube.com/subscription_center?add_user=technologylair For More Videos : http://www.youtube.com/user/technologylair/videos For Video Tutorials :http://www.youtube.com/playlist?list=PLC71CFFF7A916DCAA For Android : http://www.youtube.com/playlist?list=PLUXK1VpPWQKHI1l-NvM5jvNKKnmNy9eHp For Linux : https://www.youtube.com/playlist?list=PLUXK1VpPWQKHV2xOmjQgUNj3Hrmcslj-H Kalam e Iqbal : http://www.youtube.com/playlist?list=PLF057785BD260F061 Like us on Facebook : https://www.facebook.com/technologylair Tweet us : http://twitter.com/technologylair Follow us : https://plus.google.com/u/0/118196883367288585963/posts Pin us : http://www.pinterest.com/technologylair/
Views: 320778 TechLair
How to Change Oracle SQL Developer Font Type & Font Size | Oracle SQL Developer Tips and Tricks
 
02:02
How to Change Oracle SQL Developer Font Size & Font Type | Oracle SQL Developer Tips and Tricks Oracle SQL Tutorial for Beginners Oracle Database Tutorial for Beginners Oracle SQL Developer Tips and Tricks Oracle Tutorial Oracle Tutorial for Beginners how to change sql developer font size how to configure sql developer for oracle sql developer ui font size how to change sql developer font type How to increase font size in sql developer Oracle SQL Developer Tips and Tricks How to increase font size in Oracle sql developer How to increase font size in pl sql developer How to chnage font in pl sql developer How to chnage font in sql developer best font for sql developer Oracle SQL Developer Tips and Tricks sql developer ide font size sql developer high resolution sql developer high dpi Oracle SQL Developer Tips and Tricks sql developer resolution oracle sql developer ui font size
DDL Triggers in sql server
 
12:31
ddl trigger example ddl trigger example in sql server ddl triggers can be used to In this video we will discuss DDL Triggers in sql server. In SQL Server there are 4 types of triggers 1. DML Triggers - Data Manipulation Language. Discussed in Parts 43 to 47 of SQL Server Tutorial. 2. DDL Triggers - Data Definition Language 3. CLR triggers - Common Language Runtime 4. Logon triggers What are DDL triggers DDL triggers fire in response to DDL events - CREATE, ALTER, and DROP (Table, Function, Index, Stored Procedure etc...). For the list of all DDL events please visit https://msdn.microsoft.com/en-us/library/bb522542.aspx Certain system stored procedures that perform DDL-like operations can also fire DDL triggers. Example - sp_rename system stored procedure What is the use of DDL triggers If you want to execute some code in response to a specific DDL event To prevent certain changes to your database schema Audit the changes that the users are making to the database structure Syntax for creating DDL trigger CREATE TRIGGER [Trigger_Name] ON [Scope (Server|Database)] FOR [EventType1, EventType2, EventType3, ...], AS BEGIN -- Trigger Body END DDL triggers scope : DDL triggers can be created in a specific database or at the server level. The following trigger will fire in response to CREATE_TABLE DDL event. Use SampleDB Go CREATE TRIGGER trMyFirstTrigger ON Database FOR CREATE_TABLE AS BEGIN Print 'New table created' END To check if the trigger has been created 1. In the Object Explorer window, expand the SampleDB database by clicking on the plus symbol. 2. Expand Programmability folder 3. Expand Database Triggers folder Please note : If you can't find the trigger that you just created, make sure to refresh the Database Triggers folder. When you execute the following code to create the table, the trigger will automatically fire and will print the message - New table created Create Table Test (Id int) The above trigger will be fired only for one DDL event CREATE_TABLE. If you want this trigger to be fired for multiple events, for example when you alter or drop a table, then separate the events using a comma as shown below. ALTER TRIGGER trMyFirstTrigger ON Database FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE AS BEGIN Print 'A table has just been created, modified or deleted' END Now if you create, alter or drop a table, the trigger will fire automatically and you will get the message - A table has just been created, modified or deleted. The 2 DDL triggers above execute some code in response to DDL events (CREATE_TABLE, ALTER_TABLE, DROP_TABLE). Now let us look at an example of how to prevent users from creating, altering or dropping tables. To do this modify the trigger as shown below. ALTER TRIGGER trMyFirstTrigger ON Database FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE AS BEGIN Rollback Print 'You cannot create, alter or drop a table' END To be able to create, alter or drop a table, you either have to disable or delete the trigger. To disable trigger 1. Right click on the trigger in object explorer and select "Disable" from the context menu 2. You can also disable the trigger using the following T-SQL command DISABLE TRIGGER trMyFirstTrigger ON DATABASE To enable trigger 1. Right click on the trigger in object explorer and select "Enable" from the context menu 2. You can also enable the trigger using the following T-SQL command ENABLE TRIGGER trMyFirstTrigger ON DATABASE To drop trigger 1. Right click on the trigger in object explorer and select "Delete" from the context menu 2. You can also drop the trigger using the following T-SQL command DROP TRIGGER trMyFirstTrigger ON DATABASE Certain system stored procedures that perform DDL-like operations can also fire DDL triggers. The following trigger will be fired when ever you rename a database object using sp_rename system stored procedure. CREATE TRIGGER trRenameTable ON DATABASE FOR RENAME AS BEGIN Print 'You just renamed something' END The following code changes the name of the TestTable to NewTestTable. When this code is executed, it will fire the trigger trRenameTable sp_rename 'TestTable', 'NewTestTable' The following code changes the name of the Id column in NewTestTable to NewId. When this code is executed, it will fire the trigger trRenameTable sp_rename 'NewTestTable.Id' , 'NewId', 'column' Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/ddl-triggers-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/ddl-triggers-in-sql-server_9.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: 57287 kudvenkat
PL/SQL tutorial 48: Declare User-Define Exception using RAISE_APPLICATION_ERROR
 
06:39
Manish Sharma from RebellionRider.com presents PL/SQL Tutorial on How To Declare User-Define Exception using RAISE_APPLICATION_ERROR in Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/user-define-exception-2 Previous Tutorial ► ------------------------------------------------------------------------- ►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: 18067 Manish Sharma
PL/SQL tutorial 5: PL/SQL Constants in Oracle Database  By Manish Sharma RebellionRider.com
 
04:34
Constant is a user defined identifier whose value remains unchanged throughout the program. Watch and learn proper way of initializing and declaring a constant in PL/SQL by Manish Sharma in PL/SQL Tutorial 5 for beginners. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/constants-in-pl-sql Previous Tutorial ► Anchored Datatype (%type) https://youtu.be/Zt0vlmTqhP4 ------------------------------------------------------------------------- ►►►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: 74035 Manish Sharma
Tutorial 38 : User Defined Record Datatype
 
05:33
Hi Friends, Here we are learning about User Defined Record Datatype. Hope the concept and example would be clear to you. Please let me know your confusion or doubt in comment box. Link (Anchor Datatype) : https://youtu.be/zPD2rnr-34Q Link (Explicit Cursor) : https://youtu.be/vUMX9AnAOt8 Link (Record Datatype Introduction) : https://youtu.be/luVXGF1Bp_E Link (Table Based Record Datatype Example 1) : https://youtu.be/SS850dKNWvA Link (Table Based Record Datatype Example 2) : https://youtu.be/808lITrp3mQ 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: 92 YourSmartCode
SQL Tutorial - 13: Inserting Data Into a Table From Another Table
 
07:00
In this tutorial we'll learn to use the INSERT Query to copy data from one table into another.
Views: 236044 The Bad Tutorials
Oracle PL/SQL On Procedure/Function  - Difference
 
59:56
Oracle PL/SQL On Procedure/Function - Difference
Views: 725 Lead Technologies
99/125 Oracle PLSQL: Creating Triggers / DDL Triggers
 
13:27
Creating Triggers in oracle Creating DDL Triggers ora_sysevent ora_dict_obj_owner ora_dict_obj_name Learn Oracle PLSQL EXAM 1Z0-144
Views: 462 khaled alkhudari
78/125 Oracle PLSQL: Design consideration  / NOCOPY Hint 2
 
15:40
Learn Oracle PLSQL EXAM 1Z0-144 ------------------------------------------------------ create or replace package nocopy_test is type number_t is table of varchar2(32767) index by binary_integer; procedure pass_by_vale(nums in out number_t); procedure pass_by_refernce(nums in out nocopy number_t); procedure init; end; ------------------------------------------------------------------------- create or replace package body nocopy_test is l_numbers number_t; c_array_size number:=1000000; c_it number:=20; procedure pass_by_vale(nums in out number_t) is indx pls_integer; begin indx:=nums.count; end; procedure pass_by_refernce(nums in out nocopy number_t) is indx pls_integer; begin indx:=nums.count; end; procedure init is begin l_numbers.delete; for i in 1..c_array_size loop l_numbers(i):='s'||i; end loop; dbms_output.put_line('start '||to_char(sysdate,'hh:mi:ss') ); for i in 1..1000 loop pass_by_vale(l_numbers); end loop; dbms_output.put_line('end '||to_char(sysdate,'hh:mi:ss') ); dbms_output.put_line('start '||to_char(sysdate,'hh:mi:ss')); for i in 1..1000 loop pass_by_refernce(l_numbers); end loop; dbms_output.put_line('end '||to_char(sysdate,'hh:mi:ss')); end; end; ----------------------------------------- begin nocopy_test.init; end;
Views: 387 khaled alkhudari
Database Tutorial 84 - What is an Oracle Procedure - Oracle DBA Tutorial
 
02:43
Database Tutorial 84 - What is an Oracle Procedure - Oracle DBA Tutorial
Views: 470 Sam Dhanasekaran
Passing Large Datasets into SQL Server Stored Procedures
 
06:20
Subscribe for more content: http://vid.io/xqZ4 Check out our other videos: http://vid.io/xqZ9 In this episode we cover how to create custom data types in SQL Server to allow us to pass stored procedures arrays of data and even large datasets.
Views: 1730 Code Insights
Oracle Data Integrator 12c - Creating a Project and Mapping: Flat File to a Table (Recorded Webcast)
 
55:39
This is the second in a series of three OLL Live recorded webcasts in the Oracle Data Integrator 12c: Getting Started series. The tutorials are located at https://apex.oracle.com/pls/apex/f?p=44785:24:0::::P24_CONTENT_ID,P24_PREV_PAGE:7952,1. There are many ways to get a flat file of data into an Oracle Database. For example, SQL*Loader is one of the proprietary tools included in many versions of Oracle Database. The problem is that other versions of other databases (such as IBM DB2, or Microsoft SQL Server) use different proprietary tools. ODI provids one standard way of importing files into many different databases. Furthermore, SQL*Loader is designed to take the data in unmodified, whereas ODI is designed to transform the data while it is being loaded. This webcast walks you through the steps that are needed to use Oracle Data Integrator Studio (ODI Studio) graphical tools to export an ASCII flat file of columnar data to an Oracle Database 12c relational table. Copyright © 2013 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Oracle Part 3 Data groups and types
 
18:14
Identify data, group data, associate data type and length
Views: 1539 Free OpenMentor

Paralegal cover letter tips
Sales assistant cover letter template
Student receptionist cover letter
Yazzy application letters
Sample cover letters for employment gaps in resumes