/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 vote173 views2 answers
Rebuild index sql server
SQL
1 vote208 views3 answers
How to create a table structure from another table in mysql
SQL
1 vote194 views1 answer
Too many connections mysql
SQL
0 vote169 views1 answer
Get records in sql according to month name and count
SQL
0 vote191 views1 answer
On delete set default
SQL
6 votes185 views3 answers
How to delete table sqlite
SQL
3 votes174 views1 answer
Two selects in one query
SQL
1 vote181 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
50 votes202 views6 answers
Install mysql on ubuntu
SQL
0 vote176 views1 answer
Sql include rows with 0 values
SQL