SQL Plus quick reference by Oracle Corporation
By Oracle Corporation
Read or Download SQL Plus quick reference PDF
Similar oracle books
За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle varieties, так и администраторам - используйте PL/SQL на полную мощь.
Grasp Oracle Streams 11g Replication let real-time info entry and knowledge sharing throughout your allotted framework utilizing the specialist details during this Oracle Press advisor. Oracle Streams 11g facts Replication explains tips to organize and administer a unified firm information sharing infrastructure.
Oracle software convey four Recipes presents an example-based method of studying program convey - the ground-breaking, quick software improvement platform integrated with each Oracle Database license. The recipes structure is perfect for the quick-study who simply wishes a superb instance or to kick commence their pondering and get pointed within the correct course.
- Expert Indexing in Oracle DB 11g - Max. Perf. for Your DB
- Expert Oracle Enterprise Manager 12c
- Protecting Oracle Database 12c
- RMAN Recipes for Oracle Database 12c: A Problem-Solution Approach (Expert's Voice in Oracle)
- Oracle Essbase & Oracle OLAP
- Bright Sparks
Additional info for SQL Plus quick reference
Creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSIONS of the EMP table. F. Decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more then 800. Answer: B, D, E Explanation: Increasing the commission of employee 3 by the average commission earned in department 20 will require sub-queries or joins in order to perform in a single step. Inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3 is correct answer also.
Department _ id); D. salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department _ id); Answer: A Explanation: This SQL statement shows correct syntax to build inline views. You must enclose the query text for the inline view in parentheses and also give a label for the inline view so that columns in it can be referenced later. In answer A inline view is marked as B. Incorrect Answers B: This SQL statement will fail because it is not correct syntax for inline views.
D: Your last update will not fail because there is employee with ID 180 in the table and transactions have been rolled back only to the savepoint s2 before issue this update. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 279-285 Chapter 6: Manipulating Oracle Data QUESTION 68: Which two are attributes of iSQL*Plus? (Choose two) A. /SQL*Plus commands cannot be abbreviated. B. /SQL*Plus commands are accessed from a browser. C. /SQL*Plus commands are used to manipulate data in tables.