/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

27 votes368 views3 answers
Mysql delete row
SQL
0 vote336 views1 answer
Run sql script file and changes db name in this file using c#
SQL
4 votes325 views4 answers
Date less than in sql
SQL
1 vote331 views1 answer
Psql filed name alter
SQL
-1 vote307 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote299 views1 answer
Sql datediff month
SQL
16 votes307 views2 answers
Add column to all tables after first column mysql
SQL
3 votes336 views1 answer
Laravel paginate raw sql
SQL
0 vote313 views1 answer
Delete data from database sqlite android
SQL
1 vote308 views1 answer
Psql lst trigger
SQL