/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

104 votes435 views2 answers
Like in mysql
SQL
1 vote243 views1 answer
Mysql date diff in seconds
SQL
0 vote311 views2 answers
Mysql cast to varchar
SQL
-1 vote274 views1 answer
Sql select data from one database and insert into a different database
SQL
12 votes275 views2 answers
Update column data type postgres
SQL
4 votes265 views2 answers
Oracle sql group by date year
SQL
27 votes277 views5 answers
Add column in table
SQL
1 vote290 views2 answers
Truncate table sqlite
SQL
3 votes262 views3 answers
Stop mysql ubuntu
SQL
0 vote236 views1 answer
Create dabase postgresql
SQL