Home
Search results “Replicate oracle function”
Oracle Database11g tutorials 13 || SQL substr function / SQL substring function
 
06:34
link of SQL substr blog : http://www.rebellionrider.com/SQL-substr-function.htm SQL substr function SQL Substr function will return a sub string of a specified length from the source string beginning at a given position. 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 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 ---------------------------------------------------------------------------- As the name suggests SQL Substr function will return substring from a given source string. Let's see the Syntax Substr (source_string, start_pos, Substr_length) As we can see SQL substr function takes 3 parameters. First one is Source string from which you want to extract the segment. Second parameter is Starting position for sub string from the Source string. And the third parameter is Substr_length which is the length for the substring. First two parameters are mandatory to specify while third one is optional. So we can say. SQL Substr function will return a sub string of a specified length from the source string beginning at a given position. First parameter source string can be of any data type CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB whereas both start_pos, Substr_length parameters must be number data type. The returning result of SQL Substr function is of same data type of source string. Let's see an example of SQL Substr function. SELECT substr('www.RebellionRider.com',5,14) FROM dual; Here in this query url of my website www.RebellionRider.com is our source string with the total length of 22 characters, Now, I want to extract the name of my website that is, RebellionRider. So if you count the total length of the name of the website, it is 14. That's why I have specified 14 as my third parameter of SQL Substr function which is substr_length. Also the name of the website RebellionRider is starting from 5th position therefore I have specified 5 at second parameter of SQL substr function which is strt_pos or starting position. Execute it. Here is our result RebellionRider When starting position is larger than the length of source string. In this case SQL Substr function will return NULL as a result. Let's do an example. SELECT substr('www.RebellionRider.com',23,14) FROM dual; As you can see here I have specified 23 at starting position and the total length of our source string is 22 characters Let's execute And the result is Null. Second scenario When the Substr_length is greater than source string In this case the segment return is the substring from starting position to the end of the string. For example SELECT substr('www.RebellionRider.com',5,23) FROM dual; Our starting position is at 5 means at the first R of RebellionRider and length of substring is set to 23 which is greater than the length of source string that is 22. Execute. As you can see we get a substring from first R of RebellionRider till the end of the source String. Third scenario When you supply numeric or arithmetic expression or a DATE instead of character as Source string to SQL Substr function In this scenario If you have supplied a numeric string instead of character as source string, the oracle engine casts them as a character when they occur as parameter to SQL Substr function. And if you have supplied Arithmetic expression or a DATE then The Oracle engine first solves or evaluates the Arithmetic expression or the DATE Then casts them as a character. Means if you have arithmetic expression in your source string then oracle will first solve it and then change or say cast the value of its result into character. Let's see some example. SELECT substr(50000-7,2,4) FROM dual; Oracle first evaluates the arithmetic expression that is 50000-7 equals to 49993. And then oracle engine casts this result 49993 into a character string. Means 49993 will be a 5 characters string. Starting position of substring is 2, that means from the first 9 of 49993 We specified the length of substring is 4 so we must get 9993 as our result. Let's check execute
Views: 77833 Manish Sharma
Oracle : Ntile function
 
01:42
Ntile function's detailed explaination... Oracle tutorials... easy to learn for the biginners.
Views: 243 CONNECT TO LEARN
SQL TUTORIAL - CHARACTER FUNCTIONS || TRIM || REPLACE || CONCAT || SUBSTR || INSTR || REPLACE
 
08:04
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: 1997 OCP Technology
Difference between Replace and Translate function in oracle
 
03:46
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: 1864 Kishan Mashru
SQL: TRIM function
 
06:35
In this tutorial, you'll learn how to use trim function 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: 2587 radhikaravikumar
SQL Tutorial for beginners What is Coalesce Function in Oracle
 
05:10
What is Coalesce Function in Oracle How to Get First Not Null Record in SQL Coalesce function is using for to get first not null expression from list of arguments. SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 142 TechLake
SQL Tutorial - 44: REVERSE() & STRCMP() Functions
 
03:23
In this tutorial we'll learn to reverse the order of characters in a string and also to compare two strings using the REVERSE and STRCMP functions respectively.
Views: 18012 The Bad Tutorials
Cast and Convert functions in SQL Server   Part 28
 
