Sale!

Oracle SQL Plus pocket reference 3rd Edition by Jonathan Gennick ISBN 0596008856 978-0596008857

Original price was: $50.00.Current price is: $35.00.

Oracle SQL Plus pocket reference 3rd ed Edition Jonathan Gennick Digital Instant Download

Author(s): Jonathan Gennick
ISBN(s): 9780596008857, 0596008856
Edition: 3rd ed
File Details: PDF, 1.66 MB
Year: 2005
Language: english
SKU: EB-4105086 Category: Tag:

Oracle SQL Plus pocket reference 3rd Edition by Jonathan Gennick – Ebook PDF Instant Download/Delivery: 0596008856, 978-0596008857
Full download Oracle SQL Plus pocket reference 3rd edition after payment


Product details:

ISBN 10:  0596008856
ISBN 13: 978-0596008857
Author: Jonathan Gennick

The Oracle SQL*Plus Pocket Reference is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQL*Plus. As Oracle’s long-standing interactive query tool, SQL*Plus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQL*Plus is still often not completely understood or fully utilized. Database administrators and developers alike will therefore find the Oracle SQL*Plus Pocket Reference to be extremely beneficial. In addition to summarizing all of the SQL*Plus syntax and format options, including new Oracle Database 10g features, this handy, on-the-job guide specifically shows readers how to:

  • Differentiate between SQL and SQL*Plus
  • Interact with SQL*Plus from both the command line and the web browser
  • Select, insert, update, and delete data
  • Format both text and HTML reports with SQL*Plus
  • Specify SQL*Plus commands and format elements
  • Tune SQL queries

The new third edition of this book has been updated for Oracle Database 10g to include information on both SQL*Plus and SQL. New SQL information includes the SELECT statement’s new MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN. With its quick-reference format and compact size, the Oracle SQL*Plus Pocket Reference follows in the long line of successful “pocket references” offered by O’Reilly. It also serves as the ideal companion to O’Reilly’s larger, more comprehensive book on SQL*Plus, the bestselling Oracle SQL*Plus: The Definitive Guide. Author Jonathan Gennick is an editor for O’Reilly specializing in database and programming titles, having amassed some 17 years of programming and database management experience.

Oracle SQL Plus pocket reference 3rd Table of contents:

  1. Introduction
  2. Acknowledgments
  3. Conventions
  4. Command-Line SQL*Plus
  5. Starting SQL*Plus
  6. Syntax for the sqlplus command
  7. Entering Commands
  8. Entering SQL*Plus commands
  9. Entering SQL statements
  10. Entering PL/SQL blocks
  11. Strings in SQL*Plus Commands
  12. Specifying Filenames
  13. Naming Variables
  14. Browser-Based SQL*Plus
  15. Starting and Stopping iSQL*Plus
  16. Connecting to iSQL*Plus
  17. Connecting to a Database
  18. Connecting as SYSDBA
  19. Creating SYSDBA Users
  20. Entering and Executing Commands
  21. Getting Output as Plain Text
  22. Executing Scripts
  23. Disconnecting from iSQL*Plus
  24. Selecting Data
  25. The SELECT Statement
  26. Selecting columns from a table
  27. Ordering query results
  28. Restricting query results
  29. Using column aliases
  30. Factoring out subqueries
  31. Nulls
  32. Using the NVL function
  33. Using the COALESCE function
  34. CASE Expressions
  35. Simple CASE expressions
  36. Searched CASE expressions
  37. Table Joins (Oracle8i and Earlier)
  38. Inner and outer joins
  39. Table Joins (Oracle9i and Higher)
  40. Sample tables
  41. Inner joins
  42. Join order
  43. Left and right outer joins
  44. Full outer joins
  45. Specifying join conditions
  46. Partition Outer Joins
  47. Summary Queries
  48. Using aggregate functions
  49. Using GROUP BY
  50. Restricting summarized results
  51. Using ALL and DISTINCT
  52. Unions
  53. Partition Operations
  54. Flashback Queries
  55. Modeling Data
  56. MODEL Clause Syntax
  57. MODEL Clause Functions
  58. MODEL Clause Example
  59. Inserting Data
  60. Inserting One Row
  61. Inserting the Results of a Query
  62. Multitable Inserts (Oracle9i and Higher)
  63. Updating Data
  64. Simple Updates
  65. Noncorrelated Subqueries in the SET Clause
  66. Correlated Subqueries in the SET Clause
  67. Deleting Data
  68. Simple Deletes
  69. Deleting All Rows (TRUNCATE)
  70. Deleting Duplicate Rows
  71. Merging Data (Oracle9i and Higher)
  72. Transaction Management
  73. SET TRANSACTION
  74. SAVEPOINT
  75. COMMIT
  76. ROLLBACK
  77. Formatting Text Reports
  78. Column Headings
  79. Column Formats
  80. Page Width and Length
  81. Page Headers and Footers
  82. Defining a title
  83. Getting the date into a title
  84. Page Breaks
  85. Report Breaks
  86. The BREAK command
  87. The COMPUTE command
  88. Formatting HTML Reports
  89. The Concatenation Approach
  90. Generating Full Pages
  91. Controlling page format
  92. Controlling column format
  93. Tuning SQL
  94. Creating the Plan Table
  95. Explaining a Query
  96. EXPLAIN PLAN syntax
  97. EXPLAIN PLAN example
  98. Using DBMS_XPLAN
  99. Querying the Plan Table
  100. Using Optimizer Hints
  101. Hint query blocks
  102. Optimizer goal hints
  103. Access method hints
  104. Join order hints
  105. Join operation hints
  106. Query transformation hints
  107. Miscellaneous hints
  108. SQL*Plus Format Elements
  109. Formatting Numbers
  110. Formatting Character Strings
  111. Formatting Dates
  112. SQL*Plus Command Reference
  113. Comment Delimiters (/*…*/)
  114. Double Hyphen ( — )
  115. At Sign (@)
  116. Double At Sign (@@)
  117. Forward Slash (/)
  118. ACCEPT
  119. APPEND
  120. ARCHIVE LOG
  121. ATTRIBUTE
  122. BREAK
  123. BTITLE
  124. CHANGE
  125. CLEAR
  126. COLUMN
  127. COMPUTE
  128. CONNECT
  129. COPY
  130. DEFINE
  131. DEL
  132. DESCRIBE
  133. DISCONNECT
  134. EDIT
  135. EXECUTE
  136. EXIT
  137. GET
  138. HELP
  139. HOST
  140. INPUT
  141. LIST
  142. PASSWORD
  143. PAUSE
  144. PRINT
  145. PROMPT
  146. QUIT
  147. RECOVER
  148. REMARK
  149. REPFOOTER
  150. REPHEADER
  151. RUN
  152. SAVE
  153. SET
  154. SHOW
  155. SHUTDOWN
  156. SPOOL
  157. START
  158. STARTUP
  159. STORE
  160. TIMING
  161. TTITLE
  162. UNDEFINE
  163. VARIABLE
  164. WHENEVER
  165. Index

People also search for Oracle SQL Plus pocket reference 3rd :

pl sql pocket reference pdf

oracle pl/sql reference

oracle database pl/sql packages and types reference 19c

oracle sql reference 12c

oracle database sql reference 12c pdf

Tags: Jonathan Gennick, Oracle SQL, pocket reference 3