/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

6 votes121 views1 answer
Phpmyadmin password root
SQL
23 votes130 views4 answers
Sql server substring
SQL
0 vote136 views1 answer
Select into table variable
SQL
1 vote133 views1 answer
Calculate age in sql postgresql
SQL
0 vote120 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
1 vote79 views1 answer
Pagination sql
SQL
0 vote132 views1 answer
Group by join columns per table
SQL
0 vote117 views1 answer
Complete date is 1 year or not sql server
SQL
3 votes127 views3 answers
Your password does not satisfy the current policy requirements
SQL
0 vote120 views1 answer
Cast for print sql
SQL