HowtosplitvarcharcolumninOracleinthreecolumns我有一个可以容纳120个字符的地址字段,需要将它分成三个不同的列,每列40个字符长。示例:123Tablename:AddressColumnname:Street_AddressSelectStreet_Address *fromAddress输出:123MainStNorthPoleFactory44,neartherearentrancecrossthestreetandturnleftandkeepwalkingstraight.我需要把这个地址拆分成address_1address_2和addr