/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 vote334 views2 answers
Restart identity cascade
SQL
0 vote315 views1 answer
Format the money fied with comma in international system using sql
SQL
6 votes378 views3 answers
Psql show columns of table
SQL
6 votes327 views2 answers
WHERE value IS sql
SQL
0 vote330 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
0 vote377 views1 answer
How to set up an anonymous function to variable in swift
SQL
2 votes344 views1 answer
Column names in oracle sql
SQL
1 vote320 views2 answers
Get date from datetime postgresql
SQL
5 votes290 views1 answer
Copy table from one database to another mysql
SQL
12 votes373 views2 answers
Insert multiple rows from another table sql
SQL