oracle right two digits
Solutions on MaxInterview for oracle right two digits by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "oracle right two digits"
Elena
16 Oct 2019
1-- ORACLE SQL - Get the 2 digits at the right end of a string
2SELECT SUBSTR('TN0001234567890345',-2) FROM DUAL;
3similar questions
oracle convert run duration to numberoracle count characters in stringhow to convert number to hours and minutes in oracle sqloracle exchange subpartitionoracle current date plus 1 monthoracle sequence last numberoracle list days between two datesoracle index size calculationminus oracle exempleoracle convert run duration to numbervarchar2 length in oracleoracle right charactersoracle sql all days except weekendsoracle to char number format percentageoracle number to percentagehow to know the character set of an oracle databesoracle run duration to numberoracle add monthoracle difference between two dates in yearsoracle sql roundhow to calculate number of days between two dates excluding weekends in oracleoracle current sequence valueoracle current date minus 1 daycreate sequence in oracle 12coracle all dates between two datesoracle leftmost characters your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful