Oracle 怎样实现获取类似值(A,B,...,Z,AA,AB,.,AZ,BA,BB,...BZ,.客户要求某一字段的取值为这种形式:A,B,...,Z,AA,AB,.,AZ,BA,BB,...BZ,.,要怎么实现比较好?需要用到哪些函数?还望大神指导一番,现有系统中,
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/30 22:48:12
![Oracle 怎样实现获取类似值(A,B,...,Z,AA,AB,.,AZ,BA,BB,...BZ,.客户要求某一字段的取值为这种形式:A,B,...,Z,AA,AB,.,AZ,BA,BB,...BZ,.,要怎么实现比较好?需要用到哪些函数?还望大神指导一番,现有系统中,](/uploads/image/z/4018234-58-4.jpg?t=Oracle+%E6%80%8E%E6%A0%B7%E5%AE%9E%E7%8E%B0%E8%8E%B7%E5%8F%96%E7%B1%BB%E4%BC%BC%E5%80%BC%EF%BC%88A%2CB%2C...%2CZ%2CAA%2CAB%2C.%2CAZ%2CBA%2CBB%2C...BZ%2C.%E5%AE%A2%E6%88%B7%E8%A6%81%E6%B1%82%E6%9F%90%E4%B8%80%E5%AD%97%E6%AE%B5%E7%9A%84%E5%8F%96%E5%80%BC%E4%B8%BA%E8%BF%99%E7%A7%8D%E5%BD%A2%E5%BC%8F%EF%BC%9AA%2CB%2C...%2CZ%2CAA%2CAB%2C.%2CAZ%2CBA%2CBB%2C...BZ%2C.%2C%E8%A6%81%E6%80%8E%E4%B9%88%E5%AE%9E%E7%8E%B0%E6%AF%94%E8%BE%83%E5%A5%BD%3F%E9%9C%80%E8%A6%81%E7%94%A8%E5%88%B0%E5%93%AA%E4%BA%9B%E5%87%BD%E6%95%B0%3F%E8%BF%98%E6%9C%9B%E5%A4%A7%E7%A5%9E%E6%8C%87%E5%AF%BC%E4%B8%80%E7%95%AA%2C%E7%8E%B0%E6%9C%89%E7%B3%BB%E7%BB%9F%E4%B8%AD%2C)
Oracle 怎样实现获取类似值(A,B,...,Z,AA,AB,.,AZ,BA,BB,...BZ,.客户要求某一字段的取值为这种形式:A,B,...,Z,AA,AB,.,AZ,BA,BB,...BZ,.,要怎么实现比较好?需要用到哪些函数?还望大神指导一番,现有系统中,
Oracle 怎样实现获取类似值(A,B,...,Z,AA,AB,.,AZ,BA,BB,...BZ,.
客户要求某一字段的取值为这种形式:A,B,...,Z,AA,AB,.,AZ,BA,BB,...BZ,.,要怎么实现比较好?需要用到哪些函数?还望大神指导一番,
现有系统中,表test中记录较少,mapcode字段的值为:A,B,C,D,.,Q.
需求:按字母顺序追加,如果到Z满了则AA,AB…AZ,BA,BB…规则类推至ZZ.
Oracle 怎样实现获取类似值(A,B,...,Z,AA,AB,.,AZ,BA,BB,...BZ,.客户要求某一字段的取值为这种形式:A,B,...,Z,AA,AB,.,AZ,BA,BB,...BZ,.,要怎么实现比较好?需要用到哪些函数?还望大神指导一番,现有系统中,
declare
i int;
j int;
begin
for i in 65..90 loop --得到字母A-Z,如果只需要Q后面的,把65换为82
insert into test (mapcode) values (chr(i));
end loop;
for i in 65..90 loop
for j in 65..90 loop
insert into test (mapcode) values (chr(i)||chr(j));
end loop;
end loop;
end;
/
commit;