/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

3 votes199 views5 answers
Sql select
SQL
1 vote166 views1 answer
Find difference in dates sql
SQL
36 votes184 views6 answers
Rename table sql
SQL
4 votes159 views3 answers
Create database in mySQL
SQL
3 votes184 views2 answers
Wp do sql query from function
SQL
0 vote181 views1 answer
Distinct data types in a table sql query
SQL
0 vote197 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
0 vote164 views2 answers
Which MySQL statement is used to delete data from a database
SQL
0 vote179 views1 answer
Mysql backup query
SQL
0 vote180 views1 answer
Connect to nginx server mysql remotly
SQL