Mastering Oracle SQL and SQL*Plus

《基於Oracle的SQL優化》是一本與眾不同的書，它的目的是使讀者真正掌握如何在 Oracle數據庫裡寫出高質量的 SQL語句，以及如何在 Oracle數據庫裡對有性能問題的 SQL做診斷和調整。《基於Oracle的SQL優化》從 Oracle處理 SQL的本質和原理入手，由淺入深、系統地介紹了 Oracle數據庫裡的優化器、執行計劃、Cursor和綁定變量、查詢轉換、統計信息、Hint和並行等

The fifth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database features. It's a companion to

This Study Guide is targeted at IT professionals who are working towards becoming an Oracle Certified Professional in the PL/SQL developer track. The book provides information covering all of the exam

This Study Guide is targeted at IT professionals who are working towards becoming an Oracle Certified Associate in the PL/SQL developer track. The book provides information covering all of the exam t

《Oracle 11g權威指南(第2版)》從數據庫的基礎知識入手，全面系統地介紹了Oracle 11g 數據庫管理系統的所有特性，并配以翔實的實際用例，論述嚴謹，深入探討了這些特性的細節內容，同時具有很強的可操作性和實用性。全書內容共37章，分為10大部分。第一部分為Oracle 11g 數據庫基礎；第二部分為Oracle之SQL與PL/SQL；第三部分為Oracle客戶端工具，主要介

本書介紹與 Oracle 數據庫性能相關的方方面面，涵蓋了 Oracle 的體系架構，其背後的運行機制包括事務、鎖與閂、多版本併發，各種 Oracle 高級特性如分區、並行執行、直接路徑操作，以及大數據導入 / 導出性能優化，並用具體的例子來解釋每個特性，它是如何工作的、其限制是什麼。本書用通俗易懂的方式介紹如何理解並掌握 Oracle SQL 執行計劃，如何高效地掌握 Oracle SQL 性能

《Oracle數據庫管理從入門到精通(附光盤)》以 面向應用為原則，深入淺出地介紹了Oracle數據庫的 管理和開發技術。書中通過大量的圖解和示例代碼， 詳細介紹了Oracle的體系結構、PL/SQL的語言特性， 并深入剖析了用PL/SQL進行Oracle開發的方方面面。為了便于讀者高效、直觀地學習，作者為本書重點內 容錄制了13.6小時多媒體教學視頻。這些視頻及本書 涉及的源代碼一起收錄于本書配

本書是美創科技資深Oracle、MySQL技術專家嘔心瀝血之作，積作者多年的經驗結晶和實踐經驗，也是目前市場上為數不多Oracle和MySQL相結合的資料庫技術書籍。 書中內容主要分為Oracle和MySQL兩大部分。第 一部分介紹Oracle的日常運維，該部分主要由四個章節構成，內容由淺入深逐步展開。包括生產環境搭建，上線前的壓力測試，日常運維以及故障處理，遷移升級，SQL的優化技巧等內容；第二

本書的作者都是Oracle ACE總監, 本書全面介紹了利用最佳實踐、詳細實例、提示技巧來有效地綜合使用SQL和PL/SQL,演示如何在實際應用程序中編寫應用、故障修複和實現代碼。本書全面剖析了未得到充分利用的SQL和PL/SQL功能, 佈局關鍵的開發策略。全面闡述了數據模型、高級分析、數據庫安全、安全編碼的內容。

本書共分19章，第1～4章分別介紹了Oracle 11g的下載和安裝、SQL*Plus的使用、SQ語言與PL／SQL.程序設計，第5～9章分別介紹了Oracle 11g的體系結構、表空間與數據文件的管理、啟動和關閉數據庫、網絡服務與管理，第10—13章介紹了有關安全的幾個內容（權限、角色、概要文件、用戶的管理），第14—17章介紹了幾種方案對象（表、索引、視圖、同義詞和序列）的管理，第18～19章

本書是兼具技術性與指導性的參考手冊。書中首先介紹了全書所需的基礎知識；接著描述如何借助相關工具識別和分析性能問題，如何利用動態性能視圖；接著重點關注負責將SQL語句生成執行計畫的組件——查詢最佳化工具；最後則展示了Oracle資料庫為高效執行SQL語句提供的特性。

本書內容理論與實務並重，利用豐富的說明文字及清楚的流程圖來說明資料庫理論，並以Oracle作為開發工具引導讀者利用所學理論來建置完整資料庫系統。本書內容芬為資料庫理論與Oracle實務兩部份，主要重點如下：＊從資料型態與模型開始介紹，到資料庫的正規化來建立正確的資料庫觀念。＊以圖例式的例子說明，並提供SQL語言查詢、基本語法的應用及進階查詢技巧。＊以Oracle系統管理的觀念，教導成功資料庫管理者

