This video shows the cause and solution to the error Parameter index out of range when dealing with JDBC.
Views: 3461
Jaret Wright
Complete Oracle PL/SQL Tutorial for Beginners Playlist here
https://www.youtube.com/playlist?list=PLI5t0u6ye3FE_9SZcS0cQZDU2qn0uB1Oi
**************************************************
Composite DataType - Collections in Oracle PL SQL
1. Difference Between Records and Collections
2. Types of Collections in Oracle
3. VARRAYS
4. Nested Table
3. Associative Arrays / Index BY Tables
4. Multi Dimensional Arrays Using Collections and Records
Views: 17710
yrrhelp
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/col-method-3
Previous Tutorial
► Intro of Collection Method: https://youtu.be/8V40IaOkGcU
► Collection Method COUNT: https://youtu.be/NNq80CcC5K8
► Collection Method EXIST: https://youtu.be/ksfwNxZl4gI
-------------------------------------------------------------------------
►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: 6148
Manish Sharma
Pagination queries using the row limiting clause to fetch N rows or a percentage of rows in a table.
For more information, see [Limiting SQL Rows](http://www.oracle.com/pls/topic/lookup?ctx=db121&id=DWHSG9188), [row_limiting_clause](http://www.oracle.com/pls/topic/lookup?ctx=db121&id=SQLRF55636).
Views: 3477
OracleDBVision
ROWNUM just assigns a counter to the rows in your query result. So why did so many people get our simple quiz on rownum wrong ?
blog: https://connor-mcdonald.com
twitter: https://twitter.com/connor_mc_d
Subscribe as new tech videos come every week!
Views: 616
Connor McDonald
Pragma exception_init in PL/SQL
Views: 15168
Naresh i Technologies
In part one of the red candy series, Chris compared the efficiency of using a index range scan and full table scan to access data. He found that a full table scan was more efficient when fetching more rows than there are table blocks.
This analysis made a big assumption however. It worked on the presumption that there was no correlation between the order of candies in the document and which the bags they were in.
In this episode tests this assumption. Chris looks at how the physical order of rows in a table can affect the efficiency of indexes on it. He discusses how Oracle tracks this via the clustering factor.
============================
The Magic of SQL with Chris Saxon
Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. 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 or merchantability, fitness for a particular purpose, and non-infringement.
Views: 3262
The Magic of SQL
http://www.dartsnutz.net/forum/ A review of the Harrows Oracle from the Harrows 2019 range. These have the new Cutterhead grip and have a black ti coating and a jade mettalic coating. They are 90% tungsten and I am reviewing the 23g version. For more info, pics and conclusion check the forum review here: https://www.dartsnutz.net/forum/showthread.php?tid=35052
Custom made darts shirt made by Red Lips Design: https://www.facebook.com/redlipsdesign/
Video Index:
Intro: 00:14
Box & Contents: 00:53
Close Look: 02:02
Detailed Dimensions: 04:38
Weight: 05:18
Balance: 05:47
Darts In Action: 06:08
Flight Slow-Mo: 09:26
Conclusion: 10:14
Outro: 11:58
Be sure to subscribe to Darts Review Channel for the best most detailed darts review on the internet.
Also check out our darts forum with over 11,000 members from all over the world and join the Darts Nutz community!
We have lots of great info and darts chat at Darts Nutz darts forum, so why not join our friendly community :)
We have all kinds of sections that can help with your game such as Darts practice Routines, Darts Advice and Tips, General Darts Chat as well as Prize Competitions!
Join us at the best Darts Forum on the net and become Darts Nutz!
Darts Forum: https://www.dartsnutz.net/forum/
Some useful darts links and videos:
Best Site For Cheap Great Quality And Value Bargain Darts: https://www.youtube.com/watch?v=ZWuB8PsgpI4
Darts Coaching Help And Advice For Beginners And Advanced With Dynamite Dave: https://www.youtube.com/watch?v=9YVYwt17dx0
Darts for beginners: https://www.dartsnutz.net/forum/forumdisplay.php?fid=29
How To Choose The Right Darts: https://www.dartsnutz.net/forum/showthread.php?tid=1500
How To Hit Your First 180 In Darts: https://www.dartsnutz.net/forum/showthread.php?tid=5294
How to find your perfect darts: https://www.dartsnutz.net/forum/showthread.php?tid=25229
Darts Practice: https://www.dartsnutz.net/forum/forumdisplay.php?fid=30
soft tip darts: https://www.dartsnutz.net/forum/forumdisplay.php?fid=64
Darts Tips & Hacks: How to remove a broken darts stem - shaft: https://www.youtube.com/watch?v=ir6sA_6TiB0
Darts Tips & Hacks: How to fix a loose stem - shaft: https://www.youtube.com/watch?v=kMy-0SGyFGE
Darts Too Light? Make Them Heavier! How to increase the weight of your darts with tungsten putty: https://www.youtube.com/watch?v=HTb9q8og96c
Quietest Dartboard ? 5 boards tested: https://www.youtube.com/watch?v=9AoBouYeutQ
Dartboard Segment Sizes Compare 1978 to 2016: https://www.youtube.com/watch?v=SNVr9wyxpkE
How I Throw Darts in Slow Motion: https://www.youtube.com/watch?v=PT9iflvh6nY
Great Daily Darts Practice Routine: https://www.youtube.com/watch?v=Jy4lw4CMBEk
VSPhoenix UK Soft Tip Darts Experience and review: https://www.youtube.com/watch?v=AZlvI2zpVTQ
Wayne Mardle blows darts out of mouth at double 10: https://www.youtube.com/watch?v=kg0u9AimDvI
Tungsten compared with other metals: https://www.youtube.com/watch?v=FMG6g8xEVs0
Best Darts Of 2017 My Top Ten Favourites: https://www.youtube.com/watch?v=r3ioV0YFslw
Best Darts of 2016 My Top Ten Favourites: https://www.youtube.com/watch?v=M19tegGDrDk
Best Darts of 2015 - My Top Ten Favourites: https://www.youtube.com/watch?v=Zt0y94_P8-8
Darts Reivew Channel Playlist:
Bulls Darts Reviews: https://www.youtube.com/playlist?list=PLg-1hWYfc-yXY7hsODbZ0ujA99evi03vZ
Bulls Fighter Darts Reviews: https://www.youtube.com/playlist?list=PLg-1hWYfc-yVPTljaod4IA9py0LObPTQt
Cuesoul Darts Reviews: https://www.youtube.com/playlist?list=PLg-1hWYfc-yXN30iouSHgcl0trePlMAkF
Elkadart Darts Reviews: https://www.youtube.com/playlist?list=PLg-1hWYfc-yWbE7u2qO_MI9Rs2vDHl2jH
Harrows Darts Reviews: https://www.youtube.com/playlist?list=PLg-1hWYfc-yW5uFisK9KxNCnYqxiIX9JS
L-Style Darts Products Reviews: https://www.youtube.com/playlist?list=PLg-1hWYfc-yVsH9NHQvy8piG99JjqpUYg
One80 Darts Reviews: https://www.youtube.com/playlist?list=PLg-1hWYfc-yVimsRJi07y-z_vvCDTbB-E
Pentathlon Darts Reviews: https://www.youtube.com/playlist?list=PLg-1hWYfc-yUJSEdRPj7L7IcIxQ7PWzkI
Shot Darts Reviews: https://www.youtube.com/playlist?list=PLg-1hWYfc-yU2-DYUl8suObJyl3_3S0pO
ShowTime Darts Reviews: https://www.youtube.com/playlist?list=PLg-1hWYfc-yXYWCjKAyVlz6OkaPqaqqD3
Target Darts Reviews: https://www.youtube.com/playlist?list=PLg-1hWYfc-yXnNiZdtiouSCALR2Ya6y1z
The Darts Factory Darts Reviews: https://www.youtube.com/playlist?list=PLg-1hWYfc-yVPmNBub8rGuMX4qHH3LfQd
Unicorn Darts Reviews: https://www.youtube.com/playlist?list=PLg-1hWYfc-yWJJ5_CWflqbhWb-rNgfy41
Voks Darts Reviews: https://www.youtube.com/playlist?list=PLg-1hWYfc-yUfU-U4ViG4GFvbuRGQZ_q5
Winmau Darts Reviews: https://www.youtube.com/playlist?list=PLg-1hWYfc-yXPqn4DYoIG2zBVntoeCilt
Dartboard Reviews: https://www.youtube.com/playlist?list=PLg-1hWYfc-yXOCHUphNq6zmjI3fNkOUe1
Soft Tip Darts Reviews: https://www.youtube.com/playlist?list=PLg-1hWYfc-yWrVkFjeiYeibdOFga6ewjL
Views: 9526
Darts Review Channel
https://www.databasestar.com/oracle-listagg/
The Oracle LISTAGG function allows you to aggregate or combine string values from multiple rows into a single row.
For example, it turns this data:
FIRST_NAME
Adam
Brad
Carrie
Into this data:
FIRST_NAME
Adam, Brad, Carrie
The same data is shown, but it’s in one row and not multiple.
It’s a valuable string manipulation function, and once you know what it is and how it works, you’ll be able to use it in your queries as needed.
So what does it look like?
The function is:
LISTAGG ( measure_expr [, delimiter]) WITHIN GROUP (order_by_clause) [OVER query_partition_clause]
These parameters are:
measure_expr: This is a column or expression that you want to concatenate the values of. In the example above, it was the first_name column. Mandatory.
delimiter: This is the character between each of the measure_expr values. Optional, the default is a comma.
order_by_clause: This is the order that the values from the measure_expr are listed. Mandatory.
query_partition_clause: This allows you to use LISTAGG as an analytic function, allowing you to show LISTAGG in groups for different rows.
One thing to be aware of is that the output of the Oracle LISTAGG function is limited to 4,000 bytes. If you get more than this, you’ll receive an error. The most common way around this that I’ve seen is to write a custom function and use a CLOB.
Watch the video to find out more and see some examples.
For more information about the Oracle LISTAGG function, including all of the SQL shown in this video and the examples, read the related article here:
https://www.databasestar.com/oracle-listagg/
Views: 2705
Database Star
"Why isn't Oracle using my index?!" is a common question people have when tuning SQL queries.
In this episode Chris compares two methods for finding all the red candies from party bags he's prepared. He shows how these are like a full table scan and an index range scan.
He goes on to compare the performance of these two approaches. He shows when a full table scan becomes more efficient than an index range scan and vice versa.
============================
The Magic of SQL with Chris Saxon
Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. 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 or merchantability, fitness for a particular purpose, and non-infringement.
Views: 8127
The Magic of SQL
A Chanel Where you can learn about Computer Information and Technology Like Asp.Net C#,Asp.Net MVC,SQL Server,Bootstrap,Oracle and more Website design.
Website : http://www.dawacit.com
Facebook : https://www.facebook.com/dawacit05
Twitter : https://twitter.com/dawacit
How to send email in ASP.NET C# using Gmail smtp server step by step
https://youtu.be/rnQphXehu7g
How to send email with attachment in Asp.Net through Gmail smtp server,simple steps
https://youtu.be/mhRe_we4hhA
How to create Navigation bar in Asp.Net with CSS
https://youtu.be/xVgtAdxhIxk
How to create website using ASP.NET very attractive design
https://youtu.be/uAKWaCl-vK4
How to create login and logout in Asp.Net MVC
https://youtu.be/7E8IK_eAsWE
Views: 32609
Dawa CIT
Link for all dot net and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
Link for slides, code samples and text version of the video
http://csharp-video-tutorials.blogspot.com/2014/05/part-1-how-to-find-nth-highest-salary_17.html
This is a very common SQL Server Interview Question. There are several ways of finding the nth highest salary.
By the end of this video, we will be able to answer all the following questions as well.
How to find nth highest salary in SQL Server using a Sub-Query
How to find nth highest salary in SQL Server using a CTE
How to find the 2nd, 3rd or 15th highest salary
Let's use the following Employees table for this demo
Use the following script to create Employees table
Create table Employees
(
ID int primary key identity,
FirstName nvarchar(50),
LastName nvarchar(50),
Gender nvarchar(50),
Salary int
)
GO
Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000)
Insert into Employees values ('Mark', 'Hastings', 'Male', 60000)
Insert into Employees values ('Steve', 'Pound', 'Male', 45000)
Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000)
Insert into Employees values ('Philip', 'Hastings', 'Male', 45000)
Insert into Employees values ('Mary', 'Lambeth', 'Female', 30000)
Insert into Employees values ('Valarie', 'Vikings', 'Female', 35000)
Insert into Employees values ('John', 'Stanmore', 'Male', 80000)
GO
To find the highest salary it is straight forward. We can simply use the Max() function as shown below.
Select Max(Salary) from Employees
To get the second highest salary use a sub query along with Max() function as shown below.
Select Max(Salary) from Employees where Salary [ (Select Max(Salary) from Employees)
To find nth highest salary using Sub-Query
SELECT TOP 1 SALARY
FROM (
SELECT DISTINCT TOP N SALARY
FROM EMPLOYEES
ORDER BY SALARY DESC
) RESULT
ORDER BY SALARY
To find nth highest salary using CTE
WITH RESULT AS
(
SELECT SALARY,
DENSE_RANK() OVER (ORDER BY SALARY DESC) AS DENSERANK
FROM EMPLOYEES
)
SELECT TOP 1 SALARY
FROM RESULT
WHERE DENSERANK = N
To find 2nd highest salary we can use any of the above queries. Simple replace N with 2.
Similarly, to find 3rd highest salary, simple replace N with 3.
Please Note: On many of the websites, you may have seen that, the following query can be used to get the nth highest salary. The below query will only work if there are no duplicates.
WITH RESULT AS
(
SELECT SALARY,
ROW_NUMBER() OVER (ORDER BY SALARY DESC) AS ROWNUMBER
FROM EMPLOYEES
)
SELECT SALARY
FROM RESULT
WHERE ROWNUMBER = 3
Views: 914210
kudvenkat
This video is useful to find the nth max salary from a table. It shows all the different ways and possibilities to find the nth max salary from a table, using a rownum sub query and the later on using a dense rank function.
Views: 11966
Kishan Mashru
After watching this video you can get clear understanding about
Mutation error and how we can avoid mutation in program.
Below is link for Useful Pl/SQL Books
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: 16110
Ram Gupta
A brief overview about Lead and Lag analytic function in Oracle
Views: 1347
Saurabh Kumar
When you create an index on multiple columns there's an important question you need to answer:
In which order should you list the columns?
This video looks at some of the factors you should consider to help answer this question.
============================
The Magic of SQL with Chris Saxon
Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. 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 or merchantability, fitness for a particular purpose, and non-infringement.
Views: 4166
The Magic of SQL
Bulk-Bind in PL/SQL
Views: 12909
Naresh i Technologies
What is Dynamic SQL in PL/SQL
Views: 20378
Naresh i Technologies
When is a Full Table Scan faster than an Index Scan? Watch Ross and Jordan act out an Oracle database reading and caching data via both methods, explaining the costs and benefits in simple and easy to understand terms.
The demonstration is part of a talk by Ross Leishman of DWS Ltd on the principles of Understanding Indexes for SQL Tuning.
The full lecture is at this link:
https://www.youtube.com/watch?v=Z4hKomnGHFA
DWS Ltd is a leading publicly listed Australian IT Services company, providing services to blue chip organisations since 1991. With a business philosophy based upon integrity, reliability and professional service delivery, DWS provides end to end IT solutions.
www.dws.com.au
Views: 2691
DWS Ltd
Oracle Virtual Column vs pseudo column
Details on pseudo column @ https://youtu.be/GIGmZwShGh4
Details on Virtual Column @ https://youtu.be/qUALFDzLDJw
Views: 55
Siva Academy
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to : Extract Records Between Two Dates: Filter or Formula:
1. Static Data: Filter using Between Crteria and then copy and paste
2. Data that changes use formula for dynamic results that update instantly. See array formula that uses COUNTIFS, INDEX, SMALL ROWS, ROW and IF Functions.
3. See the the Excel 2007 function: IFERROR
4. See the 2010 Function AGGREGATE
5. See the Excel 2003 function COUNTIF
Views: 118889
ExcelIsFun
DURGASOFT is INDIA's No.1 Software Training Center offers
online training on various technologies like JAVA, .NET ,
ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP...
courses from Hyderabad & Bangalore -India with Real Time Experts.
Mail us your requirements to [email protected]
so that our Supporting Team will arrange Demo Sessions.
Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696.
http://durgasoft.com
http://durgasoftonlinetraining.com
https://www.facebook.com/durgasoftware
http://durgajobs.com
https://www.facebook.com/durgajobsinfo......
Views: 25647
Durga Software Solutions
range vs rows in sql server
difference between rows clause and range clause in sql server
range clause vs rows clause in sql server
sql server running total query
running total example in sql server
In this video we will discuss the difference between rows and range in SQL Server. This is continuation to Part 116. Please watch Part 116 from SQL Server tutorial before proceeding.
Let us understand the difference with an example. We will use the following Employees table in this demo.
SQL Script to create the Employees table
Create Table Employees
(
Id int primary key,
Name nvarchar(50),
Salary int
)
Go
Insert Into Employees Values (1, 'Mark', 1000)
Insert Into Employees Values (2, 'John', 2000)
Insert Into Employees Values (3, 'Pam', 3000)
Insert Into Employees Values (4, 'Sara', 4000)
Insert Into Employees Values (5, 'Todd', 5000)
Go
Calculate the running total of Salary and display it against every employee row
The following query calculates the running total. We have not specified an explicit value for ROWS or RANGE clause.
SELECT Name, Salary,
SUM(Salary) OVER(ORDER BY Salary) AS RunningTotal
FROM Employees
So the above query is using the default value which is
RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
This means the above query can be re-written using an explicit value for ROWS or RANGE clause as shown below.
SELECT Name, Salary,
SUM(Salary) OVER(ORDER BY Salary
RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningTotal
FROM Employees
We can also achieve the same result, by replacing RANGE with ROWS
SELECT Name, Salary,
SUM(Salary) OVER(ORDER BY Salary
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningTotal
FROM Employees
What is the difference between ROWS and RANGE
To understand the difference we need some duplicate values for the Salary column in the Employees table.
Execute the following UPDATE script to introduce duplicate values in the Salary column
Update Employees set Salary = 1000 where Id = 2
Update Employees set Salary = 3000 where Id = 4
Go
Now execute the following query. Notice that we get the running total as expected.
SELECT Name, Salary,
SUM(Salary) OVER(ORDER BY Salary
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningTotal
FROM Employees
The following query uses RANGE instead of ROWS
SELECT Name, Salary,
SUM(Salary) OVER(ORDER BY Salary
RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS RunningTotal
FROM Employees
Notice we don't get the running total as expected.
So, the main difference between ROWS and RANGE is in the way duplicate rows are treated. ROWS treat duplicates as distinct values, where as RANGE treats them as a single entity.
All together side by side. The following query shows how running total changes
1. When no value is specified for ROWS or RANGE clause
2. When RANGE clause is used explicitly with it's default value
3. When ROWS clause is used instead of RANGE clause
SELECT Name, Salary,
SUM(Salary) OVER(ORDER BY Salary) AS [Default],
SUM(Salary) OVER(ORDER BY Salary RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS [Range],
SUM(Salary) OVER(ORDER BY Salary ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS [Rows]
FROM Employees
Text version of the video
http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-rows-and-range.html
Slides
http://csharp-video-tutorials.blogspot.com/2015/10/difference-between-rows-and-range_8.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: 34336
kudvenkat
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: 13786
Manish Sharma
DURGASOFT is INDIA's No.1 Software Training Center offers
online training on various technologies like JAVA, .NET ,
ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP...
courses from Hyderabad & Bangalore -India with Real Time Experts.
Mail us your requirements to [email protected]
so that our Supporting Team will arrange Demo Sessions.
Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696.
http://durgasoft.com
http://durgasoftonlinetraining.com
https://www.facebook.com/durgasoftware
http://durgajobs.com
https://www.facebook.com/durgajobsinfo......
Views: 8871
Durga Software Solutions
Bind Variables and Application Performance
Walter Couto - Embarcadero
Thursday, June 26, 2014 - 10am
Not many people are familiar with Bind Variables or how they can be used. Find out how bind variables can be used effectively to make your SQL perform more efficiently and why they can achieve this performance.
Walter Couto is a Software Development Manager at Embarcadero Technologies for the Embarcadero DB Power Studio family of products and has been with the company for over 12 years. He has over 18 years of development experience with a wide range of technologies.
Views: 1477
Embarcadero Technologies
Welcome to JavaScript for Beginner Series. In this video, you'll learn about Redirect and Page Print techniques in Javascript. So, let's get started.
JavaScript Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2tLfvp7bCL3c-psMH9Czs6
HTML Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2_-PqGSrVTgBpVshxpqQlw
Mobile Responsive Form using HTML & CSS: https://www.youtube.com/watch?v=SECTfL3R0B0&t=0s&index=1&list=PLysly0KYnAY3TW2A2ey5tdRK_UMRWw2Xu
SQL Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2q8cobbotVbn36XOskQR2F
FACEBOOK PAGE
https://www.facebook.com/ishwaracademy/
Views: 227
Ishwar Academy
This is a free tutorial on understanding difference between drop, delete and truncate statements. I have tried to cover most of the major difference between all these three statements and have also shown the same with simple and easy to understand examples. Hope it will be helpful to all.
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
procedure and function : https://youtu.be/q3LmOenL120
in and exists : https://youtu.be/REX4IjRYlFw
rank and dense_rank : https://youtu.be/WGSX998hZ9M
%type and %rowtype : https://youtu.be/MlLUFeZ_3eM
Views: 1775
Kishan Mashru
follows Statement in trigger
Creating Triggers in oracle
Learn Oracle PLSQL
EXAM 1Z0-144
Views: 508
khaled alkhudari
this video shows how we can display a range of records in ORACLE DATABASE using SQL
Views: 1797
P-Square Technologies
DURGASOFT is INDIA's No.1 Software Training Center offers
online training on various technologies like JAVA, .NET ,
ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP...
courses from Hyderabad & Bangalore -India with Real Time Experts.
Mail us your requirements to [email protected]
so that our Supporting Team will arrange Demo Sessions.
Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696.
http://durgasoft.com
http://durgasoftonlinetraining.com
https://www.facebook.com/durgasoftware
http://durgajobs.com
https://www.facebook.com/durgajobsinfo............
Views: 33352
Durga Software Solutions
Even when you rip out a partition from a table, queries can still execute successfully.
======================================================
Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. 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 or merchantability, fitness for a particular purpose, and non-infringement.
Views: 904
Connor McDonald
This Intermediate course expands on the Introduction to Oracle 11g course. It gives you a more detailed grass roots knowledge of Oracle SQL and Oracle PL/SQL. Author covers a wide range of topics including many types of queries, expressions, and statements. He also explores sequences, synonyms, views, materialized views, user access and security, working with indexes, and the basics of programming with PL/SQL. As with the introductory course, this intermediate course is not focused on Oracle Certification but will give you a good start towards some more advanced aspects of coding SQL and PL/SQL.
Parts:
01. What an Expression Is.
02. Types of Expressions.
03. Expression Types Demo pt. 1.
04. Expression Types Demo pt. 2.
05. Expression Types Demo pt. 3.
06. Meta Characters.
07. Regular Expression Functions.
08. Using Regular Expression Patterns.
09. Check Constraint Regular Expressions.
10. Oracle Expression Filter.
Views: 124
Free Training
SQL query to find first record and last record in single query
Views: 9449
SQL Guru
Link for all dot net and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
Link for slides, code samples and text version of the video
http://csharp-video-tutorials.blogspot.com/2014/05/part-2-sql-query-to-get-organization.html
To get the best out of this video, the following concepts need to be understood first. These are already discussed in SQL Server Tutorial.
1. Self-Join - http://www.youtube.com/watch?v=qnYSN_7qwgg
2. CTE - http://www.youtube.com/watch?v=ZXB5b-7HJHk
3. Recursive CTE - http://www.youtube.com/watch?v=GGoV0wTMCg0
Here is the problem definition:
1. Employees table contains the following columns
a) EmployeeId,
b) EmployeeName
c) ManagerId
2. If an EmployeeId is passed, the query should list down the entire organization hierarchy i.e who is the manager of the EmployeeId passed and who is managers manager and so on till full hierarchy is listed.
For example,
Scenario 1: If we pass David's EmployeeId to the query, then it should display the organization hierarchy starting from David.
Scenario 2: If we pass Lara's EmployeeId to the query, then it should display the organization hierarchy starting from Lara.
We will be Employees table for this demo. SQL to create and populate Employees table with test data
Create table Employees
(
EmployeeID int primary key identity,
EmployeeName nvarchar(50),
ManagerID int foreign key references Employees(EmployeeID)
)
GO
Insert into Employees values ('John', NULL)
Insert into Employees values ('Mark', NULL)
Insert into Employees values ('Steve', NULL)
Insert into Employees values ('Tom', NULL)
Insert into Employees values ('Lara', NULL)
Insert into Employees values ('Simon', NULL)
Insert into Employees values ('David', NULL)
Insert into Employees values ('Ben', NULL)
Insert into Employees values ('Stacy', NULL)
Insert into Employees values ('Sam', NULL)
GO
Update Employees Set ManagerID = 8 Where EmployeeName IN ('Mark', 'Steve', 'Lara')
Update Employees Set ManagerID = 2 Where EmployeeName IN ('Stacy', 'Simon')
Update Employees Set ManagerID = 3 Where EmployeeName IN ('Tom')
Update Employees Set ManagerID = 5 Where EmployeeName IN ('John', 'Sam')
Update Employees Set ManagerID = 4 Where EmployeeName IN ('David')
GO
Here is the SQL that does the job
Declare @ID int ;
Set @ID = 7;
WITH EmployeeCTE AS
(
Select EmployeeId, EmployeeName, ManagerID
From Employees
Where EmployeeId = @ID
UNION ALL
Select Employees.EmployeeId , Employees.EmployeeName, Employees.ManagerID
From Employees
JOIN EmployeeCTE
ON Employees.EmployeeId = EmployeeCTE.ManagerID
)
Select E1.EmployeeName, ISNULL(E2.EmployeeName, 'No Boss') as ManagerName
From EmployeeCTE E1
LEFT Join EmployeeCTE E2
ON E1.ManagerID = E2.EmployeeId
Views: 286058
kudvenkat
Difference Between Rank And Dense Rank in SQL IS the most common Interview Question in PLSQL Developers
Views: 874
Useful Tips
Pre-Post SQL properties of source qualifier transformation
Pre SQL: The SQL query fires initially when loading to that database.
Post SQL: The SQL query fires at the end i.e., after loading the records to the database.
Pre and Post SQL to execute SQL statement like Insert, Update, Delete before and after the load.
pre SQL means " SQL statement executed using the source connection,before a pipeline is run" and post SQL means " SQL statement executed using the source connection,after a pipeline is run".
Views: 17334
Informatica
rank and dense_rank example
difference between rank and dense_rank with example
rank vs dense_rank in sql server 2008
sql server difference between rank and dense_rank
In this video we will discuss Rank and Dense_Rank functions in SQL Server
Rank and Dense_Rank functions
Introduced in SQL Server 2005
Returns a rank starting at 1 based on the ordering of rows imposed by the ORDER BY clause
ORDER BY clause is required
PARTITION BY clause is optional
When the data is partitioned, rank is reset to 1 when the partition changes
Difference between Rank and Dense_Rank functions
Rank function skips ranking(s) if there is a tie where as Dense_Rank will not.
For example : If you have 2 rows at rank 1 and you have 5 rows in total.
RANK() returns - 1, 1, 3, 4, 5
DENSE_RANK returns - 1, 1, 2, 3, 4
Syntax :
RANK() OVER (ORDER BY Col1, Col2, ...)
DENSE_RANK() OVER (ORDER BY Col1, Col2, ...)
RANK() and DENSE_RANK() functions without PARTITION BY clause : In this example, data is not partitioned, so RANK() function provides a consecutive numbering except when there is a tie. Rank 2 is skipped as there are 2 rows at rank 1. The third row gets rank 3.
DENSE_RANK() on the other hand will not skip ranks if there is a tie. The first 2 rows get rank 1. Third row gets rank 2.
SELECT Name, Salary, Gender,
RANK() OVER (ORDER BY Salary DESC) AS [Rank],
DENSE_RANK() OVER (ORDER BY Salary DESC) AS DenseRank
FROM Employees
RANK() and DENSE_RANK() functions with PARTITION BY clause : Notice when the partition changes from Female to Male Rank is reset to 1
SELECT Name, Salary, Gender,
RANK() OVER (PARTITION BY Gender ORDER BY Salary DESC) AS [Rank],
DENSE_RANK() OVER (PARTITION BY Gender ORDER BY Salary DESC) AS DenseRank
FROM Employees
Use case for RANK and DENSE_RANK functions : Both these functions can be used to find Nth highest salary. However, which function to use depends on what you want to do when there is a tie. Let me explain with an example.
If there are 2 employees with the FIRST highest salary, there are 2 different business cases
1. If your business case is, not to produce any result for the SECOND highest salary, then use RANK function
2. If your business case is to return the next Salary after the tied rows as the SECOND highest Salary, then use DENSE_RANK function
Since we have 2 Employees with the FIRST highest salary. Rank() function will not return any rows for the SECOND highest Salary.
WITH Result AS
(
SELECT Salary,
RANK() OVER (ORDER BY Salary DESC) AS Salary_Rank
FROM Employees
)
SELECT TOP 1 Salary FROM Result WHERE Salary_Rank = 2
Though we have 2 Employees with the FIRST highest salary. Dense_Rank() function returns, the next Salary after the tied rows as the SECOND highest Salary
WITH Result AS
(
SELECT Salary,
DENSE_RANK() OVER (ORDER BY Salary DESC) AS Salary_Rank
FROM Employees
)
SELECT TOP 1 Salary FROM Result WHERE Salary_Rank = 2
You can also use RANK and DENSE_RANK functions to find the Nth highest Salary among Male or Female employee groups. The following query finds the 3rd highest salary amount paid among the Female employees group
WITH Result AS
(
SELECT Salary, Gender,
DENSE_RANK() OVER (PARTITION BY Gender ORDER BY Salary DESC) AS Salary_Rank
FROM Employees
)
SELECT TOP 1 Salary FROM Result
WHERE Salary_Rank = 3 AND Gender = 'Female'
Text version of the video
http://csharp-video-tutorials.blogspot.com/2015/10/rank-and-denserank-in-sql-server.html
Slides
http://csharp-video-tutorials.blogspot.com/2015/10/rank-and-denserank-in-sql-server_1.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: 76674
kudvenkat
oracle 12c new features
How to enable DDL Logging in oracle?
oracle 12c new features for developers
Views: 150
Siva Academy
Connect with me or follow me at
https://www.linkedin.com/in/durga0gadiraju
https://www.facebook.com/itversity
https://github.com/dgadiraju
https://www.youtube.com/c/TechnologyMentor
https://twitter.com/itversity
Views: 30593
itversity
In this tutorial, you'll learn to spool the executed queries to a file
Views: 24227
radhikaravikumar
Link for all dot net and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
Link for slides, code samples and text version of the video
http://csharp-video-tutorials.blogspot.com/2014/05/part-5-sql-query-to-find-employees.html
This question is asked is many sql server interviews. If you have used DATEDIFF() sql server function then you already know the answer.
-- Replace N with number of months
Select *
FROM Employees
Where DATEDIFF(MONTH, HireDate, GETDATE()) Between 1 and N
Views: 173463
kudvenkat
Link for all dot net and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
Link for slides, code samples and text version of the video
http://csharp-video-tutorials.blogspot.com/2014/05/part-4-delete-duplicate-rows-in-sql.html
In this video, we will discuss deleting all duplicate rows except one from a sql server table.
SQL Script to create Employees table
Create table Employees
(
ID int,
FirstName nvarchar(50),
LastName nvarchar(50),
Gender nvarchar(50),
Salary int
)
GO
Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000)
Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000)
Insert into Employees values (1, 'Mark', 'Hastings', 'Male', 60000)
Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000)
Insert into Employees values (2, 'Mary', 'Lambeth', 'Female', 30000)
Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000)
Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000)
Insert into Employees values (3, 'Ben', 'Hoskins', 'Male', 70000)
The delete query should delete all duplicate rows except one.
Here is the SQL query that does the job. PARTITION BY divides the query result set into partitions.
WITH EmployeesCTE AS
(
SELECT *, ROW_NUMBER()OVER(PARTITION BY ID ORDER BY ID) AS RowNumber
FROM Employees
)
DELETE FROM EmployeesCTE WHERE RowNumber ] 1
Views: 339376
kudvenkat
Binary Tree Indexes
For Full Course Experience Please Go To
http://mentorsnet.org/course_preview?course_id=6
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: 16776
Oresoft LWC
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
----------------------------------------------------------------------------------------
A variable is nothing but a name given to a storage area that our programs can manipulate. Each variable in PL/SQL has a specific data type, which determines the size and layout of the variable's memory; the range of values that can be stored within that memory and the set of operations that can be applied to the variable.
The name of a PL/SQL variable consists of a letter optionally followed by more letters, numerals, dollar signs, underscores, and number signs and should not exceed 30 characters. By default, variable names are not case-sensitive. You cannot use a reserved PL/SQL keyword as a variable name.
PL/SQL programming language allows to define various types of variables, which we will cover in subsequent chapters like date time data types, records, collections, etc. For this chapter, let us study only basic variable types.
With PL/SQL you can declare variables and then use them in SQL and procedural statements anywhere that an expression can be used. Variables can be used for the following:
• Temporary storage of data: Data can be temporarily stored in one or more variables for use when validating data input and for processing later in the data flow process.
• Manipulation of stored values: Variables can be used for calculations and other data manipulations without accessing the database.
• Reusability: After they are declared, variables can be used repeatedly in an application simply by referencing them in other statements, including other declarative statements.
• Ease of maintenance: When using %TYPE and %ROWTYPE (more information on %ROWTYPE is covered in a subsequent lesson), you declare variables, basing the declarations on the definitions of database columns. If an underlying definition changes, the variable declaration changes accordingly at run time. This provides data independence, reduces maintenance costs, and allows programs to adapt as the database changes to meet new business needs. More information on %TYPE is covered later in this lesson.
Types of Variables"
All PL/SQL variables have a data type, which specifies a storage format, constraints, and valid range of values. PL/SQL supports four data type categories—scalar, composite, reference, and LOB (large object)—that you can use for declaring variables, constants, and pointers.
• Scalar data types hold a single value. The main data types are those that correspond to column types in Oracle server tables; PL/SQL also supports Boolean variables.
• Composite data types, such as records, allow groups of fields to be defined and manipulated in PL/SQL blocks.
• Reference data types hold values, called pointers, that designate other program items. Reference data types are not covered in this course.
• LOB data types hold values, called locators, that specify the location of large objects (such as graphic images) that are stored out of line. LOB data types are discussed in detail later in this course.
Views: 41699
Oresoft LWC
This video tutorial explains the usage of %type variable declaration and %rowtype variable declaration. It also states the advantages of using %type and %rowtype variable declaration. At the end the viewes can easily identify the difference between %type and %rowtype variable declaration
If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below :
char and varchar2 : https://youtu.be/039qzwjWf4k
replace and translate : https://youtu.be/HKYF77BGzOE
procedure and function : https://youtu.be/q3LmOenL120
in and exists : https://youtu.be/REX4IjRYlFw
rank and dense_rank : https://youtu.be/WGSX998hZ9M
delete and truncate : https://youtu.be/u76wMm2byXo
Views: 555
Kishan Mashru
Link for all dot net and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
Link for slides, code samples and text version of the video
http://csharp-video-tutorials.blogspot.com/2014/06/part-6-transform-rows-into-columns-in.html
This is another common sql server interview question. We will be using Countries table in this example.
SQL to create the table
Create Table Countries
(
Country nvarchar(50),
City nvarchar(50)
)
GO
Insert into Countries values ('USA','New York')
Insert into Countries values ('USA','Houston')
Insert into Countries values ('USA','Dallas')
Insert into Countries values ('India','Hyderabad')
Insert into Countries values ('India','Bangalore')
Insert into Countries values ('India','New Delhi')
Insert into Countries values ('UK','London')
Insert into Countries values ('UK','Birmingham')
Insert into Countries values ('UK','Manchester')
Here is the interview question.
Write a sql query to transpose rows to columns.
Using PIVOT operator we can very easily transform rows to columns.
Select Country, City1, City2, City3
From
(
Select Country, City,
'City'+
cast(row_number() over(partition by Country order by Country)
as varchar(10)) ColumnSequence
from Countries
) Temp
pivot
(
max(City)
for ColumnSequence in (City1, City2, City3)
) Piv
Views: 193891
kudvenkat
Link for all dot net and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat/playlists
Link for slides, code samples and text version of the video
http://csharp-video-tutorials.blogspot.com/2014/06/part-8-sql-query-to-find-department.html
Scenario asked in the SQL Server Interview
Based on the above two tables write a SQL Query to get the name of the Department that has got the maximum number of Employees. To answer this question it will be helpful if you the knowledge of JOINS & GROUP BY in SQL Server. We discusses these in Parts 11 & 12 of SQL Server Tutorial video series.
SQL query that retrieves the department name with maximum number of employees
SELECT TOP 1 DepartmentName
FROM Employees
JOIN Departments
ON Employees.DepartmentID = Departments.DepartmentID
GROUP BY DepartmentName
ORDER BY COUNT(*) DESC
Scenario asked in the SQL Server Interview
Based on the above two tables write a SQL Query to get the name of the Department that has got the maximum number of Employees. To answer this question it will be helpful if you the knowledge of JOINS & GROUP BY in SQL Server. We discusses these in Parts 11 & 12 of SQL Server Tutorial video series.
SQL query that retrieves the department name with maximum number of employees
SELECT TOP 1 DepartmentName
FROM Employees
JOIN Departments
ON Employees.DepartmentID = Departments.DepartmentID
GROUP BY DepartmentName
ORDER BY COUNT(*) DESC
Views: 121542
kudvenkat
Check out http://www.pgconf.us/2015/event/73/ for the full talk details.
PostgreSQL text search has the capability to perform natural language searches and return a ranked list of matching documents, similar to a Google-style search. The capability, along with an automatic list of 'stop' words that are ignored and synonyms that are matched, is excellent for advanced document and comment-field search applications.
About the Speaker
Jamey Hanson is a reformed Oracle database administrator and developer currently working to migrate US Federal Government Oracle applications to PostgreSQL. He has presented at multiple Oracle and PostgreSQL conferences as well as taught Oracle, Internet Security and Project Management for the University of Maryland. He is interested in using PostgreSQL to explore large data sets.
Views: 935
Postgres Conference