hiskio

    Oracle Database Notes for Professionals book

    Amazing collection of free programming books

    收集中
    免費
    Amazing collection of free programming books

    The Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow. Text content is released under Creative Commons BY-SA. See credits at the end of this book whom contributed to the various chapters. Images may be copyright of their respective owners unless otherwise specified

    Book created for educational purposes and is not affiliated with group(s), company(s) nor Stack Overflow. All trademarks belong to their respective company owners

    https://goalkicker.com/

    章節目錄

    • 1-1
      Content list
    • 1-2
      About
    • 1-3
      Chapter 1: Getting started with Oracle Database
    • 1-4
      Section 1.1: Hello World
    • 1-5
      Section 1.2: SQL Query
    • 1-6
      Section 1.3: Hello world! from table
    • 1-7
      Section 1.4: Hello World from PL/SQL
    • 1-8
      Chapter 2: Getting started with PL/SQL
    • 1-9
      Section 2.1: Hello World
    • 1-10
      Section 2.2: Definition of PL/SQL
    • 1-11
      Section 2.3: Dierence between %TYPE and %ROWTYPE
    • 1-12
      Section 2.4: Create or replace a view
    • 1-13
      Section 2.5: Create a table
    • 1-14
      Section 2.6: About PL/SQL
    • 1-15
      Chapter 3: Anonymous PL/SQL Block
    • 1-16
      Section 3.1: An example of an anonymous block
    • 1-17
      Chapter 4: PL/SQL procedure
    • 1-18
      Section 4.1: Syntax
    • 1-19
      Section 4.2: Hello World
    • 1-20
      Section 4.3: In/Out Parameters
    • 1-21
      Chapter 5: Data Dictionary
    • 1-22
      Section 5.1: Describes all objects in the database
    • 1-23
      Section 5.2: To see all the data dictionary views to which you have access
    • 1-24
      Section 5.3: Text source of the stored objects
    • 1-25
      Section 5.4: Get list of all tables in Oracle
    • 1-26
      Section 5.5: Privilege information
    • 1-27
      Section 5.6: Oracle version
    • 1-28
      Chapter 6: Dates
    • 1-29
      Section 6.1: Date Arithmetic - Dierence between Dates in Days, Hours, Minutes and/or Seconds
    • 1-30
      Section 6.2: Setting the Default Date Format Model
    • 1-31
      Section 6.3: Date Arithmetic - Dierence between Dates in Months or Years
    • 1-32
      Section 6.4: Extract the Year, Month, Day, Hour, Minute or Second Components of a Date
    • 1-33
      Section 6.5: Generating Dates with No Time Component
    • 1-34
      Section 6.6: Generating Dates with a Time Component
    • 1-35
      Section 6.7: The Format of a Date
    • 1-36
      Section 6.8: Converting Dates to a String
    • 1-37
      Section 6.9: Changing How SQL/Plus or SQL Developer Display Dates
    • 1-38
      Section 6.10: Time Zones and Daylight Savings Time
    • 1-39
      Section 6.11: Leap Seconds
    • 1-40
      Section 6.12: Getting the Day of the Week
    • 1-41
      Chapter 7: Working with Dates
    • 1-42
      Section 7.1: Date Arithmetic
    • 1-43
      Section 7.2: Add_months function
    • 1-44
      Chapter 8: DUAL table
    • 1-45
      Section 8.1: The following example returns the current operating system date and time
    • 1-46
      Section 8.2: The following example generates numbers between start_value and end_value
    • 1-47
      Chapter 9: JOINS
    • 1-48
      Section 9.1: CROSS JOIN
    • 1-49
      Section 9.2: LEFT OUTER JOIN
    • 1-50
      Section 9.3: RIGHT OUTER JOIN
    • 1-51
      Section 9.4: FULL OUTER JOIN
    • 1-52
      Section 9.5: ANTIJOIN
    • 1-53
      Section 9.6: INNER JOIN
    • 1-54
      Section 9.7: JOIN
    • 1-55
      Section 9.8: SEMIJOIN
    • 1-56
      Section 9.9: NATURAL JOIN
    • 1-57
      Chapter 10: Handling NULL values
    • 1-58
      Section 10.1: Operations containing NULL are NULL, except concatenation
    • 1-59
      Section 10.2: NVL2 to get a dierent result if a value is null or not
    • 1-60
      Section 10.3: COALESCE to return the first non-NULL value
    • 1-61
      Section 10.4: Columns of any data type can contain NULLs
    • 1-62
      Section 10.5: Empty strings are NULL
    • 1-63
      Section 10.6: NVL to replace null value
    • 1-64
      Chapter 11: String Manipulation
    • 1-65
      Section 11.1: INITCAP
    • 1-66
      Section 11.2: Regular expression
    • 1-67
      Section 11.3: SUBSTR
    • 1-68
      Section 11.4: Concatenation: Operator || or concat() function
    • 1-69
      Section 11.5: UPPER
    • 1-70
      Section 11.6: LOWER
    • 1-71
      Section 11.7: LTRIM / RTRIM
    • 1-72
      Chapter 12: IF-THEN-ELSE Statement
    • 1-73
      Section 12.1: IF-THEN
    • 1-74
      Section 12.2: IF-THEN-ELSE
    • 1-75
      Section 12.3: IF-THEN-ELSIF-ELSE
    • 1-76
      Chapter 13: Limiting the rows returned by a query (Pagination)
    • 1-77
      Section 13.1: Get first N rows with row limiting clause
    • 1-78
      Section 13.2: Get row N through M from many rows (before Oracle 12c)
    • 1-79
      Section 13.3: Get N numbers of Records from table
    • 1-80
      Section 13.4: Skipping some rows then taking some
    • 1-81
      Section 13.5: Skipping some rows from result
    • 1-82
      Section 13.6: Pagination in SQL
    • 1-83
      Chapter 14: Recursive Sub-Query Factoring using the WITH Clause (A.K.A. Common Table Expressions)
    • 1-84
      Section 14.1: Splitting a Delimited String
    • 1-85
      Section 14.2: A Simple Integer Generator
    • 1-86
      Chapter 15: Dierent ways to update records
    • 1-87
      Section 15.1: Update using Merge
    • 1-88
      Section 15.2: Update Syntax with example
    • 1-89
      Section 15.3: Update Using Inline View
    • 1-90
      Section 15.4: Merge with sample data
    • 1-91
      Chapter 16: Update with Joins
    • 1-92
      Section 16.1: Examples: what works and what doesn't
    • 1-93
      Chapter 17: Functions
    • 1-94
      Section 17.1: Calling Functions
    • 1-95
      Chapter 18: Statistical functions
    • 1-96
      Section 18.1: Calculating the median of a set of values
    • 1-97
      Chapter 19: Window Functions
    • 1-98
      Section 19.1: Ratio_To_Report
    • 1-99
      Chapter 20: Creating a Context
    • 1-100
      Section 20.1: Create a Context
    • 1-101
      Chapter 21: Splitting Delimited Strings
    • 1-102
      Section 21.1: Splitting Strings using a Hierarchical Query
    • 1-103
      Section 21.2: Splitting Strings using a PL/SQL Function
    • 1-104
      Section 21.3: Splitting Strings using a Recursive Sub-query Factoring Clause
    • 1-105
      Section 21.4: Splitting Strings using a Correlated Table Expression
    • 1-106
      Section 21.5: Splitting Strings using CROSS APPLY (Oracle 12c)
    • 1-107
      Section 21.6: Splitting Strings using XMLTable and FLWOR expressions
    • 1-108
      Section 21.7: Splitting Delimited Strings using XMLTable
    • 1-109
      Chapter 22: Collections and Records
    • 1-110
      Section 22.1: Use a collection as a return type for a split function
    • 1-111
      Chapter 23: Object Types
    • 1-112
      Section 23.1: Accessing stored objects
    • 1-113
      Section 23.2: BASE_TYPE
    • 1-114
      Section 23.3: MID_TYPE
    • 1-115
      Section 23.4: LEAF_TYPE
    • 1-116
      Chapter 24: Loop
    • 1-117
      Section 24.1: Simple Loop
    • 1-118
      Section 24.2: WHILE Loop
    • 1-119
      Section 24.3: FOR Loop
    • 1-120
      Chapter 25: Cursors
    • 1-121
      Section 25.1: Parameterized "FOR loop" Cursor
    • 1-122
      Section 25.2: Implicit "FOR loop" cursor
    • 1-123
      Section 25.3: Handling a CURSOR
    • 1-124
      Section 25.4: Working with SYS_REFCURSOR
    • 1-125
      Chapter 26: Sequences
    • 1-126
      Section 26.1: Creating a Sequence: Example
    • 1-127
      Chapter 27: Indexes
    • 1-128
      Section 27.1: b-tree index
    • 1-129
      Section 27.2: Bitmap Index
    • 1-130
      Section 27.3: Function Based Index
    • 1-131
      Chapter 28: Hints
    • 1-132
      Section 28.1: USE_NL
    • 1-133
      Section 28.2: APPEND HINT
    • 1-134
      Section 28.3: Parallel Hint
    • 1-135
      Section 28.4: USE_HASH
    • 1-136
      Section 28.5: FULL
    • 1-137
      Section 28.6: Result Cache
    • 1-138
      Chapter 29: Packages
    • 1-139
      Section 29.1: Define a Package header and body with a function
    • 1-140
      Section 29.2: Overloading
    • 1-141
      Section 29.3: Package Usage
    • 1-142
      Chapter 30: Exception Handling
    • 1-143
      Section 30.1: Syntax
    • 1-144
      Section 30.2: User defined exceptions
    • 1-145
      Section 30.3: Internally defined exceptions
    • 1-146
      Section 30.4: Predefined exceptions
    • 1-147
      Section 30.5: Define custom exception, raise it and see where it comes from
    • 1-148
      Section 30.6: Handling connexion error exceptions
    • 1-149
      Section 30.7: Exception handling
    • 1-150
      Chapter 31: Error logging
    • 1-151
      Section 31.1: Error logging when writing to database
    • 1-152
      Chapter 32: Database Links
    • 1-153
      Section 32.1: Creating a database link
    • 1-154
      Section 32.2: Create Database Link
    • 1-155
      Chapter 33: Table partitioning
    • 1-156
      Section 33.1: Select existing partitions
    • 1-157
      Section 33.2: Drop partition
    • 1-158
      Section 33.3: Select data from a partition
    • 1-159
      Section 33.4: Split Partition
    • 1-160
      Section 33.5: Merge Partitions
    • 1-161
      Section 33.6: Exchange a partition
    • 1-162
      Section 33.7: Hash partitioning
    • 1-163
      Section 33.8: Range partitioning
    • 1-164
      Section 33.9: List partitioning
    • 1-165
      Section 33.10: Truncate a partition
    • 1-166
      Section 33.11: Rename a partition
    • 1-167
      Section 33.12: Move partition to dierent tablespace
    • 1-168
      Section 33.13: Add new partition
    • 1-169
      Chapter 34: Oracle Advanced Queuing (AQ)
    • 1-170
      Section 34.1: Simple Producer/Consumer
    • 1-171
      Chapter 35: constraints
    • 1-172
      Section 35.1: Update foreign keys with new value in Oracle
    • 1-173
      Section 35.2: Disable all related foreign keys in oracle
    • 1-174
      Chapter 36: Autonomous Transactions
    • 1-175
      Section 36.1: Using autonomous transaction for logging errors
    • 1-176
      Chapter 37: Oracle MAF
    • 1-177
      Section 37.1: To get value from Binding
    • 1-178
      Section 37.2: To set value to binding
    • 1-179
      Section 37.3: To invoke a method from binding
    • 1-180
      Section 37.4: To call a javaScript function
    • 1-181
      Chapter 38: level query
    • 1-182
      Section 38.1: Generate N Number of records
    • 1-183
      Section 38.2: Few usages of Level Query
    • 1-184
      Chapter 39: Hierarchical Retrieval With Oracle Database 12C
    • 1-185
      Section 39.1: Using the CONNECT BY Caluse
    • 1-186
      Section 39.2: Specifying the Direction of the Query From the Top Down
    • 1-187
      Chapter 40: Data Pump
    • 1-188
      Section 40.1: Monitor Datapump jobs
    • 1-189
      Section 40.2: Step 3/6 : Create directory
    • 1-190
      Section 40.3: Step 7 : Export Commands
    • 1-191
      Section 40.4: Step 9 : Import Commands
    • 1-192
      Section 40.5: Datapump steps
    • 1-193
      Section 40.6: Copy tables between dierent schemas and tablespaces
    • 1-194
      Chapter 41: Bulk collect
    • 1-195
      Section 41.1: Bulk data Processing
    • 1-196
      Chapter 42: Real Application Security
    • 1-197
      Section 42.1: Application
    • 1-198
      Chapter 43: Assignments model and language
    • 1-199
      Section 43.1: Assignments model in PL/SQL
    • 1-200
      Chapter 44: Triggers
    • 1-201
      Section 44.1: Before INSERT or UPDATE trigger
    • 1-202
      Chapter 45: Dynamic SQL
    • 1-203
      Section 45.1: Select value with dynamic SQL
    • 1-204
      Section 45.2: Insert values in dynamic SQL
    • 1-205
      Section 45.3: Update values in dynamic SQL
    • 1-206
      Section 45.4: Execute DDL statement
    • 1-207
      Section 45.5: Execute anonymous block
    • 1-208
      Credits
    • 1-209
      You may also like

    常見問答

    您可以透過手機、平板或是電腦登入 HiSKIO 平台，在【我的學習】＞【我的書籍】頁面，選擇想看的電子書。

    猜你喜歡

    用戶評價

    | 收集中

    銷售方案