17:26
In this video we will learn, converting one data type to another using cast() and convert() functions. We will also learn how to use the style parameter, with convert() function. Finally we will look at a practical example of using CAST or CONVERT functions, along with group by. We will also talk about the differences between CAST and CONVERT functions and when to choose one over the other. Text version of the video http://csharp-video-tutorials.blogspot.com/2012/09/cast-and-convert-functions-in-sql.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-28-cast-and-convert-functions.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: 169037 kudvenkat
SQL Tutorial - 40: The TRIM() Function
 
02:32
In this tutorial we'll see how we can remove leading and trailing spaces from strings using the TRIM() function.
Views: 24362 The Bad Tutorials
SQL Tutorial - 36: Useful Numeric Functions Part-1
 
05:14
In this tutorial we'll learn to use the following functions-: 1. CEIL() 2. FLOOR() 3. EXP() 4. LOG() 5. LOG10() 6. POW() 7. GREATEST() 8. LEAST()
Views: 23040 The Bad Tutorials
Optimize Replication using Parallel Extracts/Replicats in Oracle GoldenGate - GG Video 21
 
01:19
In this video you will learn about some of the options you can use to Parallelise and Optimize/speedup replication in Oracle GoldenGate. . Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
PL/SQL Tutorial 4 (Oracle): Substring Command
 
04:41
PL/SQL Tutorial 4 (Oracle): Substring Command In this tutorial I show you how to use the Substring command in PL/SQL Source Code: https://github.com/mitchtabian/SQL-tutorials Subscribe to my Blog and YouTube channel to get notifications when new FREE coding tutorials are posted! Blog: http://www.codingwithmitch.com/
Views: 170 CodingWithMitch
SQL Tutorial : Difference Between Translate &  Replace in SQL Oracle
 
06:36
SQL Tutorial : Difference Between Translate & Replace in SQL Oracle SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 476 TechLake
GROUP BY with Multiple Columns (Introduction to Oracle SQL)
 
04:03
Learn how to group with multiple columns using GROUP BY in SQL. The full Introduction to Oracle SQL course is available here: https://www.databasestar.com/introduction-to-oracle-sql-course/
Views: 485 Database Star
Oracle 11g Enterprise Protection using Double-Take Availability 5.2 (FSF)
 
09:31
Oracle is a scalable, reliable, flexible, and high-performance relational database management system for many server-based operating systems. Double-Take Availability provides real-time enterprise data protection and replication. Double-Take Availability can be used to provide high availability for Oracle. Double-Take Availability offers two techniques to protect Oracle database servers. Application Level protection - where database and log files are replicated to a secondary Oracle server. Full Server Protection - where the entire configuration, system state, application, data and registry are replicated to a target server that assumes the identity and function of the source server on failover. This video demonstrates the much simpler Full Server Protection option using Double-Take Availability Full Server Failover. A side feature of this video is the fact that a migration between dissimilar hardware was performed. The source Oracle server was a Hyper-V virtual machine and the target was a VMware virtual machine.
Views: 3318 Cloud Ready Solutions
Oracle 12c New Feature Spotlight Synchronous Refresh for Materialized Views
 
54:18
Materialized views can perform a number of roles, such as improving query performance or providing replicated data. Prior to Oracle 12c, materialized views used traditional refresh methods where changes were applied to the base tables and then the materialized views were refreshed separately with one of several methods. Synchronous refresh is a new approach in Oracle 12c R1 for maintaining tables and materialized views where tables and materialized views are refreshed at the same time. This webinar will discuss the benefits of the synchronous refresh method along with how to implement it.
Views: 326 Themis Education
replace & substring | sql functions | oracle database 11g version 2 |
 
05:30
executed in oracle database 11g version 2
Views: 68 Education 4u
SQL Tutorial - 41: SUBSTR(), RIGHT() & LEFT() Functions
 
04:34
In this tutorial we'll see how we can chop off strings and use only parts of them using the SUBSTR(), RIGHT() and LEFT() Functions.
Views: 28832 The Bad Tutorials
Using SOUNDEX Function
 
03:13
Using SOUNDEX Function
Views: 966 Abe Samir's Academy
Analytic Functions versus Regular SQL in Oracle. Real Test
 
02:58
In this training video tutorial we will make Real Test for Analytic Functions versus Regular SQL in Oracle
Views: 44 Spod ssppoodd
Lead and Lag functions in SQL Server 2012
 
