2. Create a package, the package contains one can return to the function of a given employee wage (name), and to raise $100 by the department of specified stored procedure
3. Use 2 created in the package, the query 'SMITH' wages, and to all employees a raise 100 department number is 20 yuan
CodePudding user response:
Three question is not difficult, not the original poster? Where can your logic and code, debugging is not in the past, everybody is good to help you,CodePudding user response:
ORACLE from entry to master a lot of books, to find a book about a look at the first,There are some good online master can help to solve some problems, but if their not sure principle, easy to a problem, the subsequent maintenance is also going to have a problem,
CodePudding user response:
Pure SQL can handle, to meet the conditions of data processing, SQL retrieval in CASE the WHEN can use,