/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 votes167 views1 answer
Mysql cli connect with password
SQL
0 vote91 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote134 views1 answer
Datagrip exec
SQL
1 vote126 views1 answer
Sql restore backup query
SQL
0 vote136 views1 answer
Comma seperated join mssql
SQL
0 vote143 views1 answer
What is top n result in sql
SQL
0 vote154 views1 answer
Sql server remove primary key without dropping table
SQL
1 vote123 views1 answer
Oracle show execution plan
SQL
0 vote134 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote149 views1 answer
Postgresql import a database of gzip
SQL