07:27
In this video we will discuss about Lead and Lag functions. Lead and Lag functions Introduced in SQL Server 2012 Lead function is used to access subsequent row data along with current row data Lag function is used to access previous row data along with current row data ORDER BY clause is required PARTITION BY clause is optional Syntax LEAD(Column_Name, Offset, Default_Value) OVER (ORDER BY Col1, Col2, ...) LAG(Column_Name, Offset, Default_Value) OVER (ORDER BY Col1, Col2, ...) Offset - Number of rows to lead or lag. Default_Value - The default value to return if the number of rows to lead or lag goes beyond first row or last row in a table or partition. If default value is not specified NULL is returned. We will use the following Employees table for the examples in this video SQL Script to create the Employees table Create Table Employees ( Id int primary key, Name nvarchar(50), Gender nvarchar(10), Salary int ) Go Insert Into Employees Values (1, 'Mark', 'Male', 1000) Insert Into Employees Values (2, 'John', 'Male', 2000) Insert Into Employees Values (3, 'Pam', 'Female', 3000) Insert Into Employees Values (4, 'Sara', 'Female', 4000) Insert Into Employees Values (5, 'Todd', 'Male', 5000) Insert Into Employees Values (6, 'Mary', 'Female', 6000) Insert Into Employees Values (7, 'Ben', 'Male', 7000) Insert Into Employees Values (8, 'Jodi', 'Female', 8000) Insert Into Employees Values (9, 'Tom', 'Male', 9000) Insert Into Employees Values (10, 'Ron', 'Male', 9500) Go Lead and Lag functions example WITHOUT partitions : This example Leads 2 rows and Lags 1 row from the current row. When you are on the first row, LEAD(Salary, 2, -1) allows you to move forward 2 rows and retrieve the salary from the 3rd row. When you are on the first row, LAG(Salary, 1, -1) allows us to move backward 1 row. Since there no rows beyond row 1, Lag function in this case returns the default value -1. When you are on the last row, LEAD(Salary, 2, -1) allows you to move forward 2 rows. Since there no rows beyond the last row 1, Lead function in this case returns the default value -1. When you are on the last row, LAG(Salary, 1, -1) allows us to move backward 1 row and retrieve the salary from the previous row. SELECT Name, Gender, Salary, LEAD(Salary, 2, -1) OVER (ORDER BY Salary) AS Lead_2, LAG(Salary, 1, -1) OVER (ORDER BY Salary) AS Lag_1 FROM Employees Lead and Lag functions example WITH partitions : Notice that in this example, Lead and Lag functions return default value if the number of rows to lead or lag goes beyond first row or last row in the partition. SELECT Name, Gender, Salary, LEAD(Salary, 2, -1) OVER (PARTITION By Gender ORDER BY Salary) AS Lead_2, LAG(Salary, 1, -1) OVER (PARTITION By Gender ORDER BY Salary) AS Lag_1 FROM Employees Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/lead-and-lag-functions-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/lead-and-lag-functions-in-sql-server_5.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: 46650 kudvenkat
SQL Basics Part-9 Functions and Nested Functions, String Functions, Date time Functions
 
16:20
An easy way to learn SQL in SQL Server Management Studio Environment
Views: 590 SQL Learn & Share
What is Oracle ACFS - Lesson 5 - Replication with Oracle ACFS
 
14:25
Oracle ASM Clustered File system is the next generation file system from Oracle Corp. Besides clustering, it supports replication. In this free tutorial from SkillBuilders and Oracle Certified Master John Watson, John will demonstrate how to configure (and test) ACFS replication. See all 7 lessons in this tutorial, free, at http://www.skillbuilders.com/what-is-oracle-acfs.
Views: 1235 SkillBuilders
SQL Tutorial - 39: UPPER() and LOWER() Functions
 
02:52
In this tutorial we'll learn to display characters in upper case or lower case using the UPPER and LOWER functions.
Views: 21409 The Bad Tutorials
What is the difference between replace and translate function
 
07:43
What is the difference between replace and translate function List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 69 Siva Academy
SQL Tutorial - 43: REPEAT() & REPLACE() Functions
 
