Home
Search results “Oracle sql prior”
Learn Oracle SQL : The Hierarchical Query Clause
 
11:19
http://bit.ly/oracle-sql-course | Get the complete course today. Learn Oracle SQL : The Hierarchical Query Clause: In this video, I show you how to use the Hierarchical Query Clause in Oracle SQL to build a basic hierarchical query. This is an excerpt of the course "The Ultimate Oracle SQL Course" which you can get at a heavily discounted price here: http://bit.ly/oracle-sql-course ================ You can find additional Oracle SQL related articles and educational content in my blog here: http://standout-dev.com/
Views: 8666 Oracle SQL
Hierarchical Queries in Oracle/ عربي
 
16:39
start with & connect by prior Hierarchical Queries in Oracle ملاحظه : اشارة الاكبر غير مسموحة في الوصف --1--- select employee_id, first_name,last_name,manager_id from employees; --2--- select employee_id, first_name,last_name,manager_id from employees where manager_id=100; --3--- select employee_id, first_name,last_name,manager_id from employees where manager_id=101; --4--- select employee_id, first_name,last_name,manager_id from employees where manager_id=108; --5--- select employee_id, first_name,last_name,manager_id from employees where manager_id in (109,110,111,112,113) --6--- select employee_id, first_name,last_name,manager_id from employees start with employee_id=100 connect by prior employee_id=manager_id --top down --7--- select employee_id, first_name,last_name,manager_id from employees start with employee_id=113 connect by prior manager_id =employee_id --buttom up --8--- --let us take this and try to do nice thing --Neena Kochhar work for Steven King select employee_id, first_name,last_name,manager_id from employees start with employee_id=100 connect by prior employee_id=manager_id --top down --9--- select first_name||' '||last_name ||' work for '|| (select first_name||' '||last_name from employees e where e.employee_id=a.manager_id ) from employees a start with employee_id=100 connect by prior employee_id=manager_id --top down --10--- select first_name||' '||last_name ||' work for '|| prior first_name||' '||prior last_name from employees start with employee_id=100 connect by prior employee_id=manager_id --top down --11--- select level,employee_id, first_name,last_name,manager_id from employees start with employee_id=100 connect by prior employee_id=manager_id --top down --1 mean root --2 mean child of root --3 mean child of child , and so on --12--- select level,employee_id, first_name,last_name,manager_id from employees where level=2 start with employee_id=100 connect by prior employee_id=manager_id --13--- select lpad ('khaled',10, 0) from dual --14--- select level, case when level=1 then first_name||' '||last_name when level Greater sign 1 then lpad (first_name||' '||last_name,length(first_name||' '||last_name)+level-1, '-') end tree from employees start with employee_id=100 connect by prior employee_id=manager_id --top down ---------------------- --15--- select employee_id, first_name,last_name,manager_id from employees start with employee_id=100 connect by prior employee_id=manager_id --top down --16--- select employee_id, first_name,last_name,manager_id from employees start with employee_id=100 connect by manager_id= prior employee_id --top down
Views: 2754 khaled alkhudari
Hierarchical Queries (Oracle)
 
03:33
Hierarchical Queries in Oracle, Using CONNECT BY PRIOR and START WITH clause. Visual Example using a practical scenario.
Views: 5659 CodeSmith 001
006 Connect By clause
 
05:09
Views: 5507 Kartik Mundhra
PL/SQL tutorial 63: PL/SQL Collection Method Prior & Next in Oracle Database
 
06:37
RebellionRider.com presents PL/SQL tutorial on Collection Method Prior and Next in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/prior-next The Blog is Online now. But you can still check out these Interview Q & A on Collection Method LIMIT http://bit.ly/limit-function Previous Tutorial ► How To Create Nested Table https://youtu.be/EUYyiFCzU0I ►Associative Array https://youtu.be/wGXeD_oWxUk ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 5274 Manish Sharma
Hierarchical Queries in Oracle (CONNECT BY)
 
03:05
This video demonstrates one of the ways to query hierarchical data from Oracle. For more information see: https://oracle-base.com/articles/misc/hierarchical-queries Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Arjen Visser Blog: http://blog.dbvisit.com/ Twitter: https://twitter.com/dbvisit Website: http://www.dbvisit.com/ Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 28033 ORACLE-BASE.com
Oracle LAG & LEAD Functions / Arabic
 
11:23
--The LAG function is used to access data from a previous row --LAG (value_expression [,offset] [,default]) OVER ([query_partition_clause] order_by_clause) --value_expression - Can be a column or a built-in function, except for other analytic functions. --offset - The number of rows preceeding/following the current row, from which the data is to be retrieved. The default value is 1. --default - The value returned if the offset is outside the scope of the window. The default value is NULL. -- The LEAD function is used to return data from the next row. --LEAD (value_expression [,offset] [,default]) OVER ([query_partition_clause] order_by_clause)
Views: 735 khaled alkhudari
Hierarchical Queries: Databases for Developers #16
 
09:38
Often data contains a parent-child relationship between rows in the same table. For example, company org charts and family trees. You can use the power of SQL to traverse these hierarchical relationships. There are two ways to do this in Oracle Database: - Connect By - Recursive With Watch this video to learn about data trees and find out how these work! Further reading: Hierarchical queries in the docs: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Hierarchical-Queries.html#GUID-0118DF1D-B9A9-41EB-8556-C6E7D6A5A84E Recursive subquery factoring in 11.2: https://oracle-base.com/articles/11g/recursive-subquery-factoring-11gr2 Take the course! https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-next-level.html 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: 4114 The Magic of SQL
Oracle  Easy Download and installation Express Edition 11g
 
04:58
Oracle Database XE Prior Release Archive Oracle Database Express Edition (XE) Release 11.2.0.2.0 (11gR2).
Views: 75 IT channEL
Tutorial 65 : PL SQL Collection Method || PRIOR() || NEXT()
 
05:07
HI Friends, Here we are learning about Pl Sql Collection method, PRIOR() and NEXT(). Hope the concept and examples would be clear to you. For any confusion or doubt, let me know in comment box. Link (PL SQL Collection Methods Introduction) : https://youtu.be/4EfkhwfP8wM Link (PL SQL Collection Method || COUNT() : https://youtu.be/4Y5E_MTrqjI Link (PL SQL Collection Method || EXISTS() : https://youtu.be/OVCy0BrV9f4 Link (PL SQL Collection Method || FIRST() and LAST()) : https://youtu.be/t52MSPP8D9M Link (PL SQL Collection Method || LIMIT()) : https://youtu.be/dtMN_tP9FrE Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha
Views: 49 YourSmartCode
sas proc sql database
 
12:31
for SAS online tutorials contact email: [email protected] SAS ACCESS to oracle database Pre-requisite: prior knowledge of sas , libname , database
Views: 11005 Touche Bin
Using Oracle to read data from SQL Server
 
10:47
Hi everyone, Andy from Easysoft Limited here, what I want to show you today is how to get data from SQL Server into Oracle. Now for this we will be accessing SQL Server 2014 from Oracle 12 and getting data across. This could be quite easily be any SQL Server version from 2008 and any Oracle version from 11.2, the configuration and process is the same. We can obviously get access to data on SQL Server prior to 2008 and Oracle prior to version 11.2 but it will need a different configuration to what I am going to show you today The plan is also to add more data to the SQL Server table and show this new data back in Oracle. To start off you'll need access to ensure that you have access to your SQL Server and Oracle databases. You'll also need the Easysoft SQL Server ODBC Driver available from www.easysoft.com; just download it, install it and request the free 14 day trial licence. Before we start we need to make some changes to the standard Easysoft config files. cat /etc/odbc.ini Here I have changed Mars Connection to Yes. It must be set to "Yes" if you are connecting to SQL Server 2005 or newer. Easysoft supports all SQL data types from the version of SQL Server from version 7. Oracle supports data types that are common to most ODBC Drivers, but not some of the SQL Server ones. If you intend to access VARCHAR(MAX) for example, then there are some additional settings that need to be set up. Now as I would like to show you VARCHAR(MAX) data moving from SQL Server to Oracle, I have made the relevant change. As you can see, VarMaxAsLong says "Yes" We now need to create a link from Oracles Database Gateway (DG4ODBC) to the ODBC datasource that we already have, this is done in an init(sid) oracle file; let's have a look at our file. cat $ORACLE_HOME/hs/admin/initsqlsrv.ora Please note that HS_NLS_NCHAR must be set to UCS2 Oracle assume that most database vendors use UTF-8 for wide characters, however Easysoft, like almost all ODBC Driver vendors (including Oracles own ODBC Driver) uses UCS2 for wide characters. So that's the link between DG4ODBC and the datasource setup correctly. Next we need to set up the Listener entry The Oracle Listener waits for incoming requests from the Oracle database. For the Oracle Listener to listen for requests, information about DG4ODBC must be added to the Oracle Listener configuration file, listener.ora cat $ORACLE_HOME/network/admin/listener.ora The PROGRAM=dg4odbc tells the Listener that we are wanting to use the Oracle database gateway to communicate with ODBC. The ENVS=LD_LIBRARY_PATH tells Oracle what library to load Now that's all set up and OK we need to tell Oracle which server to attach the listener entry to. This is done in tnsnames.ora, and he is the file that we ensured was set up earlier. cat $ORACLE_HOME/network/admin/tnsnames.ora The Oracle Listener now needs to be restarted. lsnrctl stop lsnrctl start OK, that's now started the Listener up again. So we have ensured that all the configuration files are set up correctly. The Listener and tnsnames.ora both set up OK. The final step is to create a link from the Oracle database to the "tnsnames.ora" entry. CREATE PUBLIC DATABASE LINK ODBC CONNECT TO "test" IDENTIFIED BY "test" USING 'sqlsrv_ptr'; Right, that's all done. Let's access the data in SQL Server now. select * from [email protected]; Where 'demo' is the name of the SQL Server table and 'odbc' is the public database link name. OK, there we have the data. So to recap, I'm in Oracle and we have managed to read the data from SQL Server. Let's just add an additional row in that SQL Server table and retrieve the new data in Oracle. quit; /usr/local/easysoft/unixODBC/bin/isql.sh -v sqlsrv insert into demo values (2,'Easysoft') select * from demo select * from [email protected]; And there is the new data. Easysoft Limited can help you with your data access ... for our full range of ODBC and JDBC Drivers, Bridges and Gateways visit easysoft.com Be sure to let us know if you have any comments or questions. Until next time, thanks again and we'll see you again soon.
Views: 16727 Easysoft Limited
PL/SQL tutorial 62: PL/SQL Collection Method LIMIT in Oracle Database
 