* GORGEOUSLY ILLUSTRATED: Each of the 40 cards in this oracle deck is vibrantly illustrated with original artwork; let The Snake Charmer (of VMAs fame) inspire you to face your fears, or the The Ringleader (of the "Circus" video) lead you to call the shots-these and many more Britney oracles in this one-of-a-kind set celebrate the superstar in her greatest moments from her music videos, stage performances, and more* DELUXE SET: This set includes 40 full-color illustrated cards (3 x 5 inches), shrink wrapped in an interior travel case; an 88-page, full-color illustrated paperback book (3 x 5 inches); and a keepsake magnetic closure box; cards and travel case are embedded in an interior tray * FULLY ILLUSTRATED ORACLE GUIDEBOOK: This set includes a full-color illustrated companion book to the card deck, providing the back story of each oracle and a dose of inspiration* PERFECT GIFT: This joyful, beautiful oracle deck and book set is an ideal gift for the most fabulous people in your life

With a wholly original approach to rendering the play of shadow and light, the Earth Wisdom Oracle is a mystical oracle of great visual power. Each card connects you to the energy of a crystal, the my

Poetry. Literary Nonfiction. In EVENING ORACLE, Brandon Shimoda encounters shadows, specters, and women—young and old, living and undead—and finds himself standing in a graveyard in the middle of a ri

The first complete guide to this ancient Greek form of divination ‧ Explains how to cast and interpret this oracle using either coins or traditional animal bones ‧ Reveals how the use of oracle bone

Discover your destiny with The Oracle of Rama, the great oracle of India, and one of the simplest to use. Like the I Ching, it consists of various verses that one can use to answer life's questions.

Welcome to the incredibly beautiful and intriguing world of the Tarot. The purpose of this book, "Rebirth of the Oracle - Tarot for the Modern World", is to simplify and demystify this ancient oracle

本書介紹了SQL的編程原理、基本原則、使用方法及技巧，包含數據庫設計基礎知識，第一範式、第二範式、第三範式的概念和範式間的轉換方法，涉及數據庫創建、單表查詢、多表查詢、更新數據、數據庫管理知識，並提供了常用SQL語句的案例速查表。公司使用SQL來管理訂單、物品、客戶和銷售代表的有趣案例貫穿全書，方便讀者跟隨進度逐步上手SQL。 本書可作為高等院校SQL或數據庫相關課程的參考教材，也可作為SQL的案例參考和函數速查手冊，適合有一定編程基礎、想要上手使用SQL的人閱讀。

*PRE-ORDER YOUR COPY TODAY*North Africa, 533 A.D. The last Vandal ruler faces the invading Byzantines. An oracle predicts defeat unless a sacred scroll is found . . . When an archaeological dig in T

Oracle of the Fairies is a modern deck for people who love nature and know that there is more to life than what can be seen with our physical eyes - use this oracle as the portal to the realm of fairy

Based on the groundbreaking Santa Muerte Tarot, this oracle is a powerful tool for working with the mysticism associated with the Day of the Dead and La Santa Muerte. Featuring masterful artwork by Fa

本書由世界知名的、實戰經驗豐富的Oracle ACE/ACE總監組成的作者團隊編寫，他們都寫過多本暢銷書籍，並且活躍在全球的Oracle巡迴演講現場。本書是為Exadata 數據庫一體機管理員(DMA，Database Machine Administrators)精心準備的一本真實環境的實踐操作指南和專家手冊。本書內容涵蓋Exadata數據庫一體機的11g和12c兩個軟件版本。針對Oracle數

Based on elemental forces that have been consulted by healers and sages for thousands of years, the dice oracle explored in this book is a simple practice that yields life-changing results. With just

本書以企業現場常見的情境為例進行解說，幫助您快速解決SQL開發上的疑難雜症，學到資料庫與大數據整合的概念，進而開發出企業級的應用系統。 本書精采內容包括： ．在4秒內將十年的微軟股價載入到資料庫 ．報表服務整合SQL Server R語言 ．直接輸出SQL Server R繪製圖片 ．使用SQL Server R建立預測模型 ．使用SQL Server R rxDTree演算法產生互動式決策樹 ．透過SQL Server R與Database Mail遞送數據與圖表 ．使用SQL Server R的資料採礦進行決策分析 ．整合Power BI與SQL Server R服務呈現數據與圖形 ．SQL Server直接產生XML與JSON資料格式 ．不為人知的OPENQUERY秘密功能大公開 ．如何在1秒內匯入40萬筆資料列 ．利用簡單T-SQL作為網路爬蟲

A fantastic oracle deck based on angels of the Kabbalah, the Tree of Life, Watchers, Seraphins, and more. The sense of being at the presence of something distinctly human, but ultimately mysterious is

