Home
Search results “Oracle parse sql string”
How to Parse XML in Oracle
 
13:54
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: 11293 yrrhelp
Sql Server  Parsing Strings
 
02:17
8. Parsing Strings
Views: 1960 Eagle
AskTOM TV - how to do string parsing with INSTR
 
06:46
blog: https://connor-mcdonald.com A short video to help you understand the "thought process" behind answering AskTom questions. ========================================­­­­============== Copyright © 2017 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: 1084 Connor McDonald
What Is The Rule of Oracle Parse SQL
 
00:16
Typically, a program encourages the consumer for the writing of an SQL declaration and of the variety factors used in the statement. Oracle then parses the MySQL declaration to make sure it satisfies format guidelines. Next, Oracle holds the variety factors to the SQL declaration. That is, Oracle gets the details of the variety factors so that it can study or create their principles. Then Oracle carries out the SQL declaration. That is, Oracle does what the SQL declaration asked for, such as removing series from a desk.
Views: 56 Krutika Meheta
SQL Server 4.8 (Parsing Strings)
 
02:17
Parsing Strings
Views: 61 seewhatseeabc
Oracle DBA Justin - How to define and undefine variables in sqlplus
 
16:16
How to define and undefine variables in sqlplus
Views: 1934 jbleistein11
Oracle regular expression part 2 extracting substring regexp substr
 
08:11
Oracle SQL PLSQL and Unix Shell Scripting
Views: 4497 Sridhar Raghavan
SQL Server Function to Parse numbers from String
 
06:20
Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg Simple User defined function to Parse Numbers from String
Views: 97 IT Port
Real-World Performance - 3 - Connection Pools and Hard Parse
 
06:19
Check out the entire series on the Oracle Learning Library at http://www.oracle.com/goto/oll/rwp In this video, listen and watch Andrew Holdsworth, Vice President of Oracle Database Real-World Performance at Oracle Corporation, as he demonstrates how connections and hard parsing contribute to transaction throughput and simulates the mistakes of a poor configuration creating sub-optimal performance. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
SQL Concatenate All Rows Into A String
 
06:24
Combine all rows into a single string adventure works example. This method uses coalesce to remove the leading comma. Easier than for xml path in my opinion. For XML path example(next video): https://www.youtube.com/watch?v=QwPjbQosjgw
Views: 3179 Blake B
SQL: Extract function
 
03:38
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: 3824 radhikaravikumar
SQL parser
 
01:09
Dynamic, interactive visualisation that parses a complex MS SQL query and displays it as a diagram.
Views: 792 Emma Saunders
substr in oracle
 
02:57
Oracle function to extract portion of a string
Views: 627 Kunal Thaker
Parsing a Query
 
08:03
Views: 445 David Dubczak
T-SQL: PARSING VALUES BASED ON NTH OCCURENCE OF A CHARACTER IN A STRING
 
08:03
In this video, I will demonstrate how to parse values based on the nth occurence of a specific character Please check my blog azizsharif.blogspot.com for more videos!
XMLTABLE : Convert XML into Rows and Columns using SQL
 
03:11
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: 21618 ORACLE-BASE.com
new STRING_SPLIT() function in SQL Server 2016
 
06:10
New STRING_SPLIT() function in SQL Server 2016 to split a string into multiple values & rows. Check the whole "SQL Server 2016" series here: https://www.youtube.com/playlist?list=PLU9JMEzjCv16mB9n4av00uZB5TJsdK3CG Check the details and code on my SQL blog at: https://sqlwithmanoj.com/2016/03/10/new-in-built-table-valued-function-string_split-in-sql-server-2016-to-split-strings/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 8267 SQL with Manoj
SQL Parser demo
 
00:45
Views: 732 Jean Lopes
Oracle LISTAGG Function
 
