Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 32 views

    11 - 10 - 9 - 8 - 7 - 6 - 5 - 4 - 3 - 2 - 1 J A Y A P R A K A S H 1 2 3 4 5 6 7 8 9 10 11 L R SELECT 'Jayaprakash' FROM Dual

    Uploaded by

    redro
    This document provides examples of using the SUBSTR function in Oracle SQL to extract substrings from a string. It shows how SUBSTR can extract characters starting from position 0 for a length of 4 to return 'Jaya'. Another example starts at position 4 with a length of 4 to return 'prak'. The last example starts from the -4 position for a length of 5 to return 'prakash'.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd

    11 - 10 - 9 - 8 - 7 - 6 - 5 - 4 - 3 - 2 - 1 J A Y A P R A K A S H 1 2 3 4 5 6 7 8 9 10 11 L R SELECT 'Jayaprakash' FROM Dual

    Uploaded by

    redro
    32 views1 page
    This document provides examples of using the SUBSTR function in Oracle SQL to extract substrings from a string. It shows how SUBSTR can extract characters starting from position 0 for a length of 4 to return 'Jaya'. Another example starts at position 4 with a length of 4 to return 'prak'. The last example starts from the -4 position for a length of 5 to return 'prakash'.

    Original Description:

    SUB STRING

    Original Title

    SubStr

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides examples of using the SUBSTR function in Oracle SQL to extract substrings from a string. It shows how SUBSTR can extract characters starting from position 0 for a length of 4 to return 'Jaya'. Another example starts at position 4 with a length of 4 to return 'prak'. The last example starts from the -4 position for a length of 5 to return 'prakash'.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    32 views1 page

    11 - 10 - 9 - 8 - 7 - 6 - 5 - 4 - 3 - 2 - 1 J A Y A P R A K A S H 1 2 3 4 5 6 7 8 9 10 11 L R SELECT 'Jayaprakash' FROM Dual

    Uploaded by

    redro
    This document provides examples of using the SUBSTR function in Oracle SQL to extract substrings from a string. It shows how SUBSTR can extract characters starting from position 0 for a length of 4 to return 'Jaya'. Another example starts at position 4 with a length of 4 to return 'prak'. The last example starts from the -4 position for a length of 5 to return 'prakash'.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    of 1

    -11 -10 -9 -8 -7 -6 -5 -4 -3 -2 -1

    J A Y A P R A K A S H
    1 2 3 4 5 6 7 8 9 10 11

    L >>>>>>R
    SELECT 'Jayaprakash' FROM dual;

    SYNTAX:
    SELECT SUBSTR(col/Exp, M,[N]) FROM dual;
    --> N -- counts from left to right only
    SELECT SUBSTR('Jayaprakash',0,4) FROM dual;

    SELECT SUBSTR('Jayaprakash',4,4) FROM dual;

    SELECT SUBSTR('Jayaprakash',-4,5) FROM dual;

    You might also like