The Rainbow Oracle deck features 40 individual color cards that can be used to give yourself and others accurate intuitive readings. Each of the colors used in the card pack have unique meanings and c

Celebrated illustrator Nicoletta Ceccoli draws in a style of provocative enchantment. These oracle cards provide insight into complex questions, where the dark mingles with the light and reveals the s

The speakers of Oracle occupy the outer-borough cityscape of New York's Staten Island, where they move through worlds glittering with refuse and peopled by ghosts—of a dead lover, of a friend lost to

Oracle Database 12c is the newest version of the Oracle flagship product. Arguably the biggest new feature for Oracle Database, Multitenant ushers in a totally new database architecture for Oracle. Th

This Oracle database upgrade exam covers Oracle Database Release 12c. There are admin questions as well as new features related questions. We create these self-practice test questions referencing the

Reinforce your Arabic language studies with lively, fun activities!The Mastering Arabic 1 Activity Book provides a wealth of practice material for all beginners who want to understand, speak, and read Modern Standard Arabic confidently. This second edition of the Activity Book has been updated to match the changes in Mastering Arabic 1: 3rd Edition. The twenty practice units in this Activity Book mirror the twenty units in Mastering Arabic 1, but this workbook can be used with any beginning Arabic course.Ideal for classroom use or self-study, the Mastering Arabic 1 Activity Book includes:*Over 100 carefully-paced, engaging, and varied activities to reinforce vocabulary and basic concepts*User-friendly lessons filled with cartoons, graphics, games and lively exercises that cover everyday topics like family, jobs, school, eating and drinking, and more*Plenty of reading and handwriting practice*Answer key at the back of the book helps students measure their progress

迎接海量資料(Big Data)的雲端新世紀主流，應運而生的是資料庫結構的轉變雲端世代資料庫必須具備海量規模以及更具彈性的結構，快速地與雲端接軌！本書以淺顯易懂的敘述和豐富的操作圖例，介紹全新Oracle系列產品包括：雲端作業系統Oracle Solaris 11.1、雲端資料庫Oracle Database 12c、雲端控制器Oracle Enterprise Manager Cloud Con

本書內容以資料庫的理論為基礎，結合實務的SQL SERVER 開發環境，輔以大量的實務範例解說，由淺入深的漸進鋪陳，配合作者獨創的表達方式來詮釋生硬的原理。讓『觀念』產生千變萬化的SQL 語法，讓『圖解』展現簡易的『SQL 語意』。‧ 獨創『SQL 圖解法』，詮釋生硬的SQL 語法，延伸T-SQL 的視覺學習效果。‧ 以『圖解』展現『觀念』，以『觀念』活用SQL，以SQL 創造『價值』。‧ 將枯燥

(Quick Pro Guides). From bedroom studios to the stages at Coachella, Auto-Tune pitch correction has become an integral part of music production and performance. Mastering Auto-Tune provides users of

Consult the Astrological Oracle for everyday inspiration and guidance. The dynamic energies of the signs and planets, depicted in attractive Art Nouveau-style artwork, offers crucial insight into the

Written over 350 years ago, The Pocket Oracle and Art of Prudence is a subtle collection of 300 witty and thought-provoking aphorisms. From the art of being lucky to the healthy use of caution, these

常在網路上看到有人這樣的求救： □ Oracle 我已經安裝好了，下一步呢？□ Oracle 的 DBA 密碼是什麼？□ Oracle 到底有幾個 DBA？□ 為什麼 Oracle 安裝完之後我的硬碟空間被吃掉一大塊？□ 為什麼 Oracle 安裝完 Create 資料庫後，記憶體被吃掉一大塊？ 這些問題都是因為急著安裝所致。面對 Oracle 這樣架構繁複的企業級資料庫系統，本書並不貿然躁進

不論是MIS或是資料庫應用程式的開發人員, 與SQL Server接觸最頻繁的方式就是透過T-SQL語言, 許多時候雖然可以取得正確的結果, 但是執行的效率卻很差, 或是無法查出自己想要的資料, 往往就是因為不瞭解各種T-SQL敘述背後的運作原理所導致, 因此若要善用T-SQL, 深入的瞭解各個T-SQL敘述的特性與效用就是很重要的事。 本書和一般SQL Server的書籍最大的差異, 就是將焦

《ORACLE數據庫精講與疑難解析》是一本毫無保留的Oracle學習寶典。通過作者歷時3年的寫作，《ORACLE數據庫精講與疑難解析》介紹了Oracle的安裝及卸載、數據庫的啟動關閉、表空間和數據文件的管理、Oracle網絡管理、口令文件管理、內存管理、進程管理、用戶管理、數據的導入導出、備份與恢復、模式對象的管理以及應用程序開發等相關知識。