02:25
In this tutorial we'll learn to repeat a string a few times and also replace a part or all of a string with another string using the REPEAT and REPLACE Functions respectively.
Views: 20370 The Bad Tutorials
Oracle Database Tutorial 52 : Data Pump expdp - How to Export full database using expdp
 
07:26
Oracle Database tutorial/SQL Tutorial 52 On Data Pump expdp utility here in this tutorial you'll learn how to export full/complete Database using expdp data pump utility of oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/database-full-export-using-expdp Tut 48 Roles: http://youtu.be/tyYxSrCXzCM ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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 [email protected] 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: 72166 Manish Sharma
GROUPING ID function in SQL Server
 
12:38
grouping_id function in sql server 2008 grouping_id in sql server 2008 example sql server grouping level In this video we will discuss 1. GROUPING_ID function in SQL Server 2. Difference between GROUPING and GROUPING_ID functions 3. Use of GROUPING_ID function GROUPING_ID function computes the level of grouping. Difference between GROUPING and GROUPING_ID Syntax : GROUPING function is used on single column, where as the column list for GROUPING_ID function must match with GROUP BY column list. GROUPING(Col1) GROUPING_ID(Col1, Col2, Col3,...) GROUPING indicates whether the column in a GROUP BY list is aggregated or not. Grouping returns 1 for aggregated or 0 for not aggregated in the result set. GROUPING_ID() function concatenates all the GOUPING() functions, perform the binary to decimal conversion, and returns the equivalent integer. In short GROUPING_ID (A, B, C) = GROUPING(A) + GROUPING(B) + GROUPING(C) Let us understand this with an example. SELECT Continent, Country, City, SUM(SaleAmount) AS TotalSales, CAST(GROUPING(Continent) AS NVARCHAR(1)) + CAST(GROUPING(Country) AS NVARCHAR(1)) + CAST(GROUPING(City) AS NVARCHAR(1)) AS Groupings, GROUPING_ID(Continent, Country, City) AS GPID FROM Sales GROUP BY ROLLUP(Continent, Country, City) Row Number 1 : Since the data is not aggregated by any column GROUPING(Continent), GROUPING(Country) and GROUPING(City) return 0 and as result we get a binar string with all ZEROS (000). When this converted to decimal we get 0 which is displayed in GPID column. Row Number 7 : The data is aggregated for Country and City columns, so GROUPING(Country) and GROUPING(City) return 1 where as GROUPING(Continent) return 0. As result we get a binar string (011). When this converted to decimal we get 10 which is displayed in GPID column. Row Number 15 : This is the Grand total row. Notice in this row the data is aggregated by all the 3 columns. Hence all the 3 GROUPING functions return 1. So we get a binary string with all ONES (111). When this converted to decimal we get 7 which is displayed in GPID column. Use of GROUPING_ID function : GROUPING_ID function is very handy if you want to sort and filter by level of grouping. Sorting by level of grouping : SELECT Continent, Country, City, SUM(SaleAmount) AS TotalSales, GROUPING_ID(Continent, Country, City) AS GPID FROM Sales GROUP BY ROLLUP(Continent, Country, City) ORDER BY GPID Filter by level of grouping : The following query retrieves only continent level aggregated data SELECT Continent, Country, City, SUM(SaleAmount) AS TotalSales, GROUPING_ID(Continent, Country, City) AS GPID FROM Sales GROUP BY ROLLUP(Continent, Country, City) HAVING GROUPING_ID(Continent, Country, City) = 3 Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/groupingid-function-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/groupingid-function-in-sql-server_27.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: 29650 kudvenkat
Grouping function in SQL Server
 
