/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 vote149 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote150 views1 answer
Oracle first row
SQL
0 vote152 views1 answer
Mysql 1 hour ago
SQL
0 vote192 views1 answer
SQL-Arten
SQL
8 votes154 views2 answers
Between operator
SQL
7 votes168 views3 answers
Sql server reset auto increment
SQL
1 vote187 views1 answer
Sql where max date
SQL
1 vote158 views2 answers
How to drop a unique constraint in sql
SQL
-1 vote171 views1 answer
Module operator in oracle sql
SQL
0 vote189 views2 answers
Mysql show foreign keys
SQL