This Video Shows
1. How to Read and parse XML in Oracle using EXTRACTVALUE and XMLTABLE. 2. When to use extractvalue and XMLTable.
3. Brief Introduction to XMLPATH
Views: 12202
yrrhelp
This video gives an overview of the SQL/XML (SQLX) functionality, which can be used to generate XML documents using SQL. For more information see:
https://oracle-base.com/articles/misc/sqlxml-sqlx-generating-xml-content-using-sql
Website: https://oracle-base.com
Blog: https://oracle-base.com/blog
Twitter: https://twitter.com/oraclebase
Cameo by Kevin Closson :
Blog : https://kevinclosson.net/
Twitter : https://twitter.com/kevinclosson
Cameo appearances are for fun, not an endorsement of the content of this video.
All trademarks, product names and logos are the property of their respective owners.
Views: 8361
ORACLE-BASE.com
Follow the Books: http://amzn.to/1RjjJCf
Get the slides and Scripts at: http://www.aaronbuma.com/2015/09/xml-queries-xquery-relative-absolute-and-data-function
Lots of other free SQL Sessions at: http://www.aaronbuma.com/category/sql-training/
Views: 5211
Aaron Buma
How to make a function to create dynamic XML by passing values
Views: 285
Chris Thayer
The Lesson: http://www.aaronbuma.com/2015/06/xml-modes-raw-auto-path/
Follow the Books: http://amzn.to/1RjjJCf
Other Trainings: www.AaronBuma.com/free-sql-server-training/
For previous presentations and notifications of upcoming events, checkout my blog: www.AaronBuma.com or follow @AaronDBuma
Slides and scripts are also available at: www.AaronBuma.com
Views: 10971
Aaron Buma
In this tutorial, you'll learn how to make use of extract function.
PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database.
PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces.
PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard.
The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3]
PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables.
PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7]
The StepSqlite product is a PL/SQL compiler for the popular small database SQLite.
PL/SQL Program Unit
A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database.
The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label.
Package
Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are:
Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation.
Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 4052
radhikaravikumar
Oracle XML Publisher Report - Basic
Views: 13170
Lead Technologies
This video explains the fundamentals of the XML Data Type Methods. Visit http://bit.ly/JreYVR for Script, Quiz and further learning.
Views: 5084
Pinal Dave
Link to the blog: https://slobaexpert.wordpress.com/2015/02/05/calling-web-services-from-oracle-plsql/
Views: 18571
Swadhin Ray
SQL is the winning language of Big Data. Whether you’re running a classic relational database, a column store (“NewSQL”), or a non-relational storage system (“NoSQL”), a powerful, declarative, SQL-based query language makes the difference. The SQL standard has evolved drastically in the past decades, and so have its commercial and open source implementations. In this fast-paced talk, we’re going to look at very peculiar and interesting data problems and how we can solve them with SQL. We’ll explore common table expressions, hierarchical SQL, table-valued functions, lateral joins, row value expressions, window functions, and advanced data types, such as XML and JSON. And we’ll look at Oracle’s mysterious MODEL and MATCH_RECOGNIZE clauses, devices whose mystery is only exceeded by their power. Most importantly, however, we’re going to learn that everyone can write advanced SQL. Once you learn the basics in these tricks, you’re going to love SQL even more.
Views: 14822
Devoxx FR
With sql you can generate xml. And you don't have to code a single line in programming language. For script in lecture please check link below:
http://www.techsapphire.in/news/sql_xml_queries/2014-06-10-49
Views: 2152
techsapphire
This video gives a quick overview of the XMLTABLE functionality, which can be used to convert XML documents in to rows and columns in SQL. For more information see:
https://oracle-base.com/articles/misc/xmltable-convert-xml-data-into-rows-and-columns-using-sql
https://oracle-base.com/articles/misc/sqlxml-sqlx-generating-xml-content-using-sql
Website: https://oracle-base.com
Blog: https://oracle-base.com/blog
Twitter: https://twitter.com/oraclebase
Cameo by Mike Hichwa :
Twitter : https://twitter.com/mikehichwa1
Cameo appearances are for fun, not an endorsement of the content of this video.
All trademarks, product names and logos are the property of their respective owners.
Views: 22373
ORACLE-BASE.com
In this video, we demonstrate how to query XML columns in SQL (Microsoft SQL Server). We use the nodes function with cross apply.
Please provide feedback and video requests so you get the most out of upcoming videos and subscribe.
Thank you!
Views: 617
Marvin Thobejane
Oracle XML Bursting Report - XDO Functions
Views: 21311
Lead Technologies
Oracle retrieve data from xml document using xmltable
Views: 6356
Sridhar Raghavan
This video describes how to generate XML from SQL Server tables.
The SQL code used in the video is available at:
http://askadba.blogspot.com/2012/08/generating-xml-from-sql-server-tables.html
Views: 73638
askadba
sql server stuff for xml
sql stuff concatenate rows
sql stuff comma separated list
sql stuff group by
stuff with case in sql server
sql stuff multiple rows into one
stuff function in oracle
sql string function stuff
Views: 134
C Plus+
ODI 12c Tutorials Session9 on Loading Data from XML File To SQL Table using ODI Mapping
ODI 12c Tutorial
ODI 12c Tutorial for beginners
ODI Tutorial
ODI Tutorial for Beginners
Views: 3734
TechLake
Learn how to query XML datasets using XPath and XQuery. This tutorial is targeted to those with a background in SQL, but will still be useful to anyone getting started in XPath and XQuery.
Sample files: https://github.com/altova/XPath-XQuery-SQL-Tutorial
Download a free 30 day trial of Altova XMLSpy from http://www.altova.com/.
Views: 8378
Altova
Complete Oracle PL/SQL Tutorial for Beginners Playlist here
https://www.youtube.com/playlist?list=PLI5t0u6ye3FE_9SZcS0cQZDU2qn0uB1Oi
**************************************************
Composite DataType - Collections in Oracle PL SQL
1. Difference Between Records and Collections
2. Types of Collections in Oracle
3. VARRAYS
4. Nested Table
3. Associative Arrays / Index BY Tables
4. Multi Dimensional Arrays Using Collections and Records
Views: 17842
yrrhelp
Oracle plsql xml generation DBMS_XMLGEN part 2
Views: 511
Sridhar Raghavan
Views: 1307
Lead Technologies
Mapping to Read XML data from Oracle Clob and use XML parser to write it into XML files.
Views: 3822
InfaMarketplace
Views: 417
Windward Studios
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: 194170
kudvenkat
Video from our Oracle SQL course. Check out the full course at..
http://learn.hackpress.co/courses/oracle-sql-learning-by-example
Views: 45155
etldeveloper
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: 10729
SkillBuilders
Learn how to use External table to load TXT and XML files. More videos: http://www.learn-with-video-tutorials.com/oracle-working-with-external-files
Views: 9641
Learn with video tutorials
Combine all rows into a single string adventure works example. This method uses coalesce to remove the leading comma. Easier than for xml path in my opinion.
For XML path example(next video): https://www.youtube.com/watch?v=QwPjbQosjgw
Views: 3647
Blake B
http://www.trainsignal.com/SQL-Server-2012-Querying-Training.aspx?utm_source=YouTube&utm_medium=Social%20Media&utm_campaign=SQL%20Querying%20Demo
In this free video from our SQL Server 2012 Querying Training, Christopher Harrison talks about the basics of XML and how it can be used with SQL Server.
-~-~~-~~~-~~-~-
This channel is an archive! Subscribe to Pluralsight for new IT Pro training
➨ https://www.youtube.com/user/Pluralsight?sub_confirmation=1
-~-~~-~~~-~~-~-
Views: 24658
Pluralsight IT - Training Archive
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: 29769
techsapphire
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: 365
Oracle Developers
Load the data from Flat file to database table using SQL*LOADER concept in Oracle Applications.
Views: 35394
Prabhu Raja Kumar Neelam
Oracle XML Publisher Report With Parameters & Trigger
Views: 235
Lead Technologies
How to get Oracle SQL Developer to automatically format your query results to CSV, HTML, JSON, Insert statements, and more.
Views: 44131
Jeff Smith
Sql Server user defined data types, rules, defaults and xml data type
Views: 1602
FxAbs Tutorials
This video demonstrates how to use XQuery to query XML data in SQL Server.
The SQL code used in the video is available at:
http://askadba.blogspot.com/2012/08/using-xquery-to-query-xml-data.html
Views: 31631
askadba
One of SQL Developer’s most popular features has undergone a significant upgrade. Users can quickly define and recall delimited or Excel files to be imported to a new or existing Oracle table. Data preview and validation is provided for each column, as well as ‘best guess’ data type and date format mask mapping. This process can now be automated via the SQL Developer command line interface (SDCLI) ‘Import’ command. NOTE: This is a video only. There is no audio.
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: 71558
Oracle Learning Library
The modern IBM i enterprise requires full integration with a multitude of systems and sources, not to mention customers and suppliers. But how do we manage and control this growth in integration? Are we able to capture data from emails, FTP, and other locations then easily parse information? What about validation and how about the need to reciprocate with integration to their systems?
This short video introduces technologies that support the integration of external data with IBM i and vice versa. It demonstrates how you can use data such as XML and XLS as part of your integrated processes.
Learn more by contacting us on:
(UK) +44 1204 388883 | Andrew Nicholson | [email protected]
(USA) +1 970 731 5645 | Chris Harwood | [email protected]
and don't forget to follow up on twitter @utilites400
Views: 801
Utilities400
Complete Oracle PLSQL Tutorial Playlist here
https://www.youtube.com/playlist?list=PLI5t0u6ye3FE_9SZcS0cQZDU2qn0uB1Oi
**************************************************
This Video Covers the following in Oracle PLSQL
1. Composite Data Types - Records
2. DECLARE a Implicit Record and Explicit Record
3. %TYPE
4. %ROWTYPE
5. Assigning Values to a Records
6. Fetch Values from a record
7. Difference Between Record and Collections
Views: 6850
yrrhelp
ITS ALL ABOUT ROUND FUNCTION IN SQL,HOW TO USE ROUND FUNCTION IN SQL
Views: 282
Technical Aashique
In this training video we will learn how to use amazing power of Temporary Tables in Oracle SQL for Analysis and Reporting functions.
Views: 810
Spod ssppoodd
Oracle Apps Technical Training at Lead Tech Solutions, Hyderabad, India, India: +91-7207149158, Web: www.leadtechsol.blogspot.in
Views: 9
CALFRE. COM Training Videos
Oracle DB - SQL Loader
Watch More Videos at:
https://www.tutorialspoint.com/videotutorials/index.htm
Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
Views: 2539
Tutorials Point (India) Pvt. Ltd.
Updating multiple attribute in XML using "replace value of" is challenge as, we are constraint to update 1 value at once. To achieve this we need to loop for each attribute.
Follow link for script:
http://www.techsapphire.in/index/updating_attribute_of_multiple_node_in_xml_using_replace_value_of_in_sql_server/0-192
Views: 182
techsapphire
This technique show how to pass an xml document to a stored procedure, the xml doc contains a set of name-value pairs. Each param within the doc, is extracted to provide internal parameters to the stored procedure, for example DateType param is used used to derive a date range for a query - T = today, Y = Yesterday, YTD and Range where a start and enddate must be passed with the XML doc as well. Another example is teh ReportType param, within the xml which be set to run either a Details report query or a Summary report query. Very useful technique where the number and types of params vary, but you want a single interface to the stored proc.
Views: 4014
SQLnuggets