12:49
sql server rollup grouping sql server rollup replace null sql server rollup grouping replace null In this video we will discuss the use of Grouping function in SQL Server. This is continuation to Part 104. Please watch Part 104 from SQL Server tutorial before proceeding. What is Grouping function Grouping(Column) indicates whether the column in a GROUP BY list is aggregated or not. Grouping returns 1 for aggregated or 0 for not aggregated in the result set. The following query returns 1 for aggregated or 0 for not aggregated in the result set SELECT Continent, Country, City, SUM(SaleAmount) AS TotalSales, GROUPING(Continent) AS GP_Continent, GROUPING(Country) AS GP_Country, GROUPING(City) AS GP_City FROM Sales GROUP BY ROLLUP(Continent, Country, City) What is the use of Grouping function in real world When a column is aggregated in the result set, the column will have a NULL value. If you want to replace NULL with All then this GROUPING function is very handy. SELECT CASE WHEN GROUPING(Continent) = 1 THEN 'All' ELSE ISNULL(Continent, 'Unknown') END AS Continent, CASE WHEN GROUPING(Country) = 1 THEN 'All' ELSE ISNULL(Country, 'Unknown') END AS Country, CASE WHEN GROUPING(City) = 1 THEN 'All' ELSE ISNULL(City, 'Unknown') END AS City, SUM(SaleAmount) AS TotalSales FROM Sales GROUP BY ROLLUP(Continent, Country, City) Can't I use ISNULL function instead as shown below SELECT ISNULL(Continent, 'All') AS Continent, ISNULL(Country, 'All') AS Country, ISNULL(City, 'All') AS City, SUM(SaleAmount) AS TotalSales FROM Sales GROUP BY ROLLUP(Continent, Country, City) Well, you can, but only if your data does not contain NULL values. Let me explain what I mean. At the moment the raw data in our Sales has no NULL values. Let's introduce a NULL value in the City column of the row where Id = 1 Update Sales Set City = NULL where Id = 1 Now execute the following query with ISNULL function SELECT ISNULL(Continent, 'All') AS Continent, ISNULL(Country, 'All') AS Country, ISNULL(City, 'All') AS City, SUM(SaleAmount) AS TotalSales FROM Sales GROUP BY ROLLUP(Continent, Country, City) Notice that the actuall NULL value in the raw data is also replaced with the word 'All', which is incorrect. Hence the need for Grouping function. Please note : Grouping function can be used with Rollup, Cube and Grouping Sets Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/grouping-function-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/grouping-function-in-sql-server_25.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: 35739 kudvenkat
Tutorial 13 : SQL TRIM(), LTRIM() and RTRIM()
 
09:58
Hi Friends! Here we are learning about TRIM(), LTRIM() and RTRIM() function. Hope you'll understand about these functions. Let me know for any confusion or doubt. You can write me in comment box or can mail me. eMail Id - [email protected] Useful Tutorial Links : 1. SQL SINGLE ROW FUNCTION EXPLAINED https://youtu.be/VPtlTNVHDZc 2. SQL LENGTH() FUNCTION -- Length() Function Part-1 https://youtu.be/-EUd-CJLt0M -- Length() Function Part-2 https://youtu.be/I3gEsN_iYJo Thanks!
Views: 227 YourSmartCode
Strings in PL SQL Tutorial
 
07:35
Subscribe for more PL SQL tutorials https://www.youtube.com/channel/UC7sbHUgN8FnJEZkEjvKTwJg String Function & Purpose 1 ASCII(x); Returns the ASCII value of the character x. 2 CHR(x); Returns the character with the ASCII value of x. 3 CONCAT(x, y); Concatenates the strings x and y and return the appended string. 4 INITCAP(x); Converts the initial letter of each word in x to uppercase and returns that string. 5 INSTR(x, find_string [, start] [, occurrence]); Searches for find_string in x and returns the position at which it occurs. 6 INSTRB(x); Returns the location of a string within another string, but returns the value in bytes. 7 LENGTH(x); Returns the number of characters in x. TUTORIALSPOINT Simply Easy Learning Page 59 8 LENGTHB(x); Returns the length of a character string in bytes for single byte character set. 9 LOWER(x); Converts the letters in x to lowercase and returns that string. 10 LPAD(x, width [, pad_string]) ; Pads x with spaces to left, to bring the total length of the string up to width characters. 11 LTRIM(x [, trim_string]); Trims characters from the left of x. 12 NANVL(x, value); Returns value if x matches the NaN special value (not a number), otherwise x is returned. 13 NLS_INITCAP(x); Same as the INITCAP function except that it can use a different sort method as specified by NLSSORT. 14 NLS_LOWER(x) ; Same as the LOWER function except that it can use a different sort method as specified by NLSSORT. 15 NLS_UPPER(x); Same as the UPPER function except that it can use a different sort method as specified by NLSSORT. 16 NLSSORT(x); Changes the method of sorting the characters. Must be specified before any NLS function; otherwise, the default sort will be used. 17 NVL(x, value); Returns value if x is null; otherwise, x is returned. 18 NVL2(x, value1, value2); Returns value1 if x is not null; if x is null, value2 is returned. 19 REPLACE(x, search_string, replace_string); Searches x for search_string and replaces it with replace_string. 20 RPAD(x, width [, pad_string]); Pads x to the right. 21 RTRIM(x [, trim_string]); Trims x from the right. 22 SOUNDEX(x) ; Returns a string containing the phonetic representation of x. 23 SUBSTR(x, start [, length]); Returns a substring of x that begins at the position specified by start. An optional length for the substring may be supplied. 24 SUBSTRB(x); Same as SUBSTR except the parameters are expressed in bytes instead of characters for the single-byte character systems. 25 TRIM([trim_char FROM) x); Trims characters from the left and right of x. 26 UPPER(x); Converts the letters in x to uppercase and returns that string.
Views: 316 Puzzle Guru
How to create Security Rules in Oracle financial EBS R12
 
25:47
How to create Security Rules in Oracle financial EBS R12
Views: 358 SM S
SQL Developer 3.1 - Database Copy
 
04:55
This demonstration will show how to copy objects and data from one database to another. This video is part of the SQL Developer Release 3.1 New Features series. --------------------------------------------------------------------- Copyright © 2012 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.
SQL :String functions
 
03:38
In this tutorial, you'll learn how to make use of string functions...
Views: 5743 radhikaravikumar
Export With Toad for oracle
 
07:17
Views: 21900 Goldroger
SAP Replication Server 16.0 SP03 What's New
 
02:27
An introduction to new features in SAP Replication Server 16.0 SP03 release.
Views: 519 April Luo
MYSQL: String functions
 
12:55
Views: 9063 Umed Ali
CONCAT() function in SQL Server 2012
 
10:30
Concatenate Strings and Columns by using new CONCAT() function in SQL Server 2012 Check the whole "SQL Server 2012" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv17Wwmn5iFbDs5kIyvn8M3xd Check my SQL blog at: http://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 6135 SQL with Manoj
new STRING_SPLIT() function in SQL Server 2016
 
06:10
New STRING_SPLIT() function in SQL Server 2016 to split a string into multiple values & rows. Check the whole "SQL Server 2016" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv16mB9n4av00uZB5TJsdK3CG Check the details and code on my SQL blog at: https://sqlwithmanoj.com/2016/03/10/new-in-built-table-valued-function-string_split-in-sql-server-2016-to-split-strings/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 7407 SQL with Manoj
String Functions in SQL Server part-IV || REPLACE, REPLICATE, REVERSE, RIGHT, RTRIM functions in SQL
 
