/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 vote168 views1 answer
Docker export psql sql
SQL
0 vote170 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote167 views1 answer
Create table with primary key and foreign key in sql server
SQL
0 vote185 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote354 views1 answer
Dublicate row sql
SQL
0 vote181 views4 answers
Change schema in sql server
SQL
0 vote207 views1 answer
Count number of entires by months sql
SQL
0 vote180 views1 answer
Import sql in postgresql
SQL
3 votes183 views1 answer
Sql multi column index performance
SQL
17 votes169 views6 answers
Mysql import sql file
SQL