/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 vote250 views1 answer
Ora-01950 no privileges on tablespace
SQL
11 votes218 views2 answers
Import sql file laravel cmd
SQL
12 votes186 views1 answer
Script to add new column in table sql
SQL
0 vote216 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
2 votes226 views1 answer
Datefromparts mssql
SQL
12 votes275 views4 answers
How to drop all tables in postgresql
SQL
1 vote211 views1 answer
Increase existing date in sql oracle
SQL
0 vote197 views1 answer
Psql attribute cannot login
SQL
2 votes185 views1 answer
Possgress drop if exists table
SQL
0 vote137 views1 answer
Mssql view column data type
SQL