Write a Oracle query to concatenate first name, last name and job id from employees table in the following format
- اوراكل
- 2021-10-12
- mhanasmh00489829403
الأجوبة
Oracle Code :
SELECT CONCAT (CONCAT (CONCAT(CONCAT(first_name,' '),last_name), ' is a '),job_id)
FROM employees
WHERE salary > 2000;Output:
CONCAT(CONCAT(CONCAT(CONCAT(FIRST_NAME,''),LAST_NAME),'ISA'),J -------------------------------------------------------------- Steven King is a AD_PRES Neena Kochhar is a AD_VP Lex De Haan is a AD_VP Alexander Hunold is a IT_PROG Bruce Ernst is a IT_PROG David Austin is a IT_PROG Valli Pataballa is a IT_PROG Diana Lorentz is a IT_PROG Nancy Greenberg is a FI_MGR Daniel Faviet is a FI_ACCOUNT John Chen is a FI_ACCOUNT ........ 107 rows selected.
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال
معلومات ذات صلة