Home
Search results “Expression oracle regular”
Oracle regular expression part 1 regexp like
 
12:26
Oracle SQL PLSQL and Unix Shell Scripting
Views: 9669 Sridhar Raghavan
Oracle Tutorial || online training|| Adv Sql | Regular Expressions by basha
 
40:52
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Regular Expressions in oracle part 1/ arabic
 
20:28
Regular Expressions in oracle 1 Regexp_like 2 Regexp_replace 3 Regexp_instr 4 Regexp_substr 5 Regexp_count
Views: 1240 khaled alkhudari
Oracle Regular Expressions intro
 
18:13
An essential Introduction to Oracle Regular Expression
Views: 4659 Mohan Ramaswamy
Oracle Regular Expression - Part I
 
04:24
Oracle Regular Expression Examples - Part I
Views: 6659 Mohan Ramaswamy
Regular Expressions (Regex) Tutorial: How to Match Any Pattern of Text
 
37:55
In this regular expressions (regex) tutorial, we're going to be learning how to match patterns of text. Regular expressions are extremely useful for matching common patterns of text such as email addresses, phone numbers, URLs, etc. Almost every programming language has a regular expression library, so learning regular expressions with not only help you with finding patterns in your text editors, but also you'll be able to use these programming libraries to search for patterns programmatically as well. Let's get started... The code from this video can be found at: https://github.com/CoreyMSchafer/code_snippets/tree/master/Regular-Expressions Python Regex Tutorial: https://youtu.be/K8L6KVGG-7o If you enjoy these videos and would like to support my channel, I would greatly appreciate any assistance through my Patreon account: https://www.patreon.com/coreyms Or a one-time contribution through PayPal: https://goo.gl/649HFY If you would like to see additional ways in which you can support the channel, you can check out my support page: http://coreyms.com/support/ Equipment I use and books I recommend: https://www.amazon.com/shop/coreyschafer You can find me on: My website - http://coreyms.com/ Facebook - https://www.facebook.com/CoreyMSchafer Twitter - https://twitter.com/CoreyMSchafer Google Plus - https://plus.google.com/+CoreySchafer44/posts Instagram - https://www.instagram.com/coreymschafer/
Views: 190871 Corey Schafer
Регулярные Выражения. Основы / Regular Expressions / RegEx / RegExp
 
34:04
В этом видео говорим о регулярных выражениях, областях применения этого инструмента, синтаксисе и рассматриваем примеры.
Views: 8233 Sneaky Subnet
Intermediate Oracle 11g - 4. Expressions and Regular Expressions
 
51:10
This Intermediate course expands on the Introduction to Oracle 11g course. It gives you a more detailed grass roots knowledge of Oracle SQL and Oracle PL/SQL. Author covers a wide range of topics including many types of queries, expressions, and statements. He also explores sequences, synonyms, views, materialized views, user access and security, working with indexes, and the basics of programming with PL/SQL. As with the introductory course, this intermediate course is not focused on Oracle Certification but will give you a good start towards some more advanced aspects of coding SQL and PL/SQL. Parts: 01. What an Expression Is. 02. Types of Expressions. 03. Expression Types Demo pt. 1. 04. Expression Types Demo pt. 2. 05. Expression Types Demo pt. 3. 06. Meta Characters. 07. Regular Expression Functions. 08. Using Regular Expression Patterns. 09. Check Constraint Regular Expressions. 10. Oracle Expression Filter.
Views: 124 Free Training
Regular Expression Oracle - 1st Video : Practice Excercise
 
06:21
Please watch and subscribe to our new channel "An Indian Abroad" https://www.youtube.com/channel/UCoLdaMxhfDgdgIAcRGlUvkg This video is the 1st video of the video Series Regular expression in Oracle. Here we will discuss in details "Metacharacters " and how to perform complex searches easily using regular expressions. The series will cover 1.REGEXP_LIKE 2.REGEXP_SUBSTR 3.REGEXP_INSTR 4.REGEXP_REPLACE 5.REGEXP_COUNT with main focus 1,2 and 4. In this video tutorial I have added 12 problems and I will be posting the solutions in the next video tutorials.
Views: 153 Tech Coach
Oracle regular expression regexp instr
 
