/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 vote113 views1 answer
T-SQL Alter the column data type
SQL
0 vote119 views1 answer
Sql pad left 0
SQL
0 vote132 views2 answers
Compound operator in sql
SQL
0 vote122 views1 answer
How to add timestamp column in mysql
SQL
0 vote115 views4 answers
Mysql select bottom 10 rows
SQL
8 votes131 views4 answers
How to calculate the age from date of birth in python
SQL
12 votes115 views3 answers
Duplicate a column in sql
SQL
44 votes228 views4 answers
Mysql alter table add column first
SQL
0 vote116 views1 answer
Sqlite higher or equal
SQL
1 vote112 views1 answer
Mysql current time
SQL