Write a Oracle query to list the names (first and last) of those employees whose first name has only five characters
- اوراكل
- 2021-10-12
- mhanasmh00489829403
الأجوبة
Oracle Code:
SELECT first_name, last_name
FROM employees
WHERE length(first_name) = 5;Output:
FIRST_NAME LAST_NAME -------------------- ------------------------- Ellen Abel Mozhe Atkinson David Austin Sarah Bell David Bernstein Laura Bissot Kelly Chung Karen Colmenares Julia Dellinger Bruce Ernst Kevin Feeney Nancy Greenberg Peter Hall Vance Jones Payam Kaufling Neena Kochhar James Landry David Lee Diana Lorentz Jason Mallin James Marlow Susan Mavris Allan McEwen Irene Mikkilineni Kevin Mourgos Julia Nayer Karen Partners Valli Pataballa Hazel Philtanker Sigal Tobias Peter Tucker Peter Vargas Clara Vishney Alana Walsh Eleni Zlotkey 35 rows selected.
أسئلة مشابهة
القوائم الدراسية التي ينتمي لها السؤال
معلومات ذات صلة