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: 364967 kudvenkat
Database Cursors using while loop and repeat until loop using stored procedure.
Views: 1084 Professor Saad
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andrew Gould https://www.wiseowl.co.uk - In SQL Server there is only one type of loop: a WHILE loop. This video teaches you how to use them, from the basic syntax of the WHILE statement, through how to use a SELECT statement within a loop. We'll also cover how to use the BREAK command to exit from a loop, what to do when you inevitably find yourself in an endless loop and, finally, a quick introduction to using loops with cursors. You can download the script to create the Movies database used in this video at the following link: https://www.wiseowl.co.uk/files/execise-question-files/qf-898.zip You can see the range of resources and courses we offer in SQL Server here: https://www.wiseowl.co.uk/sql/ Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!
Views: 77623 WiseOwlTutorials
Identify and Delete Duplicate records/rows. Check and get the script here in my blog: http://sqlwithmanoj.com/2011/10/14/identify-delete-duplicate-records-from-a-table/ For more updates like my page in FB: https://www.facebook.com/sqlwithmanoj
Views: 24454 SQL with Manoj
Find duplicate row values in a field or multiple fields in SQL Server table with this tutorial. Do this for one column, or multiple columns. Uses SQL Server Management Studio for the demonstration.
Views: 48024 Edward Kench
Link for SQL concat function: http://www.rebellionrider.com/SQL-concat-function.htm SQL Concat function/SQL concat() function First function of SQL character manipulation function. Two have in depth knowledge of SQL concatenation operator Please watch my video on SQL concatenation Operator http://youtu.be/PYMeFe72Bas Tool used in this tutorial is command prompt. 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 Link for SQL function introduction Video 10 http://youtu.be/5rx8Q4x4-qI Link SQL concat Article http://www.rebellionrider.com/SQL-concat-function.htm Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com -------------------------------------------------------------------------------------------- SQL Concat () function is a Character manipulation function which is a category of SQL character function. We have already discussed the intro of SQL character function in Video 10. You can find link of this video in description below. Ok let's go ahead. SQL Concat () function concatenates two separate character string into one character string. Let's see the syntax Concat (string_1 , String_2) Note here that SQL Concat function takes only two arguments at a time. This SQL Concat function will return string_1 concatenated with string_2. This also means that it will return a single string which is a combined string of parameter String_1 and String_2. Both the parameters of SQL Concat function String_1 and string_2 can be of any data-type. You can even specify the columns of the table here. SQL Concat function is equivalent to the concatenation operator (||). SQL concatenation operator is represented by double solid vertical bars or we can say double pipe signs. Question: How to concatenate more than two strings as SQL Concat that can have only 2 parameters and what is the difference between SQL Concat Function and SQL concatenation operator? The one answer for the second Question What is the Difference between SQL Concat Function and SQL concatenation operator? Is While SQL Concat function takes only two parameters, The Concat operator can be repeated as often as is necessary. Meaning, by the help of SQL Concat operator you can combine as many strings as you want. And Concatenation operator is also not supported by several databases such as SQL server so this might cause problem. To answer the first question How to concatenate more than two strings as SQL Concat that can have only 2 parameters? We will have to jump over SQL developer. Let's see some examples. Say we want to retrieve the full name of an employee from Employees table. Let's try it using SQL Concat function. SELECT Concat (first_name, last_name) AS "Full Name" FROM employees; Here in this query we use two column names - first_name and last_name as arguments of our Concat function Execute. As you can see here, we get full name of our employee but there is no space in between first name and last name. We will see how to format this string using SQL Concat function in a few seconds But before that, let's see how to do the same task using SQL concatenation operator. SELECT first_name ||last_name AS "Full name" FROM employees; As you can see this query also produces the same result. Now we will see how to format full name of employees First we will do this using SQL concatenation Operator. SELECT first_name||' '||last_name AS "Full name" FROM employees; Now you can see we get space between first name and last name of the employee. Again, let's do it using SQL Concat function. Here we will see the nested function concept where we will be using nested Concat function to achieve this formatted string. SELECT Concat (Concat (first_name, ' '), last_name) FROM employees; Inner Concat function has two parameters. These are our first column name first_name and an empty string which will be a space between first name and second name. This Concat will now return a string which is the first name with space. This returning string will be the first input of our Outer Concat and column last_name will be the second input. All together this will give us the desired output. As you can see this method is complex than the first one where we use SQL concatenation operator.
Views: 81214 Manish Sharma
Iterative statements/loop series learn the concepts of While Loop in PL/SQL or In Oracle Database with Examples. also learn how to handle boolean expression in while loop ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/while-loop-in-pl-sql Previous Tutorial ► Simple Loop: https://youtu.be/AFx6QYcY1CU ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ 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: 63547 Manish Sharma
For Loop Cursor in PL/SQL
Views: 16802 Naresh i Technologies
This video is the 5th video in the series of 'working with null', this video explains the working of the lnnvl function in oracle sql with simple and easy to understand example. LNNVL provides a concise way to evaluate a condition when one or both operands of the condition may be null. The function can be used only in the WHERE clause of a query. It takes as an argument a condition and returns TRUE if the condition is FALSE or UNKNOWN and FALSE if the condition is TRUE. LNNVL can be used anywhere a scalar expression can appear, even in contexts where the IS [NOT] NULL, AND, or OR conditions are not valid but would otherwise be required to account for potential nulls. Oracle Database sometimes uses the LNNVL function internally in this way to rewrite NOT IN conditions as NOT EXISTS conditions. In such cases, output from EXPLAIN PLAN shows this operation in the plan table output. The condition can evaluate any scalar values but cannot be a compound condition containing AND, OR, or BETWEEN.
Views: 684 Kishan Mashru
Let c how to remove duplicates from a table..I have one table here 'student' It has two duplicate records. 3 joe 4 robert These two records has duplicates. So I have to remove them. I can remove them using rowid functionality using one subquery. You can give different column names in GROUP BY clause. to identify the duplicate record. You can give just primary key values also. Duplicate rows are deleted now... Query used in video: delete from student where rowid not in (select min(rowid) from student group by sno,sname); Thanks for watching...:)
Views: 15762 WingsOfTechnology
Here's a video I recorded of a webcast to a team of developers who had one hour to spare to learn about some PL/SQL best practices. I offer tips on using compile time warnings, avoiding hard-coding/repetition, using nested subprograms and in the performance arena, lightning fast coverage of FORALL, function result cache, NOCOPY and PRAGMA UDF. Fun stuff and here's the guide: 03:00 Compile-time warnings 16:25 Don’t repeat anything 21:15 Tips on writing SQL in PL/SQL 24:50 Avoid hard-coding of formulas 28:35 Keep executable sections tiny 35:15 Avoid row-by-row processing 42:10 Function result cache 54:28 NOCOPY parameter hint 56:02 Optimizing user-defined function execution in SQL Files referenced in presentation may be found at http://www.oracle.com/webfolder/technetwork/tutorials/plsql/sfdemo.zip. But for the latest set of PL/SQL scripts, go to LiveSQL.oracle.com and search by keywords (forall, nocopy, etc.). More on PL/SQL at my blog https://stevenfeuersteinonplsql.blogspot.com PL/SQL quizzes, workouts and classes at https://devgym.oracle.com ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2018 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.
There are various times when we need to find duplicate records in SQL Server. It is possible to find duplicates using DISTINCT, ROW NUMBER as well as the GROUP BY approach. ------------- May be you like this -------------- umbraco playlist : https://www.youtube.com/watch?v=zoefdruzmGE&list=PLv0T7WlllnSnYRedhwL8x-atkVxrSdd3m Angularjs playlist : https://www.youtube.com/watch?v=KXjD1RiAz1U&list=PLv0T7WlllnSkCfNftTNY8tWqCFWT0sIMd jquery playlist : https://www.youtube.com/watch?v=jVncasz_iyw&list=PLv0T7WlllnSkkNahiiWu_GMXq49X5ccfe F Wcf playlist : https://www.youtube.com/watch?v=NB4k0RC6vl0&list=PLv0T7WlllnSmcGHacEQnLgKvitcJEsSl6 c# playlist: https://www.youtube.com/watch?v=ZrP0NKbsr8s&list=PLv0T7WlllnSl9pZWMaMGsyoAmqZtW4gM0 Duplicate records can create problems sometimes when displaying reports or performing a Multiple Insert update. Finding duplicate records in a database needs further investigation. In some cases, duplicate records are positive, but it all depends on the data and the database design as well. For example, if a customer has ordered the same product twice on the same date with the the same shipping and billing address, then this may result in a duplicate record.
Views: 16596 Go Freelancer
https://www.databasestar.com/oracle-instr/ The Oracle INSTR function allows you to search a string for the occurrence of another string, and return the position of the occurrence within a string. It’s helpful for finding if a string exists within another string. It can also be used for performing further string manipulation on, like substrings. The syntax of the INSTR function is: INSTR(string, substring [, start_position [, occurrence]]) These parameters are: string: The text string that is searched in. It’s usually the larger of the two strings. Mandatory. substring: The text to search for. It’s usually the smaller of the two strings. Mandatory. start_position: This is an integer value which indicates where in the string value to start the search. Optional, and the default is 1. occurrence: The occurrence of the substring to search for. Optional, and the default is 1, which means the first occurrence. Also, the searches performed by the INSTR function are case-sensitive. The value returned by INSTR is a number value, which is the number in the location of the string where the substring is found. The first character is 1. For more information about the Oracle INSTR function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-instr/
Views: 5328 Database Star
3rd and the last tutorial in Iterative/loop statement in Oracle PL/SQL series explaining concepts of FOR loop with examples by Manish Sharma RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/numeric-for-loop-in-pl-sql Previous Tutorial ► While Loop https://youtu.be/IIlc4Sr7kFE ------------------------------------------------------------------------- ►►►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: 60614 Manish Sharma
before insert record in Database check duplicate value| insert |search|update in vb.net with source code.check duplicate value if not found then insert record in database.... #searching record in database #upadate record in database #How_to_Update_Record_in_database #how_to_Delete_record_in_database Original Credits: who made this video CODERBABA and YOUTUBE. ........................... my website https://goo.gl/yMhpe3 ............................. Thanks for watching these videos , hit like , subscribe our channel n yes don't forget to share with you friends ............................ Thanks for being with us make sure you share and stay with us with subscribing us - regards CODERBABA, codr baba, CODER BABA,Coder Baba,CoderBaba ?? ...................... Follow Us Socially ?? Facebook : https://goo.gl/tEWJ6X Instagram : https://goo.gl/2Z3nBs Twitter : https://goo.gl/Yrnxvd ............................ NO COPYRIGHT INFRINGEMENT IS INTENDED THIS PURELY FOR PROMOTING MYSELF AND SHOWING MY SKILLS AS YOUTUBE BLOGGER. THIS IS PURELY FOR NON PROFIT. ............................ LIKE ? SHARE ? SUBSCRIBE ............................ See you in next video, have a nice day. GOOD LUCK
Views: 14467 Coder Baba
Social Network for Developers ☞ https://morioh.com Aiodex’s Referral Program will give you 20% -80% commission from their transaction fee for 7 years. The value will be calculated starting from the date the member you invite sign up ☞ https://aiodex.com/p/referral-program Next Generation Shorten Platform: Optimal choice to make a profit and analyze traffic sources on the network. Shorten URLs and Earn Big Money ☞ https://viralroll.com Get Free 15 Geek ☞ https://geekcash.org Developers Chat Channel ☞ https://discord.gg/KAe3AnN Playlists Video Tutorial ☞ http://dev.edupioneer.net/f086e182ab The Complete SQL Bootcamp ☞ http://edupioneer.net/p/HJH7nHmre The Complete Oracle SQL Certification Course ☞ http://edupioneer.net/p/SJVtrUlbl SQL for Newbs: Data Analysis for Beginners ☞ http://edupioneer.net/p/rkgk_jO-3x SQL - MySQL for Data Analytics and Business Intelligence ☞ http://edupioneer.net/p/SJTQlR66W Microsoft SQL for Beginners ☞ http://edupioneer.net/p/B1IOnjlbe SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL ☞ http://edupioneer.net/p/ByFsBFzYZ Learn T-SQL From Scratch For SQL Server Administrator ☞ http://edupioneer.net/p/SJhOgIjjZ Oracle SQL : Become a Certified SQL Developer From Scratch! ☞ http://edupioneer.net/p/rkbnlLjsb SQL can be used to generate reports and present information on websites. This course covers SQL features in helping you answer more interesting questions about your data. The most popular business problems can be solved with SQL . What is the revenue growth month over month and running total revenue? Can we trust the metric, or does the data have some accidental duplicates that affect it? What are the top N orders for every month? What is the repeat purchase behaviour? All these questions can bee translated from the database using SQL into useful reports for the business. Topics covered includes: Installing Oracle database Installing TOAD Installing SQL developer Connecting TOAD and SQL Developer to Oracle Database Ordering and Limiting results Filtering data using the WHERE clause Using multiple operators with the WHERE clause How to use Views and Dual Tables Using Like operators with wild cards to achieve search patterns Removing duplicates records Using sub-queries Using character functions Using conversion functions Using numeric functions Using date functions Grouping results Aggregate functions Some real world SQL reporting What Am I Going To Get from This SQL Reporting Course? You'll discover how to use various built in features of SQL to generate useful for reports that can help a business make important decisions. Who Should Take This Course? Beginning database analysts Developers who want to keep their knowledge of SQL current Students taking classes in relational databases Anyone who wants to learn SQL Reporting Who is the target audience? Beginning database analysts Developers who want to keep their knowledge of SQL current Students taking classes in relational databases Anyone who wants to learn SQL Reporting Video source via: Udemy ---------------------------------------------------- Website: http://bit.ly/2pN2aXx Playlist: http://bit.ly/2Eyn3dI Website: http://bit.ly/2Hay229 Fanpage: http://bit.ly/2qi5j1A Twitter: http://bit.ly/2GOyTlA Pinterest: http://bit.ly/2qihWtz Tumblr: http://bit.ly/2qjBcGo
Views: 578 Big Data Training
Subscriber Comments Reply Video 11 Find and Delete Duplicate Routes Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 83 Siva Academy
A loop that executes an unlimited number of times. It encloses a sequence of statements between the keywords LOOP and END LOOP . ... If and only if the value of this expression is TRUE , the statements after LOOP execute. cursor_for_loop_statement. Issues a SQL query and loops through the rows in the result set. Writing Loops in SQL. In programming, a loop allows you to write a set of code that will run repeatedly within the same program. Many programming languages have several different types of loop to choose from, but in SQL Server there is only one: the WHILE loop TYPES OF LOOPS 1 SIMPLE LOOPS 2 CURSOR FOR LOOPS 3 WHILE LOOPS 4 NUMARIC FOR LOOPS A loop that executes an unlimited number of times. It encloses a sequence of statements between the keywords LOOP and END LOOP . With each iteration, the sequence of statements is executed, then control resumes at the top of the loop. An EXIT , GOTO , or RAISE statement branches out of the loop. At each iteration, the sequence of statements is executed and then control resumes at the top of the loop. 2. PL/SQL WHILE LOOP. Repeats a statement or group of statements while a given condition is true. It tests the condition before executing the loop body. Variables in SQL procedures (DECLARE, SET statements) ... Values can be assigned to variables using the SET statement or the SELECT INTO statement or as a default value when the variable is declared. Literals, expressions, the result of a query, and special register values can be assigned to variables. The WHILE loop test at the start of the loop and it the condition is false, the loop code is never executed. ... This is referred to as a REPEAT-UNTIL or DO-WHILE loop. PL/SQL does not directly implement a REPEAT-UNTIL loop however it is easy to construct one using an endless loop. The init step is executed first, and only once. This step allows you to declare and initialize any loop control variables. ... If it is true, the loop executes and the process repeats itself (body of loop, then increment step, and then again condition). After the condition becomes false, the 'for' loop terminates.
Views: 215 Technology mart
FORALL offers a big performance boost over repeated execution in a loop of the same DML statement (different bind variables) - by binding an array. But what if the array is not densely filled? In that case, you should consider using VALUES OF (or INDICES OF, which will be covered in another video). ======================================== Practically Perfect PL/SQL with Steven Feuerstein 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.
Newsletter signup (with exclusive discounts): https://iamtimcorey.com/general-sign-up (your email will be kept safe and you will not be spammed). Facebook Page: https://www.facebook.com/IAmTimCorey/ Want to see a full C# application built from scratch? Check out this course: https://iamtimcorey.com/courses/csharp-from-start-to-finish/ Microsoft SQL can be confusing. There are a TON of features, options, and settings to consider when attempting to use it. One of my favorite features is stored procedures. These pre-compiled queries allow you to safely and securely access and modify data. In this video, you will learn the basics of how to build a stored procedure, as well as what the benefits and drawbacks of stored procedures are. You will also learn some best practices, including how to secure your entire database in just a few simple commands.
Views: 62183 IAmTimCorey
There is a lot of interest these days in migrating data from commercial relational databases to open-source relational databases. PostgreSQL is a great choice for migration, offering advanced features, high performance, rock-solid data integrity, and a flexible open-source license. PostgreSQL is compliant with ANSI SQL. It supports drivers for nearly all development languages, and it has a strong community of active committers and companies to provide support. In this talk, we demonstrate an overall approach for migrating an application from your current Oracle database to an Amazon Aurora PostgreSQL database.
Views: 466 Amazon Web Services
SQL query to find first record and last record in single query
Views: 11354 SQL Guru
Oracle SQL Developer Product Manager Jeff Smith introduces a new client tool for working with Oracle Database - SQLcl. A command line interface that supports SQL*Plus commands but also brings in more modern features such as table and column name completion, statement recall, and new commands like CTAS, DDL, and a new version of DESC called INFO.
Views: 3100 Oracle Database Development Tools
In this video, we learn to normalize RDBMS tables up to 3NF. 1:23 - Need for Normalization 8:20 - 1NF (First Normal Form) 12:47 - 2NF (Second Normal Form) 19:07 - 3NF (Third Normal Form) C programming series (pointers, functions and DMA): https://www.youtube.com/watch?v=gozzO96tRpQ&list=PLRnuLZZ5D0KySx7rBi6iWnPaf-McGBcoC C++ programming concepts series: https://www.youtube.com/watch?v=R4iviB8g12A&list=PLRnuLZZ5D0KzAQIanRKPetLl73DoHVn6I
Views: 139440 BBarters
Explains SELECT DISTINCT or how do I remove duplicate values? From http://computerbasedtraininginc.com SQL Course. Learn by doing SQL commands for ANSI Standard SQL, Access, DB2, MySQL, Oracle, PostgreSQL, and SQL Server.
Views: 4067 cbtinc
This video demonstrates the difference between a replace function and a translate function in oracle using an suitable example. Both the function does a similar task, but has a lot of difference in implementation and output when used. Be learning the difference users can easy justify the correct scenarios on where to use translate and when to use replace. 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 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 %type and %rowtype : https://youtu.be/MlLUFeZ_3eM
Views: 2216 Kishan Mashru
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo............
Views: 219 Durga Software Solutions
FORALL offers a big performance boost over repeated execution in a loop of the same DML statement (different bind variables) - by binding an array. But what if the array is not densely filled? In that case, you should consider using INDICES OF (or VALUES OF, which will be covered in another video). ======================================== Practically Perfect PL/SQL with Steven Feuerstein 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.
Oracle Reports | Bursting On a Repeating Group & Distributing Reports | Bangla R-20 To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU Dear viewer, In this tutorial you will learn how to Burst & Distribute Reports in Oracle Reports. About Report Bursting: Oracle Reports enables you to deliver a single report to multiple destinations simultaneously. By taking advantage of this feature, you can create a single report, then send it in any format (layout driven formats, such as PDF or HTML, as well as data model driven formats, such as XML or delimited) to multiple destinations. You will modify a simple report we have provided to burst each group to a separate report. You will then modify a sample distribution XML file to send an e-mail to each destination with an attachment based on the separate reports. You will also send multiple e-mails to the same e-mail address with a single attachment (the entire report) Bursting on a Repeating frame: 1. Delete the parent (outermost) repeating frame. -in the Paper Layout -or, in the Object Navigator 2. Go to the Object Navigator. -Paper Layout -Select the main section node -Invoke its Property Inspector -Set the Repeat on property by selecting the repeating group on which the report will be burst. About Report Distribution: Report distribution enables you to design a report that can generate multiple output formats and be distributed to multiple destinations from a single run of the report. You can create distributions for an entire report, and for individual sections of the report. For example, in a single run of a report, you can generate HTML output, send a PostScript version to the printer, and also e-mail any or all sections of the report to a distribution list. Distributing a Report: 1. Define the distribution -Go to the Object Navigator -Paper Layout -Select the main section node -Invoke its Property Inspector -Click the Distribution property to invoke the distribution dialog box and set up the distribution list for that section. 2. Active the distribution -From the Menu -Select file -Click distribute or, on the command line, specify Distribute=yes. To Get more Tutorial Subscribe The Channel click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1 To Get All Post Like The Facebook Page Click here https://www.facebook.com/oracledbsolutions Follow us: Facebook: https://www.facebook.com/oracledbsolutions Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber Facebook Group: https://www.facebook.com/groups/465557066961548 Contact us: email: [email protected] Skype: oracle26solutions Mob: 01734557080, 01627422780
Views: 237 OracleDB Solutions
Learn how, by using the Oracle Database 11g Results Cache, you can get phenomenal performance from repeated executions of queries against large, static data. From Dave Anderson of SkillBuilders.com/Oracle.
Views: 3297 SkillBuilders
In this video i'm going to demonstrate you about oracle sql single row functions step by step. concat funcation, substr function, instr function, lpad function, rpad function, trim function, replace function.
Views: 3103 OCP Technology
Bitcoin donations are welcome: 1GGV3gbJeA83FWmz9hDfPri8EuqcUtodXy SAS in 60 Seconds This video series is intended to help you learn how to program using SAS for your statistical needs. In this video I demonstrate how to quickly remove duplicate data from your datasets using the SQL procedure. Often, working with duplicated data can present complications in your analysis. For example, if you are running a simple linear regression model, you would want all observations to be independent and thus not have repeated measured (duplicate ID's). In this 1 minute video, I show you how to use the SQL procedure to quickly and easily remove duplicated observations. I also demonstrate how to use SQL to bring in all of the original variables as well. Today's Code: data main; input ID x y; cards; 1 2 3 2 3 4 2 3 4 3 4 5 4 5 6 5 6 7 ; run; proc freq data=main; table ID; run; * Create a dataset that selects only the unique ID's; proc SQL; create table temp as select unique(ID) from main; quit; proc freq data=temp; run;
Views: 9147 Mike's SAS Tutorials
Oracle PL/SQL makes writing SQL so darned easy -- in fact, it is way too easy to write SQL. As a result, PL/SQL developers take SQL totally for granted, and very few organizations have any sort of guidelines in place for when, where and how to write SQL. The result? The same or similar SQL statements repeated throughout the application, making it very hard to optimize and maintain the code. This webinar starts by reviewing the role of SQL in PL/SQL applications, and the key challenges involved when writing SQL. We then step through the most important best practices for SQL construction, ranging from avoiding SQL repetition to full qualification of variable and column names. After viewing this webinar, you will be well positioned to establish and follow a set of guidelines for SQL construction that will have a significant impact on application performance and maintainability. https://asktom.oracle.com http://www.plsqlchallenge.com http://www.oracle-developer.net/ http://oracle-base.com/ http://www.oracle.com/webfolder/technetwork/tutorials/plsql/sfdemo.zip http://goo.gl/FPG79Z http://stevenfeuersteinonplsql.blogspot.de/ https://twitter.com/sfonplsql
Views: 5456 Oracle Learning Library