04:57
https://www.databasestar.com/oracle-listagg/ The Oracle LISTAGG function allows you to aggregate or combine string values from multiple rows into a single row. For example, it turns this data: FIRST_NAME Adam Brad Carrie Into this data: FIRST_NAME Adam, Brad, Carrie The same data is shown, but it’s in one row and not multiple. It’s a valuable string manipulation function, and once you know what it is and how it works, you’ll be able to use it in your queries as needed. So what does it look like? The function is: LISTAGG ( measure_expr [, delimiter]) WITHIN GROUP (order_by_clause) [OVER query_partition_clause] These parameters are: measure_expr: This is a column or expression that you want to concatenate the values of. In the example above, it was the first_name column. Mandatory. delimiter: This is the character between each of the measure_expr values. Optional, the default is a comma. order_by_clause: This is the order that the values from the measure_expr are listed. Mandatory. query_partition_clause: This allows you to use LISTAGG as an analytic function, allowing you to show LISTAGG in groups for different rows. One thing to be aware of is that the output of the Oracle LISTAGG function is limited to 4,000 bytes. If you get more than this, you’ll receive an error. The most common way around this that I’ve seen is to write a custom function and use a CLOB. Watch the video to find out more and see some examples. For more information about the Oracle LISTAGG function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-listagg/
Views: 2523 Database Star
JSON in Oracle 12C Part 1 - Creating JSON Columns in Tables
 
09:20
This is the first video in a series of videos on how to handle JSON data in Oracle 12C. In this video, I'll show you how to create columns in a table that will be used to hold JSON data.
Views: 4706 Pretty Printed
Oracle PL/SQL Tutorial - Strings
 
05:24
Want all of our free Oracle videos? Download our free iPad app at http://itunes.apple.com/us/app/video-training-courses-from/id418130423?mt=8 http://www.infiniteskills.com/training/learning-oracle-pl-sql-programming.html Instructor Lewis Cunningham explains strings in this InfiniteSkills tutorial on Oracle PLSQL. YouTube: https://www.youtube.com/user/OreillyMedia Facebook: https://www.facebook.com/OReilly/?fref=ts Twitter: https://twitter.com/OReillyMedia Website: http://www.oreilly.com/
Oracle regular expression part 3 replace a substring regexp replace
 
06:00
Oracle SQL PLSQL and Unix Shell Scripting
Views: 2640 Sridhar Raghavan
MSSQL - How to separate first and last name
 
02:56
Simple example that shows how to read until first empty space and after first empty space More info http://howtodomssqlcsharpexcelaccess.blogspot.ca/2015/06/mssql-how-to-get-first-name-and-last.html
Views: 5146 Vis Dotnet
JSQL Parser
 
25:51
JSQL Parser
Views: 1424 Ramesh Rajaram
Oracle Architecture
 
04:11
This video describes the best architecture of the oracle after trying more than times to Oracle structure I decided to produce an animated video let's start first with the database structure on the left side you have the client here on the right side you have to serve a two-year the server side is divided in three main structures to memory the logical structure and the physical structure so let's use SQL Plus application to provide you every step up a transaction will be using Scott sample schema it is important to note that the whole string is an alias and not a database name district will be compared to this alias inside of a file called pianist named doc or this file is similar to a DNS and with up pain all the necessary detail to reach a database server locally a user process will be allocated and will validate the connection through a listener the listener will be in charge to allocate a server process the user processes da link to the server process let's now execute our first transaction for this example we will execute an update first to state that will be validated we call this step the parsing this server process sense back to confirmation of the parsing that statement with be written into their share pool and the redo log buffer an execution plan will also be created it to the fair share Paul that database book they choose fought the transaction will be read and copy into the database buffer cache only that feel implicated in that transaction will be held it to a - segment till the transaction is completed we call those copies the before image a copy of this block will be duplicated with the updated feel this copy is called me after image a confirmation will be sent to to use a process the commit statement will complete the transaction and will be written into to redo log buffer to commit statement triggers the log writer process and we'll send all statement for the current transaction into the redo log file the before image into undo segment could be then deleted went that threshold up to undo retention parameters reach alaskan from Asian will be sent to the user process went to current law kiss Paul it generates a switch lock triggering at the same time the archiver process and to log sequence number the archiver will generate and archive the file with the content of the current loc a switch up with them trigger a checkpoint process that will incriminate the checkpoint number by applying this last number into each data file header the checkpoint process with finally trigger the database writer process enright the last image from that database buffer cache into thirty people
Views: 20357 Ezylearning
Transpose Rows into Columns in Oracle Database
 
11:36
Transpose rows to columns in Oracle , rows into columns in Oracle
Views: 93 Adam Tech
When Should You Use SQL Bind Variables? Always!
 
