/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

0 vote269 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote234 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote283 views1 answer
Sparql list all graphs
SQL
0 vote230 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
0 vote251 views2 answers
Collation in sql
SQL
0 vote267 views1 answer
Get role postgres
SQL
0 vote232 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
6 votes236 views1 answer
Phpmyadmin password root
SQL
0 vote248 views1 answer
Adding generated time in row mysql workbench
SQL
0 vote240 views1 answer
Createdb with postgresql on ubuntu
SQL