写个function:create or replace pf( sal in number)
return varchar2 is
lv number(5);
lvStr
begin
for lv in 0..sal/100 loop
lvstr :=lvstr +'*'
end loop;
end;sql> select ename, pf(sal) from emp;
return varchar2 is
lv number(5);
lvStr
begin
for lv in 0..sal/100 loop
lvstr :=lvstr +'*'
end loop;
end;sql> select ename, pf(sal) from emp;
ENAME
----------
SALARY
------------------------------------FORD
*****************************SMITH
*******SCOTT
*****************************
ENAME
----------
SALARY
------------------------------------ADAMS
**********
13 rows selected.
我希望的样子像这样SQL> select ename, sal/100 salary from emp;ENAME SALARY
---------- ----------
KING 50
MILLER 13
BLAKE 28.5
CLARK 24.5
JONES 29.75
05TIN 12.5
ALLEN 16
TURNER 15
WARD 12.5
FORD 30
SMITH 8ENAME SALARY
---------- ----------
SCOTT 30
ADAMS 1113 rows selected.