/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

11 votes725 views4 answers
Reset identity column values in sql server
SQL
0 vote280 views1 answer
Create or replace view postgress
SQL
1 vote289 views1 answer
Rename table column name in mysql
SQL
8 votes295 views10 answers
Sql
SQL
0 vote295 views1 answer
Mysql multiple primary keys
SQL
-1 vote315 views1 answer
Pl/sql how to delete a trigger
SQL
10 votes263 views2 answers
Mysql select timestamp group by day
SQL
0 vote286 views2 answers
Sql query in dax power bi
SQL
8 votes270 views2 answers
Phpmyadmin password
SQL
17 votes283 views6 answers
Get last record in sql
SQL