07:38
In this PL/SQL tutorial we will explore the concepts of collection method LIMIT and learn: - What is collection method Limit - How to use this collection method - What are the differences between collection method LIMIT & Collection Method COUNT - What happens when function LIMIT is used with Nested table and Associative array Go ahead and enjoy. Also do not forget to LIKE, SHARE & Subscribe. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/limit-function Previous Tutorial ► Associative Array: https://youtu.be/wGXeD_oWxUk ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 6202 Manish Sharma
15 Hierarchical Queries
 
03:41
Views: 6674 Husnah Hasan
PL/SQL tutorial 64: PL/SQL Collection Method Delete in Oracle Database by Manish Sharma
 
08:31
------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/delete-procedure Previous Tutorial ► Collection method Next & Prior https://youtu.be/5Ya35KboF1A ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 5716 Manish Sharma
Oracle Core, Лекция 8-1
 
01:03:12
Ссылка на файл с презентацией: https://docs.google.com/presentation/d/196mOgO6TGT9CUK2RlOtNoGuS2y-bxG9A6pp8Jc9nasU/edit?usp=sharing (презентация может быть с анимацией) Ссылка на краткий конспект лекции: https://docs.google.com/document/d/1X8dIjwjUrmELNOHXgRo7_SmGio7h8eb9jDZmM1dvbKA/edit?usp=sharing 1. Типы коллекций в Oracle 2. Ассоциативный массив (index by table, pl/sql table) 3. Varray (varying array) 4. Вложенная таблица (nested table, table of) 5. Set operations (multiset union, multiset union distinct, multiset intersect, multiset intersect distinct, set, multiset except, multiset except distinct) 6. Логические операции с коллекциями в Oracle (in, submultiset of, member of, is a set, is empty) 7. Методы коллекций 8. Метод Delete (три перегруженных метода) 9. Метод Trim (два перегруженных метода) 10. Метод Extend (три перегруженных метода) 11. Метод Exists 12. Методы First и Last 13. Метод Count 14. Метод Limit 15. Методы Prior и Next 16. Операция Bulk Collect (select bulk collect into, fetch bulk collect into, returning bulk collect into) 17. Цикл forall (forall indices of, forall values of, sql%bulk_collect, sql%rowcount) 18. Обработка exceptions в цикле forall (save exceptions, ora-24381, sql%bulk_exceptions) 19. Возможные exceptions при работе с коллекциями (collection_is_null, no_data_found, subscript_beyond_count, subscript_outside_limit, value_error) 20. Метод dbms_session.free_unused_user_memory Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle
Machine Learning with Oracle
 
