/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 vote182 views1 answer
How to see all table partition in oracle
SQL
0 vote194 views1 answer
Mysql update from n to 100
SQL
0 vote215 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
0 vote199 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote200 views1 answer
Data directory postgresql
SQL
0 vote158 views1 answer
Postgresql add leading zeros
SQL
0 vote190 views1 answer
Set column width in sqlplus
SQL
0 vote182 views1 answer
Database springboot
SQL
0 vote188 views1 answer
Mysql max number not returning correct value
SQL
-1 vote209 views3 answers
How to restart mysql in linux
SQL