/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

3 votes312 views1 answer
V$session not found in oracle
SQL
1 vote305 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote312 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote335 views1 answer
What does leave do in mysql
SQL
1 vote289 views1 answer
Psql show with user is logged in
SQL
0 vote407 views1 answer
Trigger
SQL
0 vote325 views1 answer
How to put value in parameters in mysqldataadapter
SQL
50 votes403 views6 answers
Sql duplicate rows
SQL
1 vote381 views1 answer
Oracle select first row order by
SQL
0 vote326 views1 answer
Calculate date and convert to yearsmysql
SQL