/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 vote216 views1 answer
Mysql order by desc null last
SQL
0 vote251 views1 answer
Sql today at midnight
SQL
2 votes245 views1 answer
Mysql shell insert into
SQL
3 votes223 views5 answers
Mysql get last inserted id
SQL
4 votes211 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote212 views1 answer
Mysql xampp reset root password
SQL
0 vote223 views1 answer
Order by ip address sql
SQL
0 vote221 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote215 views1 answer
Mssql describe stored procedure sqlcmd
SQL
0 vote248 views1 answer
Proc sql not in working
SQL