tech.chococloud.com
SQL | chococloud/tech
http://tech.chococloud.com/category/oracle/development/sql
Purpose NULLIF compares expr1 and expr2. If they are equal, then the function returns null. If they are not equal, then the function returns expr1. You cannot specify the literal NULL for expr1. If both arguments are numeric… [more]. Syntax Purpose COALESCE returns the first non-null expr in the expression list. You must specify at least two expressions. If all occurrences of expr evaluate to null, then the function returns null. Oracle Database uses short-circuit… [more]. Real Application Cluster (111).
tech.chococloud.com
Advanced Application Development | chococloud/tech
http://tech.chococloud.com/category/oracle/development/advanced-application-development-development
Advanced Application Development chococloud/tech. Stages of SQL Statement Processing. Open or create a cursor. A program interface call opens or creates a cursor. The cursor is created independent of any SQL statement: it is created in expectation of a… [more]. Oracle Database and Instance. Internal LOBs An internal LOB stores data in the database itself rather than in external files. Internal LOBS include the following: CLOB (character LOB), which stores large amounts of text, such as… [more]. The globa...
tech.chococloud.com
4 Partitions, Views, and Other Schema Objects | chococloud/tech
http://tech.chococloud.com/4-partitions-views-and-other-schema-objects-2
4 Partitions, Views, and Other Schema Objects chococloud/tech. 4 Partitions, Views, and Other Schema Objects. Although tables and indexes are the most important and commonly used schema objects, the database supports many other types of schema objects, the most common of which are discussed in this chapter. This chapter contains the following sections:. Overview of Materialized Views. In an Oracle database, partitioning. From the perspective of an application, only one schema object exists. DML. So queri...
tech.chococloud.com
11 Physical Storage Structures | chococloud/tech
http://tech.chococloud.com/11-physical-storage-structures-2
11 Physical Storage Structures chococloud/tech. 11 Physical Storage Structures. Is chapter describes the primary physical database structures of an Oracle database. Physical structures are viewable at the operating system level. This chapter contains the following sections:. Introduction to Physical Storage Structures. Overview of Data Files. Overview of Control Files. Overview of the Online Redo Log. Introduction to Physical Storage Structures. Data files and temp files. Online redo log files. Is a set ...
tech.chococloud.com
3 Indexes and Index-Organized Tables | chococloud/tech
http://tech.chococloud.com/3-indexes-and-index-organized-tables-2
3 Indexes and Index-Organized Tables chococloud/tech. 3 Indexes and Index-Organized Tables. This chapter discusses indexes, which are schema objects that can speed access to table rows, and index-organized tables, which are tables stored in an index structure. This chapter contains the following sections:. Overview of Bitmap Indexes. Overview of Function-Based Indexes. Overview of Application Domain Indexes. Overview of Index-Organized Tables. That can sometimes speed data access. Indexes are. To a singl...
tech.chococloud.com
7 SQL | chococloud/tech
http://tech.chococloud.com/7-sql-2
This chapter provides an overview of the Structured Query Language ( SQL. And how Oracle Database processes SQL statements. This chapter includes the following topics:. Overview of SQL Statements. Overview of the Optimizer. Overview of SQL Processing. Is the set-based, high-level declarative computer language with which all programs and users access data in an Oracle database. SQL provides an interface to a relational. Creating, replacing, altering, and dropping objects. For an introduction to SQL. Such ...
tech.chococloud.com
Introduction to Algorithms : Prof. Charles E. Leiserson (MIT) | chococloud/tech
http://tech.chococloud.com/category/data-structures-and-algorithms/introduction-to-algorithms-prof-charles-e-leiserson-mit
Introduction to Algorithms : Prof. Charles E. Leiserson (MIT) chococloud/tech. Introduction to Algorithms : Prof. Charles E. Leiserson (MIT). Our apologies, nothing was found. It seems we can’t find what you’re looking for. Perhaps searching can help. Advanced Application Development (110). Data Warehousing and Business Intelligence (57). Automatic Storage Management (35). Real Application Cluster (111). Backup and Recovery (64). Oracle Documentation (PDF) (30). Application Development (PDF) (12).
tech.chococloud.com
Data Structures and Algorithms in Java | chococloud/tech
http://tech.chococloud.com/category/data-structures-and-algorithms/data-structures-and-algorithms-in-java
Data Structures and Algorithms in Java chococloud/tech. Data Structures and Algorithms in Java. Our apologies, nothing was found. It seems we can’t find what you’re looking for. Perhaps searching can help. Advanced Application Development (110). Data Warehousing and Business Intelligence (57). Automatic Storage Management (35). Real Application Cluster (111). Backup and Recovery (64). Oracle Documentation (PDF) (30). Application Development (PDF) (12). Database Administration (PDF) (8).
tech.chococloud.com
Data Structures and Algorithms | chococloud/tech
http://tech.chococloud.com/category/data-structures-and-algorithms
Data Structures and Algorithms chococloud/tech. Data Structures and Algorithms. Our apologies, nothing was found. It seems we can’t find what you’re looking for. Perhaps searching can help. Advanced Application Development (110). Data Warehousing and Business Intelligence (57). Automatic Storage Management (35). Real Application Cluster (111). Backup and Recovery (64). Oracle Documentation (PDF) (30). Application Development (PDF) (12). Database Administration (PDF) (8). Grid Computing (PDF) (2).
tech.chococloud.com
8 Server-Side Programming: PL/SQL and Java | chococloud/tech
http://tech.chococloud.com/8-server-side-programming-plsql-and-java-2
8 Server-Side Programming: PL/SQL and Java chococloud/tech. 8 Server-Side Programming: PL/SQL and Java. Chapter 7, “SQL”. Explains the Structured Query Language (SQL) language and how the database processes SQL statements. This chapter explains how Procedural Language/SQL (PL/SQL) or Java programs stored in the database can use SQL. This chapter includes the following topics:. Introduction to Server-Side Programming. Overview of Java in Oracle Database. Chapter 7, “SQL”. Or Java translator before compila...