- 注册时间
- 2009-7-21
- 最后登录
- 1970-1-1
- 威望
- 星
- 金币
- 枚
- 贡献
- 分
- 经验
- 点
- 鲜花
- 朵
- 魅力
- 点
- 上传
- 次
- 下载
- 次
- 积分
- 4489
- 在线时间
- 小时
|
楼主 |
发表于 2009-10-17 10:17:16
|
显示全部楼层
居然只有1个解,也就是最大解
create table cc as
with t1 as
(select level l from dual connect by level<=10),
tmp as
(select level*level s from dual connect by level<1E5)
,
tmp2 as
(select s,substr(s,l,1),count(*)cnt from tmp,t1
where l<=length(s)
group by s,substr(s,l,1)
),
tmp3 as
(select s from tmp2 having max(cnt)=1
group by s)
select * from tmp3;
col s for 9999999999
col s1 for a10
col s2 for a10
col s3 for a10
col s4 for a10
with t1 as
(select level l from dual connect by level<=10),
tn as
(select t1.l t1l,t2.l t2l,t3.l t3l from t1,t1 t2,t1 t3
where t1.l>1 and t1.l col s for 9999999999
SQL> col s1 for a10
SQL> col s2 for a10
SQL> col s3 for a10
SQL> col s4 for a10
SQL>
SQL> with t1 as
2 (select level l from dual connect by level<=10),
3 tn as
4 (select t1.l t1l,t2.l t2l,t3.l t3l from t1,t1 t2,t1 t3
5 where t1.l>1 and t1.l select 945*945 from dual;
945*945
----------
893025 |
|