/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 vote150 views1 answer
How to insert multiple values in a single column in sql
SQL
0 vote166 views1 answer
Sql cheetsheet
SQL
2 votes153 views1 answer
How to show the whole table in sql
SQL
0 vote197 views1 answer
SQL Server Altering Column to be Unique
SQL
34 votes187 views6 answers
Alter table add foreign key mysql
SQL
0 vote186 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
1 vote152 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
1 vote148 views1 answer
Calculate age in sql postgresql
SQL
0 vote141 views1 answer
Find most frequent value in SQL column
SQL
0 vote140 views1 answer
Reading from right to left from string find first special characters in sql
SQL