/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

5 votes282 views1 answer
Mysql add user with all privileges
SQL
0 vote234 views1 answer
Import all databases mysql
SQL
0 vote277 views1 answer
Sql gather statistics to increase performance
SQL
4 votes243 views1 answer
Oracle show errors compilation
SQL
0 vote261 views1 answer
Delete record by id sql
SQL
1 vote266 views1 answer
Sqlserver create table from select
SQL
0 vote260 views1 answer
ORACLE PARSE STRING
SQL
0 vote270 views1 answer
Change magento database url usimg musql
SQL
0 vote256 views1 answer
Sql server union if table exist
SQL
1 vote285 views3 answers
Read all columns of a table sql
SQL