/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

0 vote320 views1 answer
Sql server beginning of month
SQL
13 votes330 views2 answers
Sql join 3 tables
SQL
1 vote322 views1 answer
Sql group by sum with condition
SQL
3 votes341 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote298 views1 answer
Dns slave zone convert
SQL
1 vote346 views2 answers
Mysql extract number from string
SQL
1 vote326 views1 answer
Postgres power
SQL
0 vote309 views1 answer
Postgresql if else endif
SQL
0 vote307 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote356 views2 answers
Sql unique
SQL