/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

2 votes181 views3 answers
Copy data from one table column to another table column in sql
SQL
1 vote166 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
1 vote164 views3 answers
Mysql Server Start
SQL
0 vote185 views1 answer
Django mssql backend
SQL
-1 vote176 views2 answers
Postgresql get last 10 records
SQL
9 votes182 views2 answers
Sql limit to 5 results
SQL
1 vote159 views3 answers
Union in sql
SQL
7 votes175 views2 answers
Oracle sql drop index
SQL
0 vote176 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
10 votes158 views4 answers
Join with multiple conditions sql
SQL