35:47
Introduction - 0:00 Overview Machine Learning in Oracle - 1:31 Machine Learning theory - 6:04 Demonstration: preparation and building the model - 11:52 Demonstration: run the prediction and adapt the application - 26:24 How to get started - 33:33 Without a doubt Machine Learning / Artificial Intelligence is an incredibly powerful technology with a huge potential. It brings benefits across many industries and business functions: From better targeting in the marketing/sales domain to predictive maintenance in manufacturing. This video-webinar is a kickstart to Machine Learning. You will learn the required theoretical knowledge and then we'll go through a real-life example: intelligent sales with ML. We'll create our very first ML model, and use it to make an existing application intelligent with sales recommendations. After this webinar you will have the basic ingredients to apply ML to your own business cases! Note that you don't require any previous knowledge of ML to be able to understand this session. Powerpoint and background material can be found here: https://ptdrv.linkedin.com/cmaj4xt
Oracle Architecture in less than 10 minutes
 
09:46
CAPTIONS AVAILABLE - I assume that it's the "I like!" votes that keep this video at or near the top when you search on "oracle". Thank you to all. S. Faroult View on www.konagora.com where Youtube is blocked. Full transcript (with some screenshots) available for a small fee at http://stores.lulu.com/konagora/. A pretty reckless description of what happens when you start Oracle and when you execute a statement. If you're a developer, it could influence how you code. If you're a junior DBA, or would be junior DBA, I hope it will help you make sense of some parts of the "Concepts" manual.
Views: 532367 roughsealtd
Prior Day Profit using the Lag Function - SQL Training Online
 
03:13
You can get a prior day value using the Lag Function in SQL Server. In this video I show you how to create a prior day squeeze of profit using the Windowing Lag function in TSQL. READ THE ORIGINAL ARTICLE WITH SQL SCRIPTS HERE http://www.sqltrainingonline.com/prior-day-profit-lag-function-windowing-in-sql-server/ YOUTUBE NEWS UPDATES http://www.youtube.com/user/sqltrainingonline VISIT SQLTRAININGONLINE.COM FOR TONS MORE VIDEO NEWS & TIPS http://www.sqltrainingonline.com SUBSCRIBE FOR OTHER SQL TIPS AND NEWS! http://www.youtube.com/subscription_center?add_user=sqltrainingonline SUBSCRIBE TO OUR EMAIL LIST! http://www.sqltrainingonline.com LET'S CONNECT! Google+: http://gplus.to/SQLTrainingOnline Facebook: http://facebook.com/SQLTrainingOnline Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com
Views: 1200 Joey Blue
Essbase @PRIOR and @PRIORS Functions
 
06:00
interRel presents Look Smarter Than You Are With Oracle Essbase Calc Scripts: @PRIOR and @PRIORS. Robert Gideon
Views: 731 interRel Consulting
PL/SQL tutorial 57: PL/SQL Collection Associative Array in Oracle Database
 
08:05
Manish Sharma from RebellionRider presents you the latest PL/SQL tutorial on Collection ASSOCIATIVE ARRAY. In this video, you will learn – - What are Associative Arrays? - How to create Associative Arrays? - How to Insert & Update the data of Associative Array and - How to retrieve the data from an Associative array using two different ways? So if you are wondering whether associative array is a persistent form of collection or not; Is it bounded or unbounded in nature; why should we use this specific collection over others such as VARRAY or Nested Table; What are the differences or similarities between associative array and other collections? Then go ahead and watch the video to find out the answers to all these questions. Hope you will enjoy watching. Do make sure to Like and Share this post/video because that will help others in learning as well as help me and my channel in reaching out. This way we can educate more and more people for FREE. Most importantly SUBSCRIBE to the channel as many such interesting tutorials are coming your way. Thanks. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/associative-array Previous Tutorial ►While Loop: https://youtu.be/IIlc4Sr7kFE ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 13814 Manish Sharma
PL/SQL tutorial 61: Collection Method FIRST & LAST in Oracle Database
 
06:21
------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/col-method-3 Previous Tutorial ► Intro of Collection Method: https://youtu.be/8V40IaOkGcU ► Collection Method COUNT: https://youtu.be/NNq80CcC5K8 ► Collection Method EXIST: https://youtu.be/ksfwNxZl4gI ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 6532 Manish Sharma
PL/SQL tutorial 65: PL/SQL Collection Method EXTEND in Oracle Database
 
08:49
RebellionRider presents the PL/SQL Collection Method Extend in Oracle Database with Example by Manish Sharma. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/col-method-extend ► PL/SQL Collection Method EXTEND https://youtu.be/QLP9xq5l_oA ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 5616 Manish Sharma
Table valued parameters in SQL Server
 
