orcale 截取

 orcale 截取点后边的

SELECT SUBSTR(column_name, INSTR(column_name, '.') + 1) AS extracted_part FROM table_name;

 orcale 截取点前边的

SELECT SUBSTR(column_name, 0, INSTR(column_name, '.') - 1) AS extracted_part FROM table_name;