03:57
This video will provide you the details of each string functions in SQL Server 2014. I'll be walking through each and every kinds of build in function which are available in SQL Server in my next videos. Previous video for more String Functions String Function Part I https://www.youtube.com/watch?v=6cgn44DZ7w8 String Function Part II https://www.youtube.com/watch?v=RmyT87mstzc String Function Part III https://www.youtube.com/watch?v=lQVnQKeGlf0 ***************************************************************************************** REPLACE (Transact-SQL) Replaces all occurrences of a specified string value with another string value.  Syntax REPLACE ( string_expression , string_pattern , string_replacement )  Arguments string_expression Is the string expression to be searched. string_expression can be of a character or binary data type. string_pattern Is the substring to be found. string_pattern can be of a character or binary data type. string_pattern cannot be an empty string (''), and must not exceed the maximum number of bytes that fits on a page. string_replacement Is the replacement string. string_replacement can be of a character or binary data type.  Return Types Returns nvarchar if one of the input arguments is of the nvarchar data type; otherwise, REPLACE returns varchar. Returns NULL if any one of the arguments is NULL. If string_expression is not of type varchar(max) or nvarchar(max),REPLACE truncates the return value at 8,000 bytes. To return values greater than 8,000 bytes, string_expression must be explicitly cast to a large-value data type. ***************************************************************************************** REPLICATE (Transact-SQL) Repeats a string value a specified number of times.  Syntax REPLICATE ( string_expression ,integer_expression )  Arguments string_expression Is an expression of a character string or binary data type. string_expression can be either character or binary data. Note : If string_expression is not of type varchar(max) or nvarchar(max), REPLICATE truncates the return value at 8,000 bytes. To return values greater than 8,000 bytes, string_expression must be explicitly cast to the appropriate large-value data type. integer_expression Is an expression of any integer type, including bigint. If integer_expression is negative, NULL is returned.  Return Types Returns the same type as string_expression. ***************************************************************************************** REVERSE (Transact-SQL) Returns the reverse order of a string value.  Syntax REVERSE ( string_expression )  Arguments string_expression string_expression is an expression of a string or binary data type. string_expression can be a constant, variable, or column of either character or binary data.  Return Types varchar or nvarchar ***************************************************************************************** RIGHT (Transact-SQL) Returns the right part of a character string with the specified number of characters.  Syntax RIGHT ( character_expression , integer_expression )  Arguments character_expression Is an expression of character or binary data. character_expression can be a constant, variable, or column. character_expression can be of any data type, except text or ntext, that can be implicitly converted to varchar or nvarchar. Otherwise, use the CAST function to explicitly convertcharacter_expression. integer_expression Is a positive integer that specifies how many characters of character_expression will be returned. If integer_expression is negative, an error is returned. Ifinteger_expression is type bigint and contains a large value, character_expression must be of a large data type such as varchar(max).  Return Types Returns varchar when character_expression is a non-Unicode character data type. Returns nvarchar when character_expression is a Unicode character data type. ***************************************************************************************** RTRIM (Transact-SQL) Returns a character string after truncating all trailing blanks.  Syntax RTRIM ( character_expression )  Arguments character_expression Is an expression of character data. character_expression can be a constant, variable, or column of either character or binary data. character_expression must be of a data type that is implicitly convertible to varchar. Otherwise, use CAST to explicitly convert character_expression.  Return Types varchar or nvarchar
Views: 83 Softtech forum
SQL Concatenate All Rows Into A String
 
06:24
Combine all rows into a single string adventure works example. This method uses coalesce to remove the leading comma. Easier than for xml path in my opinion. For XML path example(next video): https://www.youtube.com/watch?v=QwPjbQosjgw
Views: 2212 Blake B
15.SQL Server Tutorial -Built-in String functions
 
09:52
Some of the built in string functions such as replicate(),space(),patindex(),stuff()
Views: 263 lakshmi sowbhagya
SQL CHARINDEX() | LOCATE() | INSTR() Function
 
02:10
The SQL CHARINDEX() | LOCATE() | INSTR() is a function and returns the index position of the first occurrence of substring of a given input string or text.
Views: 436 suresh babu
Tutorial 11 : SQL INSTR() Function
 
06:58
Hi Friends! Here we are learning about SQL INSTR() Function. Let me know for any confusion or doubt. You can write in mail - [email protected] Or, comment in comment box. Thanks!
Views: 146 YourSmartCode
DateTime functions in SQL Server   Part 25
 
15:26
In this video we will learn about different DateTime data types, and different date time functions in sql server. We will also understand the difference between terms UTC (Coordinated Universal Time) and Time Zone offset. Text version of the video http://csharp-video-tutorials.blogspot.co.uk/2012/09/datetime-functions-in-sql-server-part-25.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-25-datetime-functions-in-sql-server.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: 192796 kudvenkat
SQL Server Replace Function with Example
 
01:55
How Replace Function works in SQL Server with Example. For more SQL Server Technical Questions please Visit: http://freshersjunction.blogspot.in/search/label/SQL%20Server
Views: 2146 Ajmath Shaik
STRING FUNCTIONS IN SQL SERVER (URDU / HINDI)
 
22:09
SUBSCRIBE FOR MORE AND PRESS BELL ICON TO GET LATEST VIDEO UPDATES...
Views: 286 Learning Never Ends
SQL Tutorial - 42: The LENGTH() & INSERT() Functions
 
04:40
In this tutorial we'll learn to determine the length of strings and also to insert strings within other strings through the LENGTH() and INSERT() functions respectively.
Views: 20065 The Bad Tutorials
SQL Tutorial - 38: The CONCAT() Function
 
04:09
In this tutorial we'll learn to use the CONCAT() Function to combine strings and display them together.
Views: 26316 The Bad Tutorials

Writing service testimonials
Vedanta newsletter formats
Cover letter mental health case manager
Annotated bible slavery condone
Looking for a new career cover letter