Home
Search results “Sql oracle pivot function”
Oracle Pivot clause
 
07:44
oracle pivot example http://easy-learning-tech.blogspot.in/2018/05/pivot-on-sql.html
Views: 2625 Siva Academy
How to use the Oracle SQL PIVOT Clause
 
11:46
PIVOT allows you to "flip a table on its side", i.e. Columns to Rows / Rows to Columns. Previously we did this with DECODE or CASE. As of Oracle 11g, Oracle Database includes the PIVOT clause (and UNPIVOT). Oracle expert Geoff Wiland from SkillBuilders will demonstrate PIVOT, UNPIVOT, including the use of aggregate functions.
Views: 11956 SkillBuilders
Oracle sql Interview Question : How to change rows to column
 
09:18
This video tutorial talks about the frequently asked oracle sql interview question of changing rows to the column. Based on the given scenario, we are asked to change the presentation of data in a table with 3 rows and 2 column to 3 columns and 2 rows. Decode Function in oracle https://youtu.be/YUAjPMjqMws Pivot and unpivot in oracle https://youtu.be/6s0DI1YcWIM
Views: 21122 Kishan Mashru
PIVOT Tutorial - generating dynamic column with PIVOT Interview Question SQL
 
14:14
In this lecture you will learn about PIVOT operator and using it to generate dynamic columns.PIVOT is very use full operator to convert values into columns. PIVOT: •Convert your output from (values)vertical order to horizontal(making columns) one Topic to cover: •PIVOT example •PIVOT syntax •Interview Question •PIVOT on northwind •Dynamic PIVOT query http://www.techsapphire.in/index/pivot_sql_lesson_with_generating_dynamic_columns_with_pivot/0-158
Views: 33770 techsapphire
SQL Tutorial - PIVOT
 
13:11
Another video brought to you by BeardedDev, bringing you tutorials on Business Intelligence, SQL Programming and Data Analysis. In this video I talk about using PIVOT in Microsoft SQL Server. T-SQL Querying https://www.amazon.com/gp/product/0735685045/ref=as_li_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=0735685045&linkCode=as2&tag=beardeddev05-20&linkId=e93b0f7483b1fa06aca5a3aec4f7764b T-SQL Fundamentals https://www.amazon.com/gp/product/150930200X/ref=as_li_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=150930200X&linkCode=as2&tag=beardeddev05-20&linkId=70aa2ffa3e84cab66cb964ca1e9cee62 Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions https://www.amazon.com/gp/product/0735658366/ref=as_li_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=0735658366&linkCode=as2&tag=beardeddev05-20&linkId=b88746aea666c9f98da147e70b4491ca Using PIVOT allows us rotate data from rows to columns making the data more readable. PIVOT is ideal for reporting in SQL Server and can be used as a starting point to visualise trends. In this PIVOT tutorial I demonstrate the difference between how data is presented compared to GROUP BY. PIVOT Syntax SELECT [columns] FROM ( [source_query] ) PIVOT ( [aggr_function]([aggr_column] FOR [spreading_column] IN ([spreading_elements])) SQL Queries in the video: Results using GROUP BY statement SELECT Sales_Customer_Id , DATENAME(MONTH, Sales_Date) AS [Month] , Sales_Amount FROM dbo.Sales GROUP BY Sales_Customer_Id , DATENAME(MONTH, Sales_Date) Results using PIVOT statement SELECT Sales_Customer_Id , [January] , [February] , [March] FROM ( SELECT Sales_Customer_Id , DATENAME(MONTH, Sales_Date) AS [Month] , Sales_Amount FROM dbo.Sales ) AS Src PIVOT ( SUM(Sales_Amount) FOR [Month] IN ([January], [February], [March]) ) AS Pvt Alternative PIVOT statement SELECT [Month] , [1] , [2] , [3] , [4] , [5] , [6] , [7] , [8] FROM ( SELECT Sales_Customer_Id , DATENAME(MONTH, Sales_Date) AS [Month] , Sales_Amount FROM dbo.Sales ) AS Src PIVOT ( SUM(Sales_Amount) FOR Sales_Customer_Id IN ([1], [2], [3], [4], [5], [6], [7], [8]) ) AS Pvt Please feel free to post comments.
Views: 7035 BeardedDev
How to use Pivot and Unpivot? (how to change rows to column and column to rows)
 
10:47
This is a video tutorial on using pivot and unpivot operators to change rows to column and columns to rows when needed, the video also demonstrates a way to change from rows to column without using the pivot operator which can be helpful if you are using and older version of oracle or some other database without the feature of pivot and unpivot. Both the operators are explained with an example for better understanding
Views: 9221 Kishan Mashru
SQL Magic: Dynamic Pivot, Polymorphic Table Functions and More
 
32:18
In October's session, Chris Saxon covered SQL magic, including the following highlights: - 0:50 - how to find table name for index (sub)partitons from *_ind_(sub)partitions - 2:00 - SQL Magic! the dynamic pivot update; converting rows & columns in a table via an update statement - 8:30 - Polymorphic table functions; the describe function & fetch_rows procedure; PTFs and the optimizer; examples on LiveSQL.oracle.com. AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. Music by bensound.com https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit Music by bensound.com
Views: 599 Oracle Developers
Pivot in sql server 2008   Part 54
 
12:25
In this video we will learn about pivot operator. Pivot is a sql server operator that can be used to turn unique values from one column, into multiple columns in the output, there by effectively rotating a table. Text version of the video http://csharp-video-tutorials.blogspot.com/2012/10/pivot-operator-in-sql-server-part-54.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-54-pivot-in-sql-server-2008.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: 204738 kudvenkat
Using Pivot clause in Oracle  PLSQL.
 
08:51
Pivot is a wonderful feature in Oracle which helps you your aggregate based sql results to be transformed from row to column where you can put your group based columns to display it's aggregate value into columns.
Views: 4143 Subhroneel Ganguly
Oracle Pivot with group total computation
 
13:41
Oracle Pivot with group total computation Watch this video for PIVOT clause https://youtu.be/smCBBgN8nEE 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: 556 Siva Academy
Getting Started with PL/SQL Table Functions: Pipelined Table Functions
 
14:49
Pipelined table functions are table functions in which rows are returned or "piped" back to the calling query before the function has completed, avoiding the blocking behavior of normal PL/SQL functions and reduce PGA consumption. This video is part of the Oracle Dev Gym class "Getting Started with Table Functions". You can watch it independent of the class, but then you miss out on the tutorials and quizzes! So visit https://devgym.oracle.com/pls/apex/dg/class/getting-started-with-pl-sql-table-functions.html and register for the class! ======================================== 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.
Oracle LISTAGG Function
 
04:57
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: 3714 Database Star
Oracle SQL Tutorial : Pivot In Oracle PL SQL
 
09:06
Oracle SQL Tutorial Oracle tutorial : Pivot In Oracle PL SQL This tutorial will explain you how to use PIVOT clause in oracle. It will show you how oracle convert rows to columns dynamically oracle pivot multiple columns example of pivot table #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond pivot query in sql sql pivot simple pivot example
Views: 5466 Tech Query Pond
Dynamically Pivot Data in SQL Server
 
13:50
In this video we will write T-SQL in SQL Server to build a dynamic query that will pivot a data set. Watch the video and get the code here: https://anthonysmoak.com/2018/08/05/how-to-dynamically-pivot-data-in-sql-server/ If you find my material useful, care to buy me a coffee? https://www.paypal.me/AnthonySmoak
Views: 7065 Anthony B. Smoak
How To Use PIVOT Operator in Oracle Database
 
13:02
PIVOT operator in Oracle Database
Views: 171 Adam Tech
Generating matrix using SQL queries using CUBE, PIVOT and ROLLUP
 
