Call Function In Sql Statement

[mohammad_awadat]

ممكن حد قلي كيف ممكن انادي function من sql statement


شكرا

[airtifa]

see this example:

select id,get_emp_name(id),salary from emp;

[sameh bakkar]

بعض االأمثله البسيطه...

SELECT job_id, COUNT(*)
FROM   employees 
GROUP BY job_id;



SELECT COUNT(DISTINCT manager_id) "Number of Managers"
FROM   employees; 



SELECT  employee_id, last_name, salary,
	ROUND(salary * 1.155, 0) "New Salary"
FROM	employees;


SELECT  INITCAP(last_name) "Name",
	LENGTH(last_name) "Length"
FROM	employees
WHERE   last_name LIKE 'J%' 
OR	  last_name LIKE 'M%'
OR	  last_name LIKE 'A%'
ORDER BY last_name;


SELECT last_name,
   LPAD(salary, 15, '$') SALARY
FROM   employees;

وهكذا ..... اتمنى أن تكون استفدت...  كل الأسئله على المستخدم HR