i have string value as "ORA_Sampl_34_20120530_123456.txt" from this string i want to get output as "34" using sql query.i have string value as "ORA_Sampl_34_20120530_1
i have string value as "ORA_Sampl_34_20120530_123456.txt" from this string i want to get output as "34" using sql query.i have string value as "ORA_Sampl_34_20120530_1