11:34
Generating matrix in SQL is bit tricky, in above lecture you will learn to generate matrix using CUBE and PIVOT, also difference between CUBE and ROLLUP. For downloading script follow link below: http://www.techsapphire.in/index/generating_matrix_using_sql_queries_using_cube_pivot_and_rollup/0-174
Views: 5194 techsapphire
SQL AND PLSQL INTERVIEW 12-PIVOT FUNCTION(change rows data to column data?
 
03:21
If You have Any Queries Comment Me in Comment Box or MY WHATSUP NUMBER 08508598428. Subscribe this Youtube Channel for Upcomming Videos. join My facebook Sql and PLSQL Discussion Page https://www.facebook.com/Oracle-SQL-PLSQL-Practical-Discussion-334342290310499/
Views: 303 Manikandan R
Part 6   Transform rows into columns in sql server
 
08:53
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: 218615 kudvenkat
Pivot & Unpivot: Databases for Developers #14
 
07:24
Sometimes you want to convert rows to columns. Or convert columns back into rows. Luckily SQL has two clauses to help you do this: PIVOT & UNPIVOT Using these you can easily transform your rows to columns and back again. Want more? Take the course: https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-next-level.html Read the blog post: https://blogs.oracle.com/sql/how-to-convert-rows-to-columns-and-back-again-with-sql-aka-pivot-and-unpivot Read the docs: PIVOT: https://docs.oracle.com/en/database/oracle/oracle-database/18/dwhsg/sql-analysis-reporting-data-warehouses.html#GUID-05BB22CD-0F53-4C90-AE84-CE3F88DBD591 UNPIVOT: https://docs.oracle.com/en/database/oracle/oracle-database/18/dwhsg/sql-analysis-reporting-data-warehouses.html#GUID-B0AC9284-DDC1-4EF7-84CD-A27DF7F8DD57 Need help with SQL? Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ ============================ 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: 1631 The Magic of SQL
SQL Server training :- How to implement Pivot?
 
10:28
For more such videos visit http://www.questpond.com For more such videos subscribe https://www.youtube.com/questpondvideos See our other Step by Step video series below :- Learn C# Step by Step https://goo.gl/FNlqn3 Learn Angular tutorial step by step https://tinyurl.com/ycd9j895 Learn MVC Core step by step :- http://tinyurl.com/y9jt3wkv Learn Design Pattern Step by Step https://goo.gl/eJdn0m Learn Data Science in 1 hour :- https://tinyurl.com/y5o7qbau Learn Power BI Step by Step:- https://tinyurl.com/y6thhkxw Learn MSBI Step by Step in 32 hours:- https://goo.gl/TTpFZN Learn Tableau step by step :- https://tinyurl.com/kh6ojyo Learn SQL Server Step by Step http://tinyurl.com/ja4zmwu Learn SharePoint Step by Step in 8 hours:- https://goo.gl/XQKHeP In this video we will try to implement Simple Pivot function in SQL Server. So we will take a simple customer and product data and pivot them on the basis of customer name and product name. FYI :- This is also one of those most asked question in SQL Server interviews. We are also distributing a 100 page Ebook "Sql Server Interview Questions". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [email protected] with the shared link and we will email you the PDF.
SQL Dynamic Pivot Example Adventure Works
 
05:16
TSQL Dynamic Pivot example in adventure works. Pivot Example: https://www.youtube.com/watch?v=HmXv76kh78M Concatenate all product ids: https://www.youtube.com/watch?v=1kfp0s-lc3M
Views: 2507 Blake B
Tutorial : Report with Dynamic Query.
 
13:28
The videos is about a very important and powerful feature of oracle apex. The video shows how to create a report with dynamically generated SQL query.
Views: 9267 Oracle Testlab
Função Oracle PIVOT
 
08:24
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle A função PIVOT cria uma matriz de informações conforme as necessidades do usuário. SELECT e.manager_id, e.department_id, count(e.employee_id) FROM hr.employees e GROUP BY e.manager_id, e.department_id ORDER BY e.manager_id, e.department_id; SELECT * FROM (SELECT manager_id, department_id, employee_id FROM hr.employees ) PIVOT ( COUNT(employee_id) FOR department_id IN (10, 20, 30, 50, 60, 80, 90) ) ORDER BY manager_id SELECT e.manager_id, d.department_name, count(e.employee_id) FROM hr.employees e INNER JOIN hr.departments d ON e.department_id = d.department_id GROUP BY e.manager_id, d.department_name ORDER BY e.manager_id, d.department_name; WITH valores_pivot AS ( SELECT e.manager_id manager_id, d.department_name department_name, e.employee_id qtd_empregados FROM hr.employees e INNER JOIN hr.departments d ON e.department_id = d.department_id ) SELECT * FROM valores_pivot PIVOT ( COUNT(qtd_empregados) FOR department_name IN ('IT', 'Administration', 'Executive', 'Marketing', 'Purchasing', 'Sales', 'Shipping') ) ORDER BY manager_id; Funções Oracle: https://www.youtube.com/playlist?list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 2833 Aprenda PL/SQL
SQL PIVOT Tutorial
 
02:04
SQL PIVOT Tutorial - Oracle 11g
Views: 2702 Niki Singh
Changing calculation logic based on a column
 
06:39
This video demonstrated how to change the logic of a given row calculation based on the value in another column. You may run in to a scenerion where you need to implement this when you have a requirement that the rows with one dimension value have logic "X" (for instance Mean) and the the rows with a different dimension value have logic "Y" (for instance a Median) assigned. This is accomplished with the Switch (Case) expression in the OBIEE formula builder.
Views: 9764 Justin W. Steigerwalt
Oracle - SQL - Advanced Grouping
 
07:03
Oracle - SQL - Advanced Grouping Watch more Videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
SQL Server  Generating Cross Tab Tables (Pivot)
 
07:39
6. Generating Cross Tab Tables (Pivot)
Views: 18654 Eagle
How to Pivot (Flip) Tables with SQL CASE & DECODE
 
04:25
Pivoting tables (columns to rows, rows to columns) is a common data analysis requirement. Learn how to accomplish this with Oracle SQL CASE and DECODE
Views: 2036 SkillBuilders
SQL Pivot Example Adventure Works
 
12:20
SQL Pivot example in adventure works.
Views: 927 Blake B
02 PIVOT and UNPIVOT
 
10:59
Views: 76 Moto Nobre
PIVOT and UNPIVOT Operators in Oracle Database 11g
 
03:03
A quick example of using the PIVOT and UNPIVOT operators introduced in Oracle Database 11g. For more information see: https://oracle-base.com/articles/11g/pivot-and-unpivot-operators-11gr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Moans Norgaard Blog: http://wedonotuse.blogspot.co.uk/ Twitter: https://twitter.com/mnorgaard Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 10478 ORACLE-BASE.com
SQL Server Programming Part 18 - Dynamic Pivot Tables
 
13:08
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 - The most annoying part of creating a pivot table in Microsoft SQL Server is listing out the column headings for the table. This video explains how to use dynamic SQL so that you no longer have to repeat this laborious task. The video includes a quick recap of basic pivot tables, how to use the QuoteName function to generate a list of column headings, how to build an SQL statement and store it as a string of text and, finally, how to execute the dynamic SQL string. 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 view a written version of this tutorial at: https://www.wiseowl.co.uk/blog/s417/pivoting-sql-data.htm 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: 46771 WiseOwlTutorials
UNPIVOT in SQL Server
 
04:33
sql server convert columns to rows in a table sql server transpose columns to rows unpivot in sql server example sql server unpivot example In this video we will discuss UNPIVOT operator in SQL Server. PIVOT operator turns ROWS into COLUMNS, where as UNPIVOT turns COLUMNS into ROWS. We dicussed PIVOT operator in Part 54 of SQL Server tutorial. Please watch Part 54 before proceeding. http://csharp-video-tutorials.blogspot.com/2012/10/pivot-operator-in-sql-server-part-54.html Let us understand UNPIVOT with an example. We will use the following tblProductSales table in this demo. SQL Script to create tblProductSales table Create Table tblProductSales ( SalesAgent nvarchar(50), India int, US int, UK int ) Go Insert into tblProductSales values ('David', 960, 520, 360) Insert into tblProductSales values ('John', 970, 540, 800) Go Write a query to turn COLUMNS into ROWS. SELECT SalesAgent, Country, SalesAmount FROM tblProductSales UNPIVOT ( SalesAmount FOR Country IN (India, US ,UK) ) AS UnpivotExample Text version of the video http://csharp-video-tutorials.blogspot.com/2015/10/unpivot-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/10/unpivot-in-sql-server_10.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: 51723 kudvenkat
TSQL: How To Automate A Three-To-Many Columns Pivot Table
 
05:55
Previous video - TSQL: How To Automate A Two-To-Many-Column Pivot Table: https://www.youtube.com/watch?v=P4WDKYWm6mk GitHub Script Location: https://github.com/tmmtsmith/SQLServer/blob/master/Admin%20Tools/OutputColumns.sql
Views: 3215 SQLInSix Minutes
How to pivot a table in MySQL
 
13:27
What is pivoting and how to pivot a table in MySQL. #### Watch the video in fullscreen at 720p for better quality ### Check this article by stratos for more explanation on pivoting a table http://stratosprovatopoulos.com/web-development/mysql/pivot-a-table-in-mysql/
Views: 20457 Mahtab alam
Analytics: 27  PIVOT and UNPIVOT
 
05:31
blog: https://connor-mcdonald.com Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. We are now looking at functions that are not specifically analytics, but they are present in the Data Warehousing Guide in the SQL for Analysi s chapter. In this session we look at how to transpose rows to columns, and columns to rows, using PIVOT and UNPIVOT. Script: https://livesql.oracle.com/apex/livesql/file/content_DCC032IJONO8467JXDM2X9I7T.html
Views: 549 Connor McDonald
Calculated Fields using values in other rows
 
05:07
Another little tip on Oracle BI based on a question I once got asked How to use formulas in calculated fields to compare values from different rows, using a function called MSUMS
Views: 4141 Edward's Oracle Blog
How to transpose column to row in sql
 
12:43
Hi friends today we will learn how to transpose column data into row of table. #transposecolumntorow Oracle database Unbeatable,Unbreakable Platform..
Views: 19012 Oracle World
DECODE FUNCTION IN ORACLE SQL
 
09:36
This video tutorial explains with proper example on how to write a decode statement, this video also demonstrates how the decode statement behaves on null values and implicit datatype conversion that happens in a decode statement.
Views: 3234 Kishan Mashru
TSQL: Building Pivot Tables
 
09:16
An example of how to build a Pivot table and how they can be useful.
Views: 12902 SQLInSix Minutes
How to return multiple values from a function in oracle pl/sql ? (without using out parameter)
 
14:19
This video demonstrates how a function can return multiple values to the calling environment, but without using multiple out parameters, the video shows an example on how we can create a object, a nested table based on the object and then returning the nested table type from the function.
Views: 24216 Kishan Mashru
Efficient Function Calls From SQL (Part 5) : Pipelined Table Functions
 
03:48
The fifth part of a mini-series of videos showing how you can improve the performance of function calls from SQL. In this episode, we compare the performance of conventions table functions with pipelined table functions. For more information see: https://oracle-base.com/articles/misc/pipelined-table-functions https://oracle-base.com/articles/misc/efficient-function-calls-from-sql Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Mike Dietrich : Blog: https://blogs.oracle.com/UPGRADE Twitter: https://twitter.com/MikeDietrichDE Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 13019 ORACLE-BASE.com
Oracle 12C New Feature Listagg function improvements
 
09:56
oracle 12c new features Queries used in the video are given in the blog link http://easy-learning-tech.blogspot.in/2018/04/oracle-12c-new-feature-listagg-function.html oracle 12c new features for developers
Views: 2280 Siva Academy
Oracle Coherence Pivot Tables
 
25:39
This presentation is based on Jonathan Knight's excellent blog article (http://thegridman.com/coherence/oracle-coherence-pivot-table-queries/) on the same subject. Here he will elaborate on this article and talk further about how Oracle Coherence can be used to perform pivot-table like queries using the Coherence GroupAggregator.
Views: 1368 OracleCoherence
PIVOT Clause
 
05:52
Views: 41 Geeky Abhijeet
Oracle interview question Procedure Vs Function
 
07:30
Difference between Procedure and Function List of all the SQL and PLSQL interview questions https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 5512 Siva Academy
SQL 2008 series: SQL Pivot / SQL Dynamic Query
 
06:33
http://www.creativecommit.com This demo gives a brief overview of SQL pivot and constructing dynamic queries
Views: 10412 creativecommIT
SQL Pivot, a working copy-paste example
 
02:41
/* Why Pivot? Pivoting is just showing aggregate data sideways. It just the same data in another format, another angle of the data. */ -- Generate sample data, Hotel rooms and prices DECLARE @t TABLE (RoomType varchar(20), Price money, RoomNumber int) INSERT INTO @t(RoomType, Price, RoomNumber) VALUES ( 'SingleRoom' ,100.00, 300) , ( 'SingleRoom' , 92.00, 301 ), ( 'DoubleRoom', 140.00, 316), ( 'DoubleRoom', 120.00, 317), ( 'DoubleRoom', 180.00, 318), ( 'Suite', 500.00, 900) --------Example 1: Basic pivoting---------------------------------------------------------- SELECT 'Average Price:' as Pivoted, SingleRoom,DoubleRoom --,Suite /* 1] Choice from Rows to pivot in section 4 */ FROM ( SELECT RoomType, Price /* 2]: The Columns needed */ FROM @t ) AS ColumnsNeeded PIVOT( AVG(Price) /*3] Aggregate Function */ For RoomType in ([SingleRoom], [DoubleRoom], Suite) /* 4], Rows to pivot */ ) AS RowsToPivot; -- Regular aggregate query--------------------------------------------------------------------- SELECT RoomType, avg(Price) as AveragePrice FROM @T GROUP BY Roomtype go ---------- Example 2, see multiple pivoted aggregates DECLARE @t TABLE (RoomType varchar(20), Price money, RoomNumber int) INSERT INTO @t(RoomType, Price, RoomNumber) VALUES ( 'SingleRoom' ,100.00, 300) , ( 'SingleRoom' ,92.00, 301 ), ( 'DoubleRoom', 140.00, 316), ( 'DoubleRoom', 120.00, 317), ( 'DoubleRoom', 180.00, 318), ( 'Suite', 500.00, 900) -- Pivoted: Rows become columns. You may choose a small part or ALL rows SELECT 'Best Price:' as HotelRate, SingleRoom, DoubleRoom ,Suite FROM ( SELECT RoomType, Price FROM @t ) as ColumnsNeeded PIVOT( min(Price) /* Aggregate Function */ For RoomType in ([SingleRoom],[DoubleRoom],Suite /* Selected Rows */ ) ) as RowsToPivot UNION ALL SELECT 'Average Price:' as Pivoted,SingleRoom,DoubleRoom ,Suite /* [1] Choose rows which become columns */ FROM ( SELECT RoomType, Price /* 2: The Columns needed */ FROM @t ) AS ColumnsNeeded PIVOT( AVG(Price) /*3 Aggregate Function */ For RoomType in ([SingleRoom], [DoubleRoom], Suite /* 4, Rows needed */ ) ) AS RowsToPivot UNION ALL SELECT 'Max Price:' as Pivoted,SingleRoom,DoubleRoom ,Suite /* [1] Choose rows which become columns */ FROM ( SELECT RoomType, Price /* 2: The Columns needed */ FROM @t ) AS ColumnsNeeded PIVOT( Max(Price) /*3 Aggregate Function */ For RoomType in ([SingleRoom], [DoubleRoom], Suite /* 4, Rows needed */ ) ) AS RowsToPivot
Views: 605 Coconut SQL