06:58
Oracle SQL PLSQL and Unix Shell Scripting
Views: 1752 Sridhar Raghavan
Oracle regular expression regexp count
 
03:31
Unix Shell Scripting
Views: 1394 Sridhar Raghavan
2.5: Regular Expressions: Back References - Programming with Text
 
04:04
In this short tutorial, I explain the concept of "back references" and explore how they are used to match the characters previously matched by capturing parentheses (groups) in a regular expression (regex). This is the fifth video in a series on Regular Expressions, which is part of the "Programming from A to Z" course at ITP (http://itp.nyu.edu). Next Video: https://youtu.be/W7S_Vmq0GSs http://shiffman.net/a2z/regex/ Course url: http://shiffman.net/a2z/ Support this channel on Patreon: https://patreon.com/codingtrain Send me your questions and coding challenges!: https://github.com/CodingTrain/Rainbow-Topics Contact: https://twitter.com/shiffman GitHub Repo with all the info for Programming from A to Z: https://github.com/shiffman/A2Z-F16 Links discussed in this video: MDN's Regular Expressions Reference: https://developer.mozilla.org/en/docs/Web/JavaScript/Guide/Regular_Expressions Regular Expressions on Wikipedia: https://en.wikipedia.org/wiki/Regular_expression Book Mastering Regular Expressions: http://shop.oreilly.com/product/9780596528126.do ITP from Tisch School of the Arts: https://tisch.nyu.edu/itp Source Code for the all Video Lessons: https://github.com/CodingTrain/Rainbow-Code p5.js: https://p5js.org/ Processing: https://processing.org For More Programming from A to Z videos: https://www.youtube.com/user/shiffman/playlists?shelf_id=11&view=50&sort=dd For More Coding Challenges: https://www.youtube.com/playlist?list=PLRqwX-V7Uu6ZiZxtDDRCi6uhfTH4FilpH Help us caption & translate this video! http://amara.org/v/VvIt/
Views: 22943 The Coding Train
Oracle sql 12c Decode regular expression
 
03:35
Decode regular expression in Oracle sql 12c
Views: 179 AnimatedWorld
Oracle Big Data Preparation Cloud Service: Using Regular Expressions
 
01:13
Learn to use regular expressions to extract information and store it in a new column using Oracle Big Data Preparation Cloud Service. ================================= For more information, see http://www.oracle.com/goto/oll 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.
Regular Expressions in oracle part 2/ Arabic
 
11:42
Regular Expressions in oracle part 2/ Arabic -- we use Regexp to search/ match / replace string --1 Regexp_like --2 Regexp_replace --3 Regexp_instr --4 Regexp_substr --5 Regexp_count --note we can user Regexp with CHAR/Varchar2/clob but not LONG
Views: 544 khaled alkhudari
Oracle Regular Expressions
 
14:57
Oracle Regular Expressions
Views: 46 Nook Tutorials
Oracle Sql SELECT statement & Drl command ,where clause, Arithmetic Expressions
 
14:46
SQL Where clause with example on Oracle 11g Database -Oracle Sql Arabic Course Basic SELECT statement & Arithmetic Expressions اوراكل ديفيلوبر SQL tutorial 49: CASE - Simple Case Expression in Oracle Database The WHERE Clause: Case Sensitivity and Collations ORACLE 11g Course Details - Using TOAD (Tool For Oracle Application Development) in training ... Clause; Comparison and conditional operations; Arithmetic and logical operations ... Using group by and having clause of DRL statement ... Understanding the practical approach to sub queries/nested select/sub select/inner ... SQL Editor commands Oracle 12C /Oracle12C-Wilson.asp About SQL&SQL*PLUS; Constraints; Normalization and De-Normalization; ER Diagrams ... Working with DML, DRL Commands; Operators Support. DML-Insert, update, delete; DQL-SELECT Statements using WHERE clause; Comparison and Conditional Operators; Arithmetic and Logical Operators; Set Operators (UNION, ... [PDF]Oracle SQL(Structured Query Language) www.isashitsolution.com/pdf/ORACLE.pdf. Oracle. SQL(Structured Query Language) ... Working with DML, DRL Commands. • Operators Support. Build In Function. • Arithmetic Functions, Character Functions, ... Grouping the Result of a Query. • Using Group by and Having Clause of DRL. Statement ... Using VIEWS for DML Operations. SQL select statement and functions - Nov 20, 2013 - SQL Statements ... SQL as the standard language Oracle SQL complies with ... SQL Statements DRL - Retrieves data from the database DML ... If any column value in an arithmetic expression is null, the result is null. .... The DUAL table is generally used for SELECT clause syntax ... [PDF]SQL Basics & PL-SQL - SQL School sqlschool.com/downloads/PLSQL-Training-SQLSchool.pdf SQL Basics & Oracle PL/SQL Developer Training. All Our Training ... COMMANDS. ✓ Structured Query Language (SQL) Basics ... Returning into clause, Bulk Collect. ✓ For All ... Recycle Bin, Regular Expressions in PLSQL ... DML Command DRL Commands Operators. ✓ INSERT ... Arithmetic and Logical Operators. Operators in SQL.... - PL/SQL-Developer plsql/2011/10/operators-in-sql.html Oct 26, 2011 - If we select the data using select statement from dual ... Arithmetic Operators are used to perform arithmetic operations on numeric ... This is the syntax for using the IN operator. ... Unlike In condition where we will match selective multiple values, we will match .... SQL Statements Part3 (DRL,TCL and DCL). learn oracle - Curly Brackets learn-oracle/ Oracle Pre Defined Data types; DDL Commands; Create, Alter (add, modify, rename, ... Arithmetic Functions, Character Functions, Date Functions, Conversion ... a Query. Using Group by and Having Clause of DRL Statement; Using Order by clause ... Understanding the practical approach to Sub Queries/Nested Select/Sub ... Oracle PL-SQL - SequelGate oracle-plsql-training.html Arithmetic Functions; Character Functions; Date functions; Conversion Functions ... Using Group by and Having Clause of DRL Statement; Using Order by clause ... CASE expression of Select Command, Temporary Tables/Global Tables; New ... : DRL, DDL, DML, TCL and DCL commands /2014/12/drl-ddl-dml-tcl-and-dcl-commands.html DRL, DDL, DML, TCL and DCL commands. DRL (Data Retrieval Language):. Select. DDL (Data Definition Language):. Create. Alter. Drop. Truncate. Missing: expressions SQL Count - Wikitechy https://www.wikitechy.com/tutorials/sql/sql-count Tags : sql tutorial , pl sql tutorial , mysql tutorial , oracle tutorial , learn sql , sql server tutorial. Syntax ... expression can be a column name, an arithmetic operation, or a star . ... In addition to the COUNT function in the SELECT statement. In those cases, these columns need to be part of the GROUP BY clause as well
Views: 45 Muo sigma classes
Oracle regular expression part 2 extracting substring regexp substr
 
08:11
Oracle SQL PLSQL and Unix Shell Scripting
Views: 4707 Sridhar Raghavan
Regular Expressions in oracle part 3/ Arabic
 
10:39
-- we use Regexp to search/ match / replace string --1 Regexp_like --2 Regexp_replace --3 Regexp_instr --4 Regexp_substr --5 Regexp_count --note we can user Regexp with CHAR/Varchar2/clob but not LONG https://docs.oracle.com/cd/B12037_01/server.101/b10759/functions116.htm#SQLRF06303 http://psoug.org/reference/regexp.html
Views: 482 khaled alkhudari
Oracle regular expression part 3 replace a substring regexp replace
 
06:00
Oracle SQL PLSQL and Unix Shell Scripting
Views: 2761 Sridhar Raghavan
0614 Finding Text With Regular Expressions
 
05:12
PHP is one of the leading technical web building education . Its very simple and easy to learn. Here we are showing 1 PHP Uses 2 PHP Installation 3 PHP Development 4 PHP using with PL/Sql 5 Pl/Sql Installation 6 Create and using Database using Oracle etc are shown in this video Thanks for watching
Views: 13 PHP 2015 Tutorial
16/125 Oracle PLSQL: Case Statement VS Case Expression
 
13:06
Learn Oracle PLSQL EXAM 1Z0-144
Views: 1430 khaled alkhudari
Oracle Regular Expression - Part II
 
06:02
This continues discussion on Oracle Regular Expression
Views: 2700 Mohan Ramaswamy
Oracle Regular Expression - PartIII
 
05:44
Oracle Regular Expression
Views: 573 Mohan Ramaswamy
Oracle SQL - Regular Expression Support
 
56:48
Поддержка регулярных выражений в Oracle SQL, лекция
Views: 408 Aleksandr Kuzmin
Oracle 18C New Feature : PLSQL Qualified expression
 
07:48
Oracle 18C New Feature : PLSQL Qualified expression
Views: 411 Siva Academy
26. SQL for Beginners - REGEXP_SUBSTR( ) (Hindi) | Regular Expressions
 
10:04
PL/SQL Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY1I1I8ACgWYjI5WyFlV4Nin SQL Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2q8cobbotVbn36XOskQR2F JavaScript Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2tLfvp7bCL3c-psMH9Czs6 HTML5 Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2_-PqGSrVTgBpVshxpqQlw Mobile Responsive Form using HTML5 & CSS: https://youtu.be/SECTfL3R0B0 MS SQL Server Installation: https://youtu.be/rZRA692RmuU Clock Animation in PowerPoint : https://youtu.be/LM5iwzNqQQo Envelope Animation in PowerPoint : https://youtu.be/HWlqGGleQqs FACEBOOK PAGE https://www.facebook.com/ishwaracademy/
Views: 160 Ishwar Academy
Regular Expression Part 5
 
09:26
au
Views: 3089 Oresoft LWC
RegEx Basics, Regular Expressions for Beginners
 
17:01
Hi and welcome to this beginners course on regular expressions. This knowledge is a must for any developer or IT professional. Today regex support is included in all large programming languages, although there might be some differences from language to language the basics are the same and that is what we are going to look at this course. link to the full course: http://virtualcallback.teachable.com/courses/regex-regular-expressions-for-beginners
Views: 25641 VirtualCallback
Regular Expressions (RegEx) Tutorial #5 - Repeating Characters
 
04:39
Hey all, in this RegEx tutorial I'll show you how wecan easily repeat characters in a pattern, rather than write tem all out by hand. DONATE :) - https://www.paypal.me/thenetninja ----- COURSE LINKS: + RegEx101 - https://regex101.com/ + Course files - https://github.com/iamshaunjp/regex-playlist + Atom editor - https://atom.io/a + CMDER - http://cmder.net/ ======== Other Tutorials ========= ----- NODE.JS TUTORIALS https://www.youtube.com/playlist?list=PL4cUxeGkcC9gcy9lrvMJ75z9maRw4byYp ----- MONGODB TUTORIALS https://www.youtube.com/playlist?list=PL4cUxeGkcC9jpvoYriLI0bY8DOgWZfi6u ----- SUBSCRIBE TO CHANNEL - https://www.youtube.com/channel/UCW5YeuERMmlnqo4oq8vwUpg?sub_confirmation=1 ======== Social Links ========== Twitter - @TheNetNinja - https://twitter.com/thenetninjauk Patreon - https://www.patreon.com/thenetninja
Views: 10458 The Net Ninja
MySQL Database Tutorial - 15 - Regular Expressions
 
07:33
Facebook - https://www.facebook.com/TheNewBoston-464114846956315/ GitHub - https://github.com/buckyroberts Google+ - https://plus.google.com/+BuckyRoberts LinkedIn - https://www.linkedin.com/in/buckyroberts reddit - https://www.reddit.com/r/thenewboston/ Support - https://www.patreon.com/thenewboston thenewboston - https://thenewboston.com/ Twitter - https://twitter.com/bucky_roberts
Views: 116309 thenewboston
25. SQL for Beginners - REGEXP_LIKE( ) Condition (HIndi) | Regular Expressions
 
26:17
PL/SQL Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY1I1I8ACgWYjI5WyFlV4Nin SQL Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2q8cobbotVbn36XOskQR2F JavaScript Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2tLfvp7bCL3c-psMH9Czs6 HTML5 Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2_-PqGSrVTgBpVshxpqQlw Mobile Responsive Form using HTML5 & CSS: https://youtu.be/SECTfL3R0B0 MS SQL Server Installation: https://youtu.be/rZRA692RmuU Clock Animation in PowerPoint : https://youtu.be/LM5iwzNqQQo Envelope Animation in PowerPoint : https://youtu.be/HWlqGGleQqs FACEBOOK PAGE https://www.facebook.com/ishwaracademy/
Views: 120 Ishwar Academy
Regular Expressions - Episode 1 - Introduction
 
10:55
Welcome to the Software Carpentry lecture on regular expressions. In order to understand what regular expressions are for, let's have a look at the sort of cleanup job that comes up frequently when dealing with real field data. Visit the Software Carpentry page for this episode at: http://software-carpentry.org/4_0/regexp/intro
Views: 72424 softwarecarpentry
09 MySQL Tutorial for Beginners: LIKE + REGEXP Operators, Regular Expressions
 
09:12
You use the LIKE operator to retrieve rows that match a string pattern. The Mask for a LIKE phrase can contain special symbols called "wildcards". Masks aren't case-sensitive. In contrast to the LIKE operator, the REGEXP operator allows you to create complex string patterns known as regular expressions. The mask for a REGEXP phrase can contain special characters and constructs like: - the "caret" (^) symbol matches the pattern to the beginning of the value being tested. - The "dollar sign" ($) symbol matches the pattern to the end of the value being tested. - The "pipe" (|) symbol separates two string patterns and matches either one. - "Square brackets" [] are used to specify multiple values. lf you use the NOT keyword, only those rows with values that don't match the string pattern are included in the result set. EXERCISES for your SELF-TRAINING: http://golearnfast.com/Quizzes.php?_SelectSmallerGroup_286=0&Lessons_ID=286 SCRIPT FOR THE EXAMPLES: http://www.golearnfast.com/files/lessons_material/lesson_277_1440544998.sql SUBSCRIBE! https://www.youtube.com/channel/UCMEaGDoHU7c9tWyafZ9vC6Q?sub_confirmation=1 FACEBOOK https://www.facebook.com/golearnfast GOOGLE+ https://plus.google.com/u/0/b/101326338689489366802/
Views: 3580 golearnfast
Regex Phone Number - Step by Step
 
09:15
This is the basics of a phone number regex to just help you understand how to write regex in general VIDEO CORRECTION!! The end of the regex needs to be a $ not a ? ^\+?\d.\s? // +1 or +44 \(?\d{3}\)? // first part [-.\s]? // possible spacing / sep \d{3} // 2nd part [-.\s]? // possible spacing / sep \d{4}? // 3rd part
Views: 21237 optikalefx
28. SQL for Beginners - REGEXP_REPLACE( ) (Hindi) | Regular Expressions
 
08:30
PL/SQL Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY1I1I8ACgWYjI5WyFlV4Nin SQL Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2q8cobbotVbn36XOskQR2F JavaScript Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2tLfvp7bCL3c-psMH9Czs6 HTML5 Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2_-PqGSrVTgBpVshxpqQlw Mobile Responsive Form using HTML5 & CSS: https://youtu.be/SECTfL3R0B0 MS SQL Server Installation: https://youtu.be/rZRA692RmuU Clock Animation in PowerPoint : https://youtu.be/LM5iwzNqQQo Envelope Animation in PowerPoint : https://youtu.be/HWlqGGleQqs FACEBOOK PAGE https://www.facebook.com/ishwaracademy/
Views: 142 Ishwar Academy
Oracle Database 12c: SQL Pattern Matching
 
43:41
The new groundbreaking SQL pattern matching capabilities brings the simplicity and efficiency of the most common data analysis language to the process of identifying patterns within a data set. It provides a completely new native SQL syntax that has adopted the regular expression capabilities of Perl by implementing a core set of rules to define patterns in sequences (streams of rows). In this first session will explore some of the main concepts and key words of the new syntax. Subsequent sessions will explore typical use cases for SQL pattern matching and how to debug your pattern matching process.
REGEX Tutorial Regular Expressions
 
11:54
Best Regular Expressions Book : http://goo.gl/RFX7eJ Here I explain how Regular Expressions are used. I cover all of the codes and what they are used for. The goal is to teach you how to use regular expressions once and for all.
Views: 334108 Derek Banas
Using postgres regexp_replace to clean text data
 
07:12
Sometimes you need to remove characters or clean data before you extract it. Regexp_replace is a very useful function. We cover it in some detail including some details about word boundaries along with flags.
Views: 1259 Jeffrey James
0615 Finding Simple Patterns Using Regular Expressions
 
08:00
PHP is one of the leading technical web building education . Its very simple and easy to learn. Here we are showing 1 PHP Uses 2 PHP Installation 3 PHP Development 4 PHP using with PL/Sql 5 Pl/Sql Installation 6 Create and using Database using Oracle etc are shown in this video Thanks for watching
Views: 20 PHP 2015 Tutorial
WildCard Character Regular expressions
 
04:40
Our Very first meta character that we will learn in Regex is (.) yes, simply a dot. It matches anything except new line character. https://www.LearnCodeOnline.in fb: https://www.facebook.com/HiteshChoudharyPage homepage: http://www.hiteshChoudhary.com Download LearnCodeOnline.in app from Google play store and Apple App store
Views: 2948 Hitesh Choudhary
Oracle Database11g tutorials 13 || SQL substr function / SQL substring function
 
06:34
link of SQL substr blog : http://www.rebellionrider.com/SQL-substr-function.htm SQL substr function SQL Substr function will return a sub string of a specified length from the source string beginning at a given position. Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ---------------------------------------------------------------------------- As the name suggests SQL Substr function will return substring from a given source string. Let's see the Syntax Substr (source_string, start_pos, Substr_length) As we can see SQL substr function takes 3 parameters. First one is Source string from which you want to extract the segment. Second parameter is Starting position for sub string from the Source string. And the third parameter is Substr_length which is the length for the substring. First two parameters are mandatory to specify while third one is optional. So we can say. SQL Substr function will return a sub string of a specified length from the source string beginning at a given position. First parameter source string can be of any data type CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB whereas both start_pos, Substr_length parameters must be number data type. The returning result of SQL Substr function is of same data type of source string. Let's see an example of SQL Substr function. SELECT substr('www.RebellionRider.com',5,14) FROM dual; Here in this query url of my website www.RebellionRider.com is our source string with the total length of 22 characters, Now, I want to extract the name of my website that is, RebellionRider. So if you count the total length of the name of the website, it is 14. That's why I have specified 14 as my third parameter of SQL Substr function which is substr_length. Also the name of the website RebellionRider is starting from 5th position therefore I have specified 5 at second parameter of SQL substr function which is strt_pos or starting position. Execute it. Here is our result RebellionRider When starting position is larger than the length of source string. In this case SQL Substr function will return NULL as a result. Let's do an example. SELECT substr('www.RebellionRider.com',23,14) FROM dual; As you can see here I have specified 23 at starting position and the total length of our source string is 22 characters Let's execute And the result is Null. Second scenario When the Substr_length is greater than source string In this case the segment return is the substring from starting position to the end of the string. For example SELECT substr('www.RebellionRider.com',5,23) FROM dual; Our starting position is at 5 means at the first R of RebellionRider and length of substring is set to 23 which is greater than the length of source string that is 22. Execute. As you can see we get a substring from first R of RebellionRider till the end of the source String. Third scenario When you supply numeric or arithmetic expression or a DATE instead of character as Source string to SQL Substr function In this scenario If you have supplied a numeric string instead of character as source string, the oracle engine casts them as a character when they occur as parameter to SQL Substr function. And if you have supplied Arithmetic expression or a DATE then The Oracle engine first solves or evaluates the Arithmetic expression or the DATE Then casts them as a character. Means if you have arithmetic expression in your source string then oracle will first solve it and then change or say cast the value of its result into character. Let's see some example. SELECT substr(50000-7,2,4) FROM dual; Oracle first evaluates the arithmetic expression that is 50000-7 equals to 49993. And then oracle engine casts this result 49993 into a character string. Means 49993 will be a 5 characters string. Starting position of substring is 2, that means from the first 9 of 49993 We specified the length of substring is 4 so we must get 9993 as our result. Let's check execute
Views: 80651 Manish Sharma
Core Java With OCJP/SCJP-Regular Expressions-Part 1
 
25:57
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
29. SQL for Beginners - REGEXP_COUNT( ) (Hindi) | Regular Expressions
 
03:26
PL/SQL Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY1I1I8ACgWYjI5WyFlV4Nin SQL Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2q8cobbotVbn36XOskQR2F JavaScript Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2tLfvp7bCL3c-psMH9Czs6 HTML5 Playlist: https://www.youtube.com/playlist?list=PLysly0KYnAY2_-PqGSrVTgBpVshxpqQlw Mobile Responsive Form using HTML5 & CSS: https://youtu.be/SECTfL3R0B0 MS SQL Server Installation: https://youtu.be/rZRA692RmuU Clock Animation in PowerPoint : https://youtu.be/LM5iwzNqQQo Envelope Animation in PowerPoint : https://youtu.be/HWlqGGleQqs FACEBOOK PAGE https://www.facebook.com/ishwaracademy/
Views: 84 Ishwar Academy
Regular Expressions (RegEx) Tutorial #3 - Character Sets
 
05:00
Hey gang, in this RegEx tutorial I'll talk about Character Sets, and how we can use them to match a variety of different characters within the same position. DONATE :) - https://www.paypal.me/thenetninja ----- COURSE LINKS: + RegEx101 - https://regex101.com/ + Course files - https://github.com/iamshaunjp/regex-playlist + Atom editor - https://atom.io/a + CMDER - http://cmder.net/ ======== Other Tutorials ========= ----- NODE.JS TUTORIALS https://www.youtube.com/playlist?list=PL4cUxeGkcC9gcy9lrvMJ75z9maRw4byYp ----- MONGODB TUTORIALS https://www.youtube.com/playlist?list=PL4cUxeGkcC9jpvoYriLI0bY8DOgWZfi6u ----- SUBSCRIBE TO CHANNEL - https://www.youtube.com/channel/UCW5YeuERMmlnqo4oq8vwUpg?sub_confirmation=1 ======== Social Links ========== Twitter - @TheNetNinja - https://twitter.com/thenetninjauk Patreon - https://www.patreon.com/thenetninja
Views: 12995 The Net Ninja
Regular Expressions in MySQL
 
06:12
SYS 2004 video project. Brief intro on how to use regular expressions in mySQL.
Views: 3530 IZCEKOWLD
Regular Expression | a^n b^ n where n+m is even, odds, at least exactly length string | TOC | 077
 
03:14
theory of computation, Automata Theory, in hindi, lectures, gate, iit, tutorial, regular expression a^n b^ n where n+m is even, n+m is odds, regular expression in automata examples, regular expression in automata ppt, regular expression in automata theory regular expression in automata theory ppt regular expression examples in theory of automata regular expressions finite language automata theory finite automata and formal languages regular expression php regular expression in sql regular expression in oracle regular expression in java regular expression meaning regular expression in automata regular expression in javascript regular expression for password
Views: 10282 Gate Instructors
Getting Started with PL/SQL Table Functions: Pipelined Table Functions
 
14:49
Pipelined table functions are table functions in which rows are returned or "piped" back to the calling query before the function has completed, avoiding the blocking behavior of normal PL/SQL functions and reduce PGA consumption. This video is part of the Oracle Dev Gym class "Getting Started with Table Functions". You can watch it independent of the class, but then you miss out on the tutorials and quizzes! So visit https://devgym.oracle.com/pls/apex/dg/class/getting-started-with-pl-sql-table-functions.html and register for the class! ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2018 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
SQL Server Regular Expression Search
 
01:19
This video will explain how to remove blank lines in SQL Server
Views: 727 SQL Server