02:21
When is the right time to use Bind Variables in your SQL statements? "Pretty much all the time," says Mark Williams. Mark, a Method R evangelist with Cintra Software and Services, explains it all in this 2 Minute Tech Tip recorded at ODTUG Kscope 2018 at Walt Disney World in Orlando, Florida. https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit
Views: 438 Oracle Developers
How to load text file content into CLOB column using Oracle sql loader
 
05:01
How to load text content into oracle table CLOB column? http://easy-learning-tech.blogspot.in/2018/04/loading-clob-data-into-oracle-table.html
Views: 861 Siva Academy
Strings in PL SQL Tutorial
 
07:35
Subscribe for more PL SQL tutorials https://www.youtube.com/channel/UC7sbHUgN8FnJEZkEjvKTwJg String Function & Purpose 1 ASCII(x); Returns the ASCII value of the character x. 2 CHR(x); Returns the character with the ASCII value of x. 3 CONCAT(x, y); Concatenates the strings x and y and return the appended string. 4 INITCAP(x); Converts the initial letter of each word in x to uppercase and returns that string. 5 INSTR(x, find_string [, start] [, occurrence]); Searches for find_string in x and returns the position at which it occurs. 6 INSTRB(x); Returns the location of a string within another string, but returns the value in bytes. 7 LENGTH(x); Returns the number of characters in x. TUTORIALSPOINT Simply Easy Learning Page 59 8 LENGTHB(x); Returns the length of a character string in bytes for single byte character set. 9 LOWER(x); Converts the letters in x to lowercase and returns that string. 10 LPAD(x, width [, pad_string]) ; Pads x with spaces to left, to bring the total length of the string up to width characters. 11 LTRIM(x [, trim_string]); Trims characters from the left of x. 12 NANVL(x, value); Returns value if x matches the NaN special value (not a number), otherwise x is returned. 13 NLS_INITCAP(x); Same as the INITCAP function except that it can use a different sort method as specified by NLSSORT. 14 NLS_LOWER(x) ; Same as the LOWER function except that it can use a different sort method as specified by NLSSORT. 15 NLS_UPPER(x); Same as the UPPER function except that it can use a different sort method as specified by NLSSORT. 16 NLSSORT(x); Changes the method of sorting the characters. Must be specified before any NLS function; otherwise, the default sort will be used. 17 NVL(x, value); Returns value if x is null; otherwise, x is returned. 18 NVL2(x, value1, value2); Returns value1 if x is not null; if x is null, value2 is returned. 19 REPLACE(x, search_string, replace_string); Searches x for search_string and replaces it with replace_string. 20 RPAD(x, width [, pad_string]); Pads x to the right. 21 RTRIM(x [, trim_string]); Trims x from the right. 22 SOUNDEX(x) ; Returns a string containing the phonetic representation of x. 23 SUBSTR(x, start [, length]); Returns a substring of x that begins at the position specified by start. An optional length for the substring may be supplied. 24 SUBSTRB(x); Same as SUBSTR except the parameters are expressed in bytes instead of characters for the single-byte character systems. 25 TRIM([trim_char FROM) x); Trims characters from the left and right of x. 26 UPPER(x); Converts the letters in x to uppercase and returns that string.
Views: 340 Puzzle Guru
Oracle SQL Developer Tutorial For Beginners  82   SQL Statement Terminators
 
01:46
Oracle SQL Developer Tutorial For Beginners Series. This course introduces Oracle SQL Development for its subscribers. Currently this is based on Oracle 12c. The test environment is in Windows 10.
Views: 552 Sam Dhanasekaran
Part 18   Load xml data into sql server table using sqlbulkcopy
 
11:58
In this video we will discuss 1. What is the use of SqlBulkCopy class 2. Loading xml data into sql server table using sqlbulkcopy What is the use of SqlBulkCopy class SqlBulkCopy class is used to bulk copy data from different data sources to SQL Server database. This class is present in System.Data.SqlClient namespace. This class can be used to write data only to SQL Server tables. However, the data source is not limited to SQL Server, any data source can be used, as long as the data can be loaded to a DataTable instance or read with a IDataReader instance. From a performance standpoint, SqlBulkCopy makes it very easy and efficient to copy large amounts of data. Loading xml data into sql server table using sqlbulkcopy The following are the steps to achieve this using SqlBulkCopy class Step 1 : Create the database tables using the following sql script Create table Departments ( ID int primary key, Name nvarchar(50), Location nvarchar(50) ) GO Create table Employees ( ID int primary key, Name nvarchar(50), Gender nvarchar(50), DepartmentId int foreign key references Departments(Id) ) GO Step 2 : Create a new empty asp.net web application project. Name it Demo. Step 3 : Add a new xml file to the project. Name it Data.xml. Copy and paste the following XML. [?xml version="1.0" encoding="utf-8" ?] [Data] [Department Id="1"] [Name]IT[/Name] [Location]New York[/Location] [/Department] [Department Id="2"] [Name]HR[/Name] [Location]London[/Location] [/Department] [Department Id="3"] [Name]Payroll[/Name] [Location]Mumbai[/Location] [/Department] [Employee Id="1"] [Name]Mark[/Name] [Gender]Male[/Gender] [DepartmentId]1[/DepartmentId] [/Employee] [Employee Id="2"] [Name]John[/Name] [Gender]Male[/Gender] [DepartmentId]1[/DepartmentId] [/Employee] [Employee Id="3"] [Name]Mary[/Name] [Gender]Female[/Gender] [DepartmentId]2[/DepartmentId] [/Employee] [Employee Id="4"] [Name]Steve[/Name] [Gender]Male[/Gender] [DepartmentId]2[/DepartmentId] [/Employee] [Employee Id="5"] [Name]Ben[/Name] [Gender]Male[/Gender] [DepartmentId]3[/DepartmentId] [/Employee] [/Data] Step 4 : Include the database connection string in web.config file [connectionStrings] [add name="CS" connectionString="server=.;database=Sample;integrated security=true"/] [/connectionStrings] Step 5 : Add a new WebForm to the project. Drag and drop a button control on the webform. Double click the button control to generate the click event handler. Copy and paste the following code in the the click event handler method. string cs = ConfigurationManager.ConnectionStrings["CS"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { DataSet ds = new DataSet(); ds.ReadXml(Server.MapPath("~/Data.xml")); DataTable dtDept = ds.Tables["Department"]; DataTable dtEmp = ds.Tables["Employee"]; con.Open(); using (SqlBulkCopy sb = new SqlBulkCopy(con)) { sb.DestinationTableName = "Departments"; sb.ColumnMappings.Add("ID", "ID"); sb.ColumnMappings.Add("Name", "Name"); sb.ColumnMappings.Add("Location", "Location"); sb.WriteToServer(dtDept); } using (SqlBulkCopy sb = new SqlBulkCopy(con)) { sb.DestinationTableName = "Employees"; sb.ColumnMappings.Add("ID", "ID"); sb.ColumnMappings.Add("Name", "Name"); sb.ColumnMappings.Add("Gender", "Gender"); sb.ColumnMappings.Add("DepartmentId", "DepartmentId"); sb.WriteToServer(dtEmp); } } Note: Please make sure to include the following using declarations using System; using System.Configuration; using System.Data; using System.Data.SqlClient; Text version of the video http://csharp-video-tutorials.blogspot.com/2014/09/part-18-load-xml-data-into-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2014/09/part-18-load-xml-data-into-sql-server_23.html All ADO .NET Text Articles http://csharp-video-tutorials.blogspot.com/p/free-adonet-video-tutorial.html All ADO .NET Slides http://csharp-video-tutorials.blogspot.com/p/adonet-slides.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: 64702 kudvenkat
BLOB and CLOB in Oracle Database
 
03:13
BLOB and CLOB in Oracle Database
Views: 7825 Abe Samir's Academy
Mapping: Read XML Data from Oracle Clob
 
01:39
Mapping to Read XML data from Oracle Clob and use XML parser to write it into XML files.
Views: 3750 InfaMarketplace
Rules of Precedence Oracle database Hindi/Urdu
 
09:29
Explore SQL with Asad In this lesson, learn about the Order of Precedence in SQL! Please Subscribe my channel Like,Comment and Share
Views: 181 Oracle With Asad
GROUPING ID function in SQL Server
 
12:38
grouping_id function in sql server 2008 grouping_id in sql server 2008 example sql server grouping level In this video we will discuss 1. GROUPING_ID function in SQL Server 2. Difference between GROUPING and GROUPING_ID functions 3. Use of GROUPING_ID function GROUPING_ID function computes the level of grouping. Difference between GROUPING and GROUPING_ID Syntax : GROUPING function is used on single column, where as the column list for GROUPING_ID function must match with GROUP BY column list. GROUPING(Col1) GROUPING_ID(Col1, Col2, Col3,...) GROUPING indicates whether the column in a GROUP BY list is aggregated or not. Grouping returns 1 for aggregated or 0 for not aggregated in the result set. GROUPING_ID() function concatenates all the GOUPING() functions, perform the binary to decimal conversion, and returns the equivalent integer. In short GROUPING_ID (A, B, C) = GROUPING(A) + GROUPING(B) + GROUPING(C) Let us understand this with an example. SELECT Continent, Country, City, SUM(SaleAmount) AS TotalSales, CAST(GROUPING(Continent) AS NVARCHAR(1)) + CAST(GROUPING(Country) AS NVARCHAR(1)) + CAST(GROUPING(City) AS NVARCHAR(1)) AS Groupings, GROUPING_ID(Continent, Country, City) AS GPID FROM Sales GROUP BY ROLLUP(Continent, Country, City) Row Number 1 : Since the data is not aggregated by any column GROUPING(Continent), GROUPING(Country) and GROUPING(City) return 0 and as result we get a binar string with all ZEROS (000). When this converted to decimal we get 0 which is displayed in GPID column. Row Number 7 : The data is aggregated for Country and City columns, so GROUPING(Country) and GROUPING(City) return 1 where as GROUPING(Continent) return 0. As result we get a binar string (011). When this converted to decimal we get 10 which is displayed in GPID column. Row Number 15 : This is the Grand total row. Notice in this row the data is aggregated by all the 3 columns. Hence all the 3 GROUPING functions return 1. So we get a binary string with all ONES (111). When this converted to decimal we get 7 which is displayed in GPID column. Use of GROUPING_ID function : GROUPING_ID function is very handy if you want to sort and filter by level of grouping. Sorting by level of grouping : SELECT Continent, Country, City, SUM(SaleAmount) AS TotalSales, GROUPING_ID(Continent, Country, City) AS GPID FROM Sales GROUP BY ROLLUP(Continent, Country, City) ORDER BY GPID Filter by level of grouping : The following query retrieves only continent level aggregated data SELECT Continent, Country, City, SUM(SaleAmount) AS TotalSales, GROUPING_ID(Continent, Country, City) AS GPID FROM Sales GROUP BY ROLLUP(Continent, Country, City) HAVING GROUPING_ID(Continent, Country, City) = 3 Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/groupingid-function-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/groupingid-function-in-sql-server_27.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 31127 kudvenkat
Oracle LOBS
 
31:33
Oracle LOBS
Views: 1872 The Silent DBA
SQL Server 2012 - Generating XML from SQL Server tables
 
09:10
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: 72364 askadba
How to Update JSON String Using JSON_MODIFY Function (T-SQL Reference)
 
05:39
Buy Me a Coffee? https://www.paypal.me/jiejenn/5 Your donation will help me to make more tutorial videos! How to Update JSON String Using JSON_MODIFY Function (SQL Server 2016 or later). These are the MS SQL Server books I personally recommended For beginner MS SQL Server users ► T-SQL Fundamentals: http://amzn.to/2uzxNqf ► Microsoft SQL Server 2016: A Beginner's Guide: http://amzn.to/2uztNGv For experience MS SQL Server users ► Murach's SQL Server 2016 for Developers: http://amzn.to/2h4Azz5 My equipment when using spreadsheet, email, and programming ► Logitech MX Master 2S Wireless Mouse with FLOW Cross-Computer Control and File Sharing for PC and Mac: http://amzn.to/2urglTm ► Logitech Wireless Illuminated Keyboard K800: http://amzn.to/2eGz8Gw Equipment I use for recording ► Blue Yeti USB Microphone: http://amzn.to/2vxs6H3 ► Camtasia 9: http://amzn.to/2tlBNvz If you found this video helpful, please give me a like to my video and subscribe to my channel. Thanks! For any question, please email me at [email protected]
Views: 319 Jie Jenn
Advanced Query Parsing Techniques
 
34:41
Presented by Paul Nelson, Chief Architect, Search Technologies Lucene and Solr provide a number of options for query parsing, and these are valuable tools for creating powerful search applications. This presentation will review the role that advanced query parsing can play in building systems, including: Relevancy customization, taking input from user interface variables such as the position on a website or geographical indicators, which sources are to be searched and 3rd party data sources. Query parsing can also enhance data security. Best practices for building and maintaining complex query parsing rules will be discussed and illustrated.
Views: 3600 LuceneSolrRevolution
Connecting to a Database with Alteryx Designer
 
07:23
Bring in data from a table or SQL Query results from a database, such as SQL server using an ODBC connection. Note that your IT administrator will need to install and configured the ODBC driver as described in http://www.alteryx.com/techspecs and https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Connecting-to-an-ODBC-Datasource/ta-p/17590.
Views: 22323 Alteryx
How to use custom delimiter in Oracle
 
02:00
This video shows you how to convert the data in to rows with custom delimiter as any other special character
How to parse JSON in SQL Server
 
09:13
In this tutorial I will show you how to parse a JSON object in any SQL Server version that supports native JSON parsing. Below is an example with all the things that you need to know: ------------------------------------------------------------------------------------------------------------- --JSON Object DECLARE @JSON_DATA NVARCHAR (MAX); SET @JSON_DATA = '{ "squadName": "Super hero squad", "homeTown": "Metro City", "formed": 2016, "secretBase": "Super tower", "active": true, "members": [ { "name": "Molecule Man", "age": 29, "secretIdentity": "Dan Jukes", "powers": [ "Radiation resistance", "Turning tiny", "Radiation blast" ] }, { "name": "Madame Uppercut", "age": 39, "secretIdentity": "Jane Wilson", "powers": [ "Million tonne punch", "Damage resistance", "Superhuman reflexes" ] }, { "name": "Eternal Flame", "age": 1000000, "secretIdentity": "Unknown", "powers": [ "Immortality", "Heat Immunity", "Inferno", "Teleportation", "Interdimensional travel" ] } ] }'; -- Create table CREATE TABLE [dbo].[JSON_Tutorial] ( [id] [int] NOT NULL, [Squad] [nvarchar](max) NULL ); -- Add JSON object INSERT INTO [dbo].[JSON_Tutorial] VALUES(1,@JSON_DATA); --Validate JSON and get Squad name SELECT id AS SquadId, JSON_VALUE([Squad],'$.squadName') AS SquadName FROM [dbo].[JSON_Tutorial] WHERE ISJSON([Squad]) = 1 -- Parse List of Objects SELECT id AS SquadId, JSON_VALUE([Squad],'$.squadName') AS SquadName, MemeberList.MemberName, MemeberList.Age FROM [dbo].[JSON_Tutorial] CROSS APPLY OPENJSON([Squad], '$.members') WITH( MemberName NVARCHAR(100) '$.name', Age int '$.age' ) AS MemeberList WHERE ISJSON([Squad]) = 1 -- Parse array of strings SELECT id, JSON_VALUE([Squad],'$.squadName') AS SquadName, MemeberList.MemberName, MemeberList.Age, PowerData.PowerName FROM [dbo].[JSON_Tutorial] CROSS APPLY OPENJSON([Squad], '$.members') WITH( MemberName NVARCHAR(100) '$.name', Age int '$.age', MemberPower NVARCHAR(MAX) '$.powers' AS JSON ) AS MemeberList CROSS APPLY OPENJSON(MemberPower) WITH( PowerName NVARCHAR(100) '$' ) AS PowerData WHERE ISJSON([Squad]) = 1
Views: 26 JiFacts
10. INT and DEC Data Type in SQL (Hindi)
 
06:37
Please Subscribe Channel Like, Share and Comment Visit : www.geekyshows.com
Views: 26602 Geeky Shows
how to find oracle url for jdbc
 
01:22
to find your oracle url for connecting to jdbc oracle url syntax - jdbc:oracle:thin:@[hostname]:[port]:[db name] to find the your db information open
Views: 1041 coderz