/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

25 votes318 views4 answers
Sqlserver add column
SQL
2 votes321 views1 answer
Creating a view SQL
SQL
0 vote301 views1 answer
C# mysql update statement set value to null
SQL
20 votes325 views1 answer
Get all table name in sql through php
SQL
0 vote317 views1 answer
Set engine to innodb
SQL
0 vote319 views1 answer
Cannot pip install mysqlclient
SQL
2 votes294 views1 answer
Sqlite insert if not exists
SQL
0 vote299 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
7 votes303 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote287 views2 answers
Sql server set default value equal to auto increment
SQL