[pl / SQL] basic exercises 1-8 (1)

1. Query the information of the employee whose third letter of ename is a (using two methods). analysis:Either fuzzy query, or accurately locate the location and then judge SELECT * FROM EMP WHERE ENAME LIKE ‘__A%’; SELECT * FROM EMP WHERE SUBSTR(ENAME,3,1) = ‘A’; 2. Inquire how many months the employees of department 10 and […]