sql生成九九乘法表代码,PLSQL代码库,德仔网

代码语言

代码分类

【PLSQL】 sql生成九九乘法表

作者:汶纡 / 发布于2014/11/20/ 1218


	with t as (select level as n from dual connect by level <=9)
	select sys_connect_by_path(b.n || '*' || a.n || '=' || a.n * b.n, ' ') as multiplytable
	from t a, t b
	where a.n >= b.n and level = a.n
	start with b.n=1
	connect by prior a.n=a.n and prior b.n+1=b.n;

　　

试试其它关键字

　九九乘法表　

同语言下

可能有用的

汶纡贡献的其它代码(55)

Copyright © 2004 - 2024 dezai.cn. All Rights Reserved 站长博客粤ICP备13059550号-3