我用concat()函数做雇员要3倍薪水的练习,不知道哪里错了,如下
SQL> select concat(last_name,"earns",to_char(salary,'fm$999,999.00'),"monthly but wants",to_char(salary*3,'fm$999,999.00')) as "Dream Salary" from employees;
select concat(last_name,"earns",to_char(salary,'fm$999,999.00'),"monthly but wants",to_char(salary*3,'fm$999,999.00')) as "Dream Salary" from employees
ORA-00909: 参数个数无效