hiskio

    Oracle Database Notes for Professionals book

    Amazing collection of free programming books

    Collecting
    Free
    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/

    Content

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

    FAQ

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

    Recommendations

    Reviews

    | Collecting

    Sales Plans