Tutorial#42 INSTR function in Oracle SQL Database| How to find position of substring

Показать описание

The Oracle INSTR function allows you to search a string for the occurrence of another string, and return the position of the occurrence within a string or find all occurrences of a substring in a string SQL or SQL find a character in a string or how to make use of Instr function or what is INSTR function in Oracle

Assignment link:

In this series we cover the following topics:
SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator.

follow me on:
Facebook Page:

Contacts Email:

Instagram:

Twitter:

#OracleSQLInstrFunction #SQLFunction #FreeMaterialForSQL

Рекомендации по теме

Комментарии

from right to left counting -15 is zero hence second occurrence is '0'

Nice Video sir, very interesting :)

hrushinathkale

teaching in a great way... Easily understood with ur teachings..

mvchannel

thanks a lot for such useful explanation. you are great teacher Sir.

Eao

I need answer for tev sir and corporate floor (3, 2) output 14 then corporate floor for (-3, 2)output is 5 and this is the thing output is 9.. Kindly confirm sir.. And pls explain if there any mistakes from my side..sir

shamyumanoharan

Good explanation it helped me in revision do video on nvl sir

atkuriajaykumar

Hi sir
Please explain the answer the 2nd question

Arunachalaraman

What is the o/p for corporate floor?when it is - 15?

shamyumanoharan

If you set the 3rd argument to 15 then the result will be 0, because the start position is the very last character, and the database does not know where to count, so it returns 0.

cahn

Wht is the output for rakesh malviya sir?

shamyumanoharan

Tutorial#42 INSTR function in Oracle SQL Database| How to find position of substring

Tutorial#42 INSTR function in Oracle SQL Database| How to find position of substring

INSTR in Oracle | INSTRING in Oracle | Character Manipulation | Oracle Tutorial for Beginners

Oracle INSTR Function

Just know How Instr() Function Works in Oracle - #instrfunction #oracle #stringfunction

25. how to use INSTR function in SQL

Using INSTR Function

SUBSTR and INSTR Functions in Oracle Database

Oracle SQL dərsləri - 42. AGGREGATE functions in ORACLE SQL

Oracle LTRIM Function

Oracle Tutorial for Substr and Instr functions

Oracle RPAD Function

Oracle LPAD Function

Oracle Tutorial - Character Manipulation Function INSTR

Substr and Instr in Oracle|Extracting data from String

oracle substr function

How to use SQL SUBSTR function| How to use SQL INSTR function | Oracle Tutorial for Beginners

SUBSTR() and INSTR() Functions in Oracle | SUBSTR and INSTR Functions | Oracle SQL Tutorial

Oracle SUBSTR and INSTR example

Oracle GREATEST Function

Oracle|Sql Function | Substr | instr

Oracle- SUBTR, INSTR, TRIM, REPLACE....etc

SUBSTR in Oracle | SUBSTRING in Oracle | Character Manipulation | Oracle Tutorial for Beginners

4. Functioning of SUBSTR( ) , INSTR( ) and NVL( ) functions in Oracle

BI Publisher - Using Nested XSL Functions (Instr & Substr)