/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

1 vote330 views1 answer
Can we drop a primary key
SQL
7 votes386 views3 answers
Sql set
SQL
0 vote374 views1 answer
Get a list of tables and the primary key
SQL
0 vote337 views2 answers
Select limit ms sql
SQL
1 vote347 views1 answer
Convert rows to string sql server
SQL
0 vote364 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote357 views1 answer
Restart sql server command line linux
SQL
0 vote376 views2 answers
Dumping sql table
SQL
0 vote370 views1 answer
Date on SQL
SQL
2 votes498 views1 answer
Ssh mysql port forwarding
SQL