06:46
table valued parameters example send table variable to stored procedure pass table variable as parameter to stored procedure pass table variable to sql stored procedure In this video we will discuss table valued parameters in SQL Server. Table Valued Parameter is a new feature introduced in SQL SERVER 2008. Table Valued Parameter allows a table (i.e multiple rows of data) to be passed as a parameter to a stored procedure from T-SQL code or from an application. Prior to SQL SERVER 2008, it is not possible to pass a table variable as a parameter to a stored procedure. Let us understand how to pass multiple rows to a stored procedure using Table Valued Parameter with an example. We want to insert multiple rows into the following Employees table. SQL Script to create the Employees table Create Table Employees ( Id int primary key, Name nvarchar(50), Gender nvarchar(10) ) Go Step 1 : Create User-defined Table Type CREATE TYPE EmpTableType AS TABLE ( Id INT PRIMARY KEY, Name NVARCHAR(50), Gender NVARCHAR(10) ) Go Step 2 : Use the User-defined Table Type as a parameter in the stored procedure. Table valued parameters must be passed as read-only to stored procedures, functions etc. This means you cannot perform DML operations like INSERT, UPDATE or DELETE on a table-valued parameter in the body of a function, stored procedure etc. CREATE PROCEDURE spInsertEmployees @EmpTableType EmpTableType READONLY AS BEGIN INSERT INTO Employees SELECT * FROM @EmpTableType END Step 3 : Declare a table variable, insert the data and then pass the table variable as a parameter to the stored procedure. DECLARE @EmployeeTableType EmpTableType INSERT INTO @EmployeeTableType VALUES (1, 'Mark', 'Male') INSERT INTO @EmployeeTableType VALUES (2, 'Mary', 'Female') INSERT INTO @EmployeeTableType VALUES (3, 'John', 'Male') INSERT INTO @EmployeeTableType VALUES (4, 'Sara', 'Female') INSERT INTO @EmployeeTableType VALUES (5, 'Rob', 'Male') EXECUTE spInsertEmployees @EmployeeTableType That's it. Now select the data from Employees table and notice that all the rows of the table variable are inserted into the Employees table. In our next video, we will discuss how to pass table as a parameter to the stored procedure from an ADO.NET application Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/table-valued-parameters-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/table-valued-parameters-in-sql-server_17.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 66657 kudvenkat
Recursive Subquery Factoring : Hierarchical Queries Using Recursive WITH Clauses
 
04:05
This video demonstrates one of the ways to query hierarchical data from Oracle. For more information see: https://oracle-base.com/articles/11g/recursive-subquery-factoring-11gr2 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Jeff Smith Blog: http://www.thatjeffsmith.com Twitter: https://twitter.com/thatjeffsmith Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 11337 ORACLE-BASE.com
From DBA to Data Scientist - Mike West
 
01:07:10
The world’s fastest growing job is that of the data scientist. Many believe the career is out of reach without a PhD. While many job requirements list a PhD as preferred it’s not a necessity. The good news for database professionals is that we can leverage our skills and experience to enter the machine learning space without the advanced education requirements. There’s a learning curve but it doesn’t require a master’s or PhD. In the real-world companies need data scientists who specialize in applied machine learning. Machine learning is a type of artificial intelligence that provides computers with the ability to learn without being explicitly programmed. Applied machine learning is using existing algorithms to build predictive models at the expense of understanding how the under lying algorithms are written. In this session I’m going to discuss the move from the DBA role to that of the Machine Learning Engineer. We will learn about applied machine learning. In addition to discussing machine learning we will build a predictive model in Python and Azure Machine Learning Studio. We are about to witness an explosion in applied machine learning and I’m going to show what you’ll need to do to get started. Mike West brings over 23 years of IT experience, including expertise in network administration and SQL Server. Prior to becoming a database consultant, Mike worked as a senior level SQL resource for Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman. Mike’s technical expertise for the last 20 years has centered on databases. For the last 18 years Mike’s sole focus has been on SQL Server. Mike is a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) Born in Ohio, raised and educated in Pennsylvania, he currently resides in Atlanta.
Views: 2528 DBAFundamentals
SQL timeout expired. The timeout period elapsed prior to completion of the operation
 
