Question: this is my code but I keep getting this ORA-00923: FROM keyword not found where expected SELECT emp_fname as 'First Name', emp_lname as 'Last Name',
this is my code but I keep getting this
ORA-00923: FROM keyword not found where expected
SELECT emp_fname as 'First Name', emp_lname as 'Last Name', round(months_between(sysdate, emp_dob)/12,2) as'Employee Age', FROM emp
WHERE emp_mgr = 105
ORDER BY emp_dob DESC;
QUERY 1: Write and run an SQL statement to display first name, last name, and age of employees whose manager is 105. Display the results from oldest employees to youngest employees. (NOTE: In Oracle SQL, you can use the keyword SYSDATE which gives today's date.) Partial output appears below for your reference. Your screenshot should show complete query, its complete output, and your account email address. Also, please be sure that column captions are the same as below. Round any numbers to two decimal places. First Name Last Name Employee Age Rupert Washington 52.79 Jeanine Smith 50.68 Melanie Smythe 48.09
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
