際際滷shows by User: KimBergHansen / http://www.slideshare.net/images/logo.gif 際際滷shows by User: KimBergHansen / Fri, 21 Sep 2018 07:23:08 GMT 際際滷Share feed for 際際滷shows by User: KimBergHansen External Tables - not just loading a csv file /slideshow/external-tables-not-just-loading-a-csv-file/115728761 kbhexternaltables-notjustloadingacsvfile-180921072308
Giving an overview of many of the details of the external table syntax in Oracle that enables you from SQL to access files that reside outside the database]]>
Giving an overview of many of the details of the external table syntax in Oracle that enables you from SQL to access files that reside outside the database]]> Fri, 21 Sep 2018 07:23:08 GMT /slideshow/external-tables-not-just-loading-a-csv-file/115728761 KimBergHansen@slideshare.net(KimBergHansen) External Tables - not just loading a csv file KimBergHansen Giving an overview of many of the details of the external table syntax in Oracle that enables you from SQL to access files that reside outside the database <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/kbhexternaltables-notjustloadingacsvfile-180921072308-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Giving an overview of many of the details of the external table syntax in Oracle that enables you from SQL to access files that reside outside the database
External Tables - not just loading a csv file from Kim Berg Hansen
]]> 1148 1 https://cdn.slidesharecdn.com/ss_thumbnails/kbhexternaltables-notjustloadingacsvfile-180921072308-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 When 7 bit-ascii ain't enough - about NLS, collation, charsets, unicode and such (v2) /slideshow/when-7-bitascii-aint-enough-about-nls-collation-charsets-unicode-and-such-v2/113741411 when7-bitasciiaintenough-aboutnlscollationcharsetsunicodeandsuch-180910091152
Revised version of the presentation - as presented at #POUG2018. About problems that can occur if NLS_LANG is not set correctly, which may lead to corrupt data. About different NLS settings and related topics, collation, and the use of DMU to migrate to UTF or check for corrupt text.]]>
Revised version of the presentation - as presented at #POUG2018. About problems that can occur if NLS_LANG is not set correctly, which may lead to corrupt data. About different NLS settings and related topics, collation, and the use of DMU to migrate to UTF or check for corrupt text.]]> Mon, 10 Sep 2018 09:11:52 GMT /slideshow/when-7-bitascii-aint-enough-about-nls-collation-charsets-unicode-and-such-v2/113741411 KimBergHansen@slideshare.net(KimBergHansen) When 7 bit-ascii ain't enough - about NLS, collation, charsets, unicode and such (v2) KimBergHansen Revised version of the presentation - as presented at #POUG2018. About problems that can occur if NLS_LANG is not set correctly, which may lead to corrupt data. About different NLS settings and related topics, collation, and the use of DMU to migrate to UTF or check for corrupt text. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/when7-bitasciiaintenough-aboutnlscollationcharsetsunicodeandsuch-180910091152-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Revised version of the presentation - as presented at #POUG2018. About problems that can occur if NLS_LANG is not set correctly, which may lead to corrupt data. About different NLS settings and related topics, collation, and the use of DMU to migrate to UTF or check for corrupt text.
When 7 bit-ascii ain't enough - about NLS, collation, charsets, unicode and such (v2) from Kim Berg Hansen
]]> 496 0 https://cdn.slidesharecdn.com/ss_thumbnails/when7-bitasciiaintenough-aboutnlscollationcharsetsunicodeandsuch-180910091152-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 When 7-bit ASCII ain't enough - about NLS, Collation, Charsets, Unicode and such /slideshow/when-7bit-ascii-aint-enough-about-nls-collation-charsets-unicode-and-such/93417368 when7-bitasciiaintenough-aboutnlscollationcharsetsunicodeandsuch-180410073017
Working with charactersets in Oracle Database]]>
Working with charactersets in Oracle Database]]> Tue, 10 Apr 2018 07:30:17 GMT /slideshow/when-7bit-ascii-aint-enough-about-nls-collation-charsets-unicode-and-such/93417368 KimBergHansen@slideshare.net(KimBergHansen) When 7-bit ASCII ain't enough - about NLS, Collation, Charsets, Unicode and such KimBergHansen Working with charactersets in Oracle Database <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/when7-bitasciiaintenough-aboutnlscollationcharsetsunicodeandsuch-180410073017-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Working with charactersets in Oracle Database
When 7-bit ASCII ain't enough - about NLS, Collation, Charsets, Unicode and such from Kim Berg Hansen
]]> 335 8 https://cdn.slidesharecdn.com/ss_thumbnails/when7-bitasciiaintenough-aboutnlscollationcharsetsunicodeandsuch-180410073017-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Analytic Views in Oracle 12.2 /slideshow/analytic-views-in-oracle-122-83636761/83636761 analyticviewsinoracle122-171208095959
Presentation on Analytic View syntax - a new feature in Oracle 12.2 that works like a "virtual" OLAP cube, so you can dimensionally query your relational data in real-time without copying to a datawarehouse.]]>
Presentation on Analytic View syntax - a new feature in Oracle 12.2 that works like a "virtual" OLAP cube, so you can dimensionally query your relational data in real-time without copying to a datawarehouse.]]> Fri, 08 Dec 2017 09:59:59 GMT /slideshow/analytic-views-in-oracle-122-83636761/83636761 KimBergHansen@slideshare.net(KimBergHansen) Analytic Views in Oracle 12.2 KimBergHansen Presentation on Analytic View syntax - a new feature in Oracle 12.2 that works like a "virtual" OLAP cube, so you can dimensionally query your relational data in real-time without copying to a datawarehouse. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/analyticviewsinoracle122-171208095959-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Presentation on Analytic View syntax - a new feature in Oracle 12.2 that works like a &quot;virtual&quot; OLAP cube, so you can dimensionally query your relational data in real-time without copying to a datawarehouse.
Analytic Views in Oracle 12.2 from Kim Berg Hansen
]]> 389 2 https://cdn.slidesharecdn.com/ss_thumbnails/analyticviewsinoracle122-171208095959-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Uses of row pattern matching /slideshow/uses-of-row-pattern-matching/60211682 usesofrowpatternmatching-160330083811
Various use cases for Oracle database version 12c MATCH_RECOGNIZE data pattern matching functionality, not only for classic pattern matching like finding W patterns in stock ticker data, but also used for more general purpose SQL as "declarative analytics." Presentation given at OUGN Spring Conference 2016.]]>
Various use cases for Oracle database version 12c MATCH_RECOGNIZE data pattern matching functionality, not only for classic pattern matching like finding W patterns in stock ticker data, but also used for more general purpose SQL as "declarative analytics." Presentation given at OUGN Spring Conference 2016.]]> Wed, 30 Mar 2016 08:38:11 GMT /slideshow/uses-of-row-pattern-matching/60211682 KimBergHansen@slideshare.net(KimBergHansen) Uses of row pattern matching KimBergHansen Various use cases for Oracle database version 12c MATCH_RECOGNIZE data pattern matching functionality, not only for classic pattern matching like finding W patterns in stock ticker data, but also used for more general purpose SQL as "declarative analytics." Presentation given at OUGN Spring Conference 2016. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/usesofrowpatternmatching-160330083811-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Various use cases for Oracle database version 12c MATCH_RECOGNIZE data pattern matching functionality, not only for classic pattern matching like finding W patterns in stock ticker data, but also used for more general purpose SQL as &quot;declarative analytics.&quot; Presentation given at OUGN Spring Conference 2016.
Uses of row pattern matching from Kim Berg Hansen
]]> 440 6 https://cdn.slidesharecdn.com/ss_thumbnails/usesofrowpatternmatching-160330083811-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Read, store and create xml and json /slideshow/read-store-and-create-xml-and-json/60211421 readstoreandcreatexmlandjson-160330083509
Using Oracle database and Oracle SQL to retrieve XML and JSON from for example webservices, store XML and JSON in the database, query XML and JSON with SELECT as relational data, create XML and JSON in various manners from relational data. Presentation given at OUGN Spring Conference 2016.]]>
Using Oracle database and Oracle SQL to retrieve XML and JSON from for example webservices, store XML and JSON in the database, query XML and JSON with SELECT as relational data, create XML and JSON in various manners from relational data. Presentation given at OUGN Spring Conference 2016.]]> Wed, 30 Mar 2016 08:35:09 GMT /slideshow/read-store-and-create-xml-and-json/60211421 KimBergHansen@slideshare.net(KimBergHansen) Read, store and create xml and json KimBergHansen Using Oracle database and Oracle SQL to retrieve XML and JSON from for example webservices, store XML and JSON in the database, query XML and JSON with SELECT as relational data, create XML and JSON in various manners from relational data. Presentation given at OUGN Spring Conference 2016. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/readstoreandcreatexmlandjson-160330083509-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Using Oracle database and Oracle SQL to retrieve XML and JSON from for example webservices, store XML and JSON in the database, query XML and JSON with SELECT as relational data, create XML and JSON in various manners from relational data. Presentation given at OUGN Spring Conference 2016.
Read, store and create xml and json from Kim Berg Hansen
]]> 834 6 https://cdn.slidesharecdn.com/ss_thumbnails/readstoreandcreatexmlandjson-160330083509-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Data twisting /slideshow/data-twisting/60210890 datatwisting-160330082313
Use of Oracle SQL to twist data around - unpivot columns to rows, pivot rows to columns, parse delimited strings to columns and rows, turn rows into delimited strings. Presentation given at OUGN Spring Conference 2016.]]>
Use of Oracle SQL to twist data around - unpivot columns to rows, pivot rows to columns, parse delimited strings to columns and rows, turn rows into delimited strings. Presentation given at OUGN Spring Conference 2016.]]> Wed, 30 Mar 2016 08:23:13 GMT /slideshow/data-twisting/60210890 KimBergHansen@slideshare.net(KimBergHansen) Data twisting KimBergHansen Use of Oracle SQL to twist data around - unpivot columns to rows, pivot rows to columns, parse delimited strings to columns and rows, turn rows into delimited strings. Presentation given at OUGN Spring Conference 2016. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/datatwisting-160330082313-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Use of Oracle SQL to twist data around - unpivot columns to rows, pivot rows to columns, parse delimited strings to columns and rows, turn rows into delimited strings. Presentation given at OUGN Spring Conference 2016.
Data twisting from Kim Berg Hansen
]]> 1093 6 https://cdn.slidesharecdn.com/ss_thumbnails/datatwisting-160330082313-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Oracle database - Get external data via HTTP, FTP and Web Services /slideshow/oracle-36496025/36496025 khansen-140701015953-phpapp02
Letting the Oracle database call out to "the world" and get external data via HTTP, FTP and Web Services. As presented on ODTUG Kscope14 conference.]]>
Letting the Oracle database call out to "the world" and get external data via HTTP, FTP and Web Services. As presented on ODTUG Kscope14 conference.]]> Tue, 01 Jul 2014 01:59:53 GMT /slideshow/oracle-36496025/36496025 KimBergHansen@slideshare.net(KimBergHansen) Oracle database - Get external data via HTTP, FTP and Web Services KimBergHansen Letting the Oracle database call out to "the world" and get external data via HTTP, FTP and Web Services. As presented on ODTUG Kscope14 conference. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/khansen-140701015953-phpapp02-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Letting the Oracle database call out to &quot;the world&quot; and get external data via HTTP, FTP and Web Services. As presented on ODTUG Kscope14 conference.
Oracle database - Get external data via HTTP, FTP and Web Services from Kim Berg Hansen
]]> 10864 14 https://cdn.slidesharecdn.com/ss_thumbnails/khansen-140701015953-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Oracle database - Analytic functions - Advanced cases /slideshow/analytic-functions-advanced-cases/36495950 khansen-140701015715-phpapp02
Using Oracle SQL Analytic functions Case: Picking by FIFO (like my previous presentations) Case: Sales forecasting (Time Series Analysis - new case) As presented on ODTUG Kscope14 conference]]>
Using Oracle SQL Analytic functions Case: Picking by FIFO (like my previous presentations) Case: Sales forecasting (Time Series Analysis - new case) As presented on ODTUG Kscope14 conference]]> Tue, 01 Jul 2014 01:57:14 GMT /slideshow/analytic-functions-advanced-cases/36495950 KimBergHansen@slideshare.net(KimBergHansen) Oracle database - Analytic functions - Advanced cases KimBergHansen Using Oracle SQL Analytic functions Case: Picking by FIFO (like my previous presentations) Case: Sales forecasting (Time Series Analysis - new case) As presented on ODTUG Kscope14 conference <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/khansen-140701015715-phpapp02-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Using Oracle SQL Analytic functions Case: Picking by FIFO (like my previous presentations) Case: Sales forecasting (Time Series Analysis - new case) As presented on ODTUG Kscope14 conference
Oracle database - Analytic functions - Advanced cases from Kim Berg Hansen
]]> 1602 3 https://cdn.slidesharecdn.com/ss_thumbnails/khansen-140701015715-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation White http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Real cases of indispensability of Oracle SQL analytic functions /slideshow/real-cases-of-indispensability-of-oracle-sql-analytic-functions/17366107 realcasesofanalyticfunctionskscope12-130319093746-phpapp02
Presentation on Oracle SQL analytic functions as presented by me at ODTUG KScope 2012]]>
Presentation on Oracle SQL analytic functions as presented by me at ODTUG KScope 2012]]> Tue, 19 Mar 2013 09:37:46 GMT /slideshow/real-cases-of-indispensability-of-oracle-sql-analytic-functions/17366107 KimBergHansen@slideshare.net(KimBergHansen) Real cases of indispensability of Oracle SQL analytic functions KimBergHansen Presentation on Oracle SQL analytic functions as presented by me at ODTUG KScope 2012 <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/realcasesofanalyticfunctionskscope12-130319093746-phpapp02-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Presentation on Oracle SQL analytic functions as presented by me at ODTUG KScope 2012
Real cases of indispensability of Oracle SQL analytic functions from Kim Berg Hansen
]]> 2316 4 https://cdn.slidesharecdn.com/ss_thumbnails/realcasesofanalyticfunctionskscope12-130319093746-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation White http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 Really using Oracle analytic SQL functions /slideshow/really-using-analyticfunctionsukoug2012/17313104 reallyusinganalyticfunctionsukoug2012-130318053626-phpapp01
Presentation on Oracle analytic SQL functions as I presented it on UKOUG 2012 conference in Birmingham]]>
Presentation on Oracle analytic SQL functions as I presented it on UKOUG 2012 conference in Birmingham]]> Mon, 18 Mar 2013 05:36:26 GMT /slideshow/really-using-analyticfunctionsukoug2012/17313104 KimBergHansen@slideshare.net(KimBergHansen) Really using Oracle analytic SQL functions KimBergHansen Presentation on Oracle analytic SQL functions as I presented it on UKOUG 2012 conference in Birmingham <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/reallyusinganalyticfunctionsukoug2012-130318053626-phpapp01-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Presentation on Oracle analytic SQL functions as I presented it on UKOUG 2012 conference in Birmingham
Really using Oracle analytic SQL functions from Kim Berg Hansen
]]> 3447 8 https://cdn.slidesharecdn.com/ss_thumbnails/reallyusinganalyticfunctionsukoug2012-130318053626-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds presentation White http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 0 https://cdn.slidesharecdn.com/profile-photo-KimBergHansen-48x48.jpg?cb=1674639287 I'm an Oracle database developer at Cegal Danmark, specializing in utilizing the SQL and PL/SQL languages to the fullest for efficient data manipulation and analysis. Not just for performance, but also for better maintenance of applications over time, putting SQL wrapped inside a PL/SQL API containing business logic for User Interface to call - this method saves a lot as business logic can be reused when UI often needs change. In general I develop applications with the Oracle database in focus, often integrating the database directly with other apps or webservices, letting the database consume data from other sources or produce data for other targets. www.kibeha.dk https://cdn.slidesharecdn.com/ss_thumbnails/kbhexternaltables-notjustloadingacsvfile-180921072308-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/external-tables-not-just-loading-a-csv-file/115728761 External Tables - not ... https://cdn.slidesharecdn.com/ss_thumbnails/when7-bitasciiaintenough-aboutnlscollationcharsetsunicodeandsuch-180910091152-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/when-7-bitascii-aint-enough-about-nls-collation-charsets-unicode-and-such-v2/113741411 When 7 bit-ascii ain&#39;t... https://cdn.slidesharecdn.com/ss_thumbnails/when7-bitasciiaintenough-aboutnlscollationcharsetsunicodeandsuch-180410073017-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/when-7bit-ascii-aint-enough-about-nls-collation-charsets-unicode-and-such/93417368 When 7-bit ASCII ain&#39;t...