00:47
Description https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtimeout.aspx c # Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Have you set the CommandTimeout ? . If not set the CommmandTimeout (in seconds) check. Most of the times it should work. The below URL gives you more information about CommandTimeout. https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtimeout.aspx This property is the cumulative time-out (for all network packets that are read during the invocation of a method) for all network reads during command execution or processing of the results. A time-out can still occur after the first row is returned, and does not include user processing time, only network read time. For example, with a 30 second time out, if Read requires two network packets, then it has 30 seconds to read both network packets. If you call Read again, it will have another 30 seconds to read any data that it requires.
Views: 7982 Rohan Mehtha
PL/SQL tutorial 60: Collection Method EXISTS in Oracle Database by Manish Sharma
 
05:21
RebellionRider presents you the latest PL/SQL Tutorial 60 on Collection method EXISTS by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/exists-function Previous Tutorial ► ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 7760 Manish Sharma
List partitioning in Oracle : Part 3
 
23:37
This video explains list partitioning in detail with 2 real project examples. I recommend watching these 2 videos on partitioning prior to watching the current one. 1. https://www.youtube.com/watch?v=m3q4lrE671Y&t=25s 2. https://www.youtube.com/watch?v=OQ8LXbxLI5g&t=1312s
Views: 5944 Tech Coach
PL/SQL tutorial 36: Cursor Based Record Datatype variables part 2 By Manish Sharma
 
04:58
www.RebellionRider.com present PL/SQL tutorial 36 on How To Handle Multiple values using Cursor Based Record Datatype Variables in Oracle Database By Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/cursor-record-2 Previous Tutorial ► Cursor Records Part 1 https://youtu.be/mVNa3QomRDM ► Cursor For Loop https://youtu.be/abgVNjPaMVA ► ------------------------------------------------------------------------- ►►►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/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ 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: 18927 Manish Sharma
What is LAG Function in Oracle
 
03:26
What is LAG Function in Oracle How to Get Previous Record in SQL How to Get Previous Salary in 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: 383 TechLake
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: 421 Themis Education
Oracle Performance Tuning - Lead and Lag
 
04:19
A brief overview about Lead and Lag analytic function in Oracle
Views: 1392 Saurabh Kumar
PL/SQL tutorial 3: SELECT INTO statement in PL/SQL by Manish Sharma RebellionRider
 
05:22
How to initialize the variable by fetching values from the table of the database or by using SELECT INTO statement in PL/SQL by Manish Sharma RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/select-into-statement-pl-sql Previous Tutorial ► Variables: https://youtu.be/2MNmodawvnE ------------------------------------------------------------------------- ►►►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: 127721 Manish Sharma
PL/SQL tutorial 33: Table Based Record Datatype In Oracle Database by Manish Sharma
 
06:48
Learn how to create a table based record type variable in Oracle Database By Manish Sharma from RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/table-based-records Previous Tutorial ► Introduction To Records: https://youtu.be/1iHbZDuDbis ► SELECT-INTO Statement: https://youtu.be/Zt0vlmTqhP4 ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ 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: 33148 Manish Sharma
PL/SQL tutorial 9: IF THEN ELSE (IF-ELSE) Statement in PL/SQL by Manish Sharma
 
04:12
3rd tutorial in the series explaining IF-THEN-ELSE statement in Oracle PL/SQL with Example. Enjoy ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/if-then-else Previous Tutorial ► IF THEN Statement https://youtu.be/IWvuFD6eD30 ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 65164 Manish Sharma
Oracle Core,  Лекция 3-2
 
01:34:13
Ссылка на файл с презентацией: https://docs.google.com/presentation/d/1PzGVjjsR2lSlr5EXFzmbIpVN4RMGBkjwU_De6FQyxVI/edit?usp=sharing (презентация может быть с анимацией) Ссылка на краткий конспект лекции: https://docs.google.com/document/d/1x7-BCc_2Z83vSGjcFZiWGGdtVoRm1AJLRnxp-lXtchU/edit?usp=sharing 1. Таблица DUAL 2. Конструкция WITH. Рекурсивные запросы с конструкцией WITH 3. Иерархические запросы (self joins): START WITH, CONNECT BY, PRIOR, NOCYCLE, ORDER SIBLINGS BY, LEVEL, CONNECT_BY_ISCYCLE, CONNECT_BY_ISLEAF, SYS_CONNECT_BY_PATH, CONNECT_BY_ROOT 4. Псевдостолбцы (pseudocomlumns). 4.1 ORA_ROWSCN (SCN_TO_TIMESTAMP, TIMESTAMP_TO_SCN) 4.2 ROWID (DBMS_ROWID) 4.3 ROWNUM 5. Конструкция SAMPLE 6. Конструкция PIVOT 7. Конструкция UNPIVOT 8. Оператор INSERT INTO SINGLE TABLE 9. Оператор INSERT INTO MULTITABLE: INSERT ALL, INSERT FIRST 10. Оператор UPDATE 11. Оператор DELETE 12. Оператор MERGE 13. Обновляемая VIEW (KEY-PRESERVED TABLE) 14. SQL FUNCTIONS: SYSDATE, EXTRACT, ADD_MONTH, MONTH_BETWEEN, UPPER/LOWER, LENGTH, SUBSTR, INSTR, REPLACE, LTRIM/RTRIM/TRIM, LPAD/RPAD, TO_CHAR, TO_NUMBER, TO_DATE, POWER, ABS, ROUND, CEIL/FLOOR, USER, TRUNC, GREATEST/LEAST Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle
SQL Tutorial for beginners What is LEAD Function in Oracle
 
04:02
What is LEAD Function in 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: 248 TechLake
Solved! - Unable to modify table.   Execution Timeout Expired
 
00:36
'B_DEVICE_ALL_SATS (dv)' table - Unable to modify table. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Views: 3275 Maruti AIR Tech
Introduction to Oracle Database 11g Certified Associate | OCA Certification Training
 
01:12
Learn more about OCA Certification here: http://www.simplilearn.com/os-and-databases/introduction-to-oracle-11g-training-tutorial?utm_source=youtube&utm_medium=organic&utm_campaign=Oca_intro The Oracle Database 11g Certified Associate (OCA) course ensures and imparts participants with a strong foundation and advance skills in the industry’s most coveted database management system, Oracle 11g. Who should do this course? The course is ideal for professionals who are seeking a career in database development. Candidates looking to step into the IT industry with no prior knowledge of SQL can be greatly benefited. Lead engineers, Technical architects, Database analysts and entry-level developers at would also be ideal participants for the training. Learn more on this training here: http://www.simplilearn.com/os-and-databases/introduction-to-oracle-11g-training-tutorial?utm_source=youtube&utm_medium=organic&utm_campaign=Oca_intro For more updates on courses and tips follow us on: - Facebook : https://www.facebook.com/Simplilearn - Twitter: https://twitter.com/simplilearn Get the android app: http://bit.ly/1WlVo4u Get the iOS app: http://apple.co/1HIO5J0
Views: 726 Simplilearn
OBIEE 11g Reports and Dashboards: Build Another Analysis Using Formatting and Column Properties
 
10:32
Build Another Analysis Using Formatting and Column Properties is an excerpt from OBIEE (Oracle Business Intelligence Enterprise Edition) 11g Reports and Dashboards Video Training: http://www.informit.com/store/obiee-oracle-business-intelligence-enterprise-edition-9780134289304?WT.mc_id=Social_YT 6+ Hours of Video Instruction -- OBIEE 11g (Oracle Business Intelligence Enterprise Edition) Reports and Dashboards LiveLessons introduces students to the querying and analytical capabilities of Oracle Analytics using the web interface. This course is primarily for business analysts or programmers utilizing OBIEE for analysis. Students will leave the course being able to produce reports and retrieve information from the Oracle RDBMS using the OBIEE web interface. Description In this LiveLessons video course, Oracle ACE Director Dan Hotka covers how to create, modify, run, and refine ad hoc queries. Students will learn to view, chart, and analyze multidimensional data. They will also learn to produce individual ad hoc reports and make these reports and information easy to access (dashboards). The final lesson focuses on using BI Publisher to transform these reports into polished/formatted/quality reports in about any language or format required. About the Instructor Dan Hotka is a training specialist and an Oracle ACE director who has more than 37 years in the computer industry and more than 31 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 12 Oracle books and more than 200 published articles. He is also the video author of several LiveLessons including Oracle SQL, Oracle SQL Performance Tuning for Developers LiveLessons and Oracle PL/SQL Programming: Fundamentals to Advanced LiveLessons. He is frequently published in Oracle trade journals, blogs regularly, and speaks at Oracle conferences and user groups around the world. Visit his website at www.DanHotka.com. Skill Level Beginner Learn How To Use the OBIEE interface Retrieve data in a variety of formats Use report formatting Build dashboards and pass parameters Work with the publishing tool that is included in the base product Understand a variety of tips and techniques for distributing, saving, downloading various reports and data Who Should Take This Course Business analysts Programmers Course Requirements No prior knowledge of OBIEE is required A working knowledge of BI tools would be helpful New Player Enables Streaming and Download Access Now you can stream and download videos for unlimited 24/7 online/offline access and ownership. Streaming—Watch instantly as the video streams online in real time; after purchase, simply click Watch Now to get started. Download—Download video files for offline viewing anytime, anywhere; after purchase, simply click the Download icon within the player and follow the prompts. Plus, enjoy new player features that track your progress and help you navigate between modules. http://www.informit.com/store/obiee-oracle-business-intelligence-enterprise-edition-9780134289304?WT.mc_id=Social_YT
Views: 4178 LiveLessons
Downloading and Installing Oracle Database Express Edition (XE) Release 11.2.0.2.0 (11gR2)
 
06:49
Downloading and Installing Oracle Database Express Edition (XE) Release 11.2.0.2.0 (11gR2). Intended for new users and students. Download page: https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/xe-prior-releases-5172097.html
Views: 89 Savvy Mentors
AskTOM Office Hours: How To Model and Construct Graphs
 
51:42
Held on April 24 2018 To use property graphs, first, you’ll need a graph model. For a new user, modeling and generating a suitable graph for an application domain can be a challenge. In April’s session, Albert described key steps required to model a graph, using an HR example. Then Zhe showed how to construct a meaningful graph using ODI, Java/SQL APIs, or various utilities supporting various data sources (Database or other file formats). NOTE: If you missed February’s session, please watch the recording prior to this session: https://asktom.oracle.com/pls/apex/f?p=100:551:::NO:551:P551_CLASS_ID:3401&cs=11ED98BAEBB81DD95ADED292AE0744349 Highlights: 00:00 - Speaker intros 01:40 - Graph Architecture Overview 04:52 - Designing Graphs: what is a graph model, comparison with relational, considerations on moving from a relational to a graph model, some graph modeling examples (HR and customer orders) 24:56 - Constructing Graphs – overview of available options 26:34 - Constructing Graphs using Oracle Data Integrator (demo starts at 29:55) 39:50 - Using DAL APIs to programmatically create a graph 41:00 - Read from a data source and use DAL APIs to programmatically create a graph 42:20 - Generate a Property Graph (.opv/.ope) directly from relational tables (views) 44:10 - Generate a Property Graph (.opv/.ope) directly from CSV Files 44:50 - Construct a property graph with SQL 47:05 - Resources and wrapup 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. https://asktom.oracle.com/ https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit music: bensound.com
Views: 325 Oracle Developers
In Their Own Words: Erik van Roon, 2015 Devvy Winner, SQL
 
22:14
Erik van Roon is a Senior Oracle Developer who has worked with Oracle technology since 1995. Since 2009 he is self-employed. His company is called EvROCS. Prior to that he has worked for several consulting companies in the Netherlands. He has worked on major projects for several clients in industries like entertainment, banking and energy, working with the 'classic' Oracle tools Designer, Forms, Reports, as well as SQL and PLSQL. Erik has been the technical lead of multiple successful data migration projects, moving and transforming large amounts of data. Erik originally worked in laboratories as an analyst in the fields of microbiology and biochemistry, but retrained as an Oracle developer in 1995, due to a car accident which made it impossible to continue his earlier career. Erik didn't like the car accident, but is very happy with the change in career. To overcome the lack of a computer science background, Erik worked hard to deepen his knowledge, through conferences, training and most importantly learning from others with more experience. That approach helped him a lot, so now he likes to try to help people as much as possible, and has focused on LinkedIn, as can be seen from these conversations: https://www.linkedin.com/grp/post/2258953-5900473875363278852 https://www.linkedin.com/grp/post/2258953-5839349602733535234 https://www.linkedin.com/grp/post/2258953-5959522322791546882 https://www.linkedin.com/grp/post/2258953-5997338524087500803 https://www.linkedin.com/grp/post/74566-5966916308854411268 https://www.linkedin.com/grp/post/146455-5961160933978972160 https://www.linkedin.com/grp/post/2258953-5798045377563217922 https://www.linkedin.com/grp/post/74566-5936632993715077120 Check out all winners: https://community.oracle.com/community/database/awards ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2016 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.
Analytics: 17 The LAG / LEAD clauses
 
05:59
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. In this session, we look at the lag and lead functions. The sample problem we'll solve is: Collapsing repeated rows in an order history table to show only the days where the order changed status Scripts: https://livesql.oracle.com/apex/livesql/file/content_CZUCT0MCOQZMJM7TI553HC8S9.html
Views: 455 Connor McDonald