/SQL/Alling a function from PL/SQL in a select statement in ORACLE

Alling a function from PL/SQL in a select statement in ORACLE

DECLARE
  em_sal NUMBER(20);
  em_comm employees.commission_pct%type;
  annual_salary NUMBER(10,4);
BEGIN
  SELECT salary INTO em_sal FROM employees WHERE employee_id=149;
  SELECT commission_pct INTO em_comm FROM employees WHERE employee_id=149;
  annual_salary := get_annual_comp(em_sal,em_comm);
  dbms_output.put_line('total salary '|| annual_salary);
  SELECT SUM(get_annual_comp(salary,commission_pct)) into annual_salary
  FROM employees
  WHERE department_id=90;
  dbms_output.put_line('department annual salary '|| annual_salary);
END;
/

Source: stackoverflow.com

Similar codes

2 votes266 views2 answers
Set database timezone mysql
SQL
0 vote265 views4 answers
Sql limit 1 offset 1
SQL
0 vote265 views1 answer
How to change the field size of an existing column
SQL
0 vote281 views1 answer
Mysql select field if condition
SQL
1 vote311 views1 answer
Mysql find most common value
SQL
2 votes281 views1 answer
Find all triggers in database
SQL
33 votes280 views6 answers
Change column name in mysql
SQL
0 vote282 views1 answer
Group by max date
SQL
1 vote284 views1 answer
Sql upsert
SQL
0 vote340 views1 answer
Intellij mysql set timezone
SQL