Results 231 to 240 of about 228,587 (259)

Overview of SQL

2014
The Structured Query Language (SQL) has become the universal language of choice for DBMS products. A study of this language is therefore imperative for the student of computer science or computer information systems. This and the next few chapters will help you acquire a working knowledge of the language, as implemented in the Oracle environment.
Shripad V. Godbole, Elvis C. Foster
openaire   +2 more sources

Graphs in SQL

2005
A graph is a data structure made up of nodes connected by edges. Edges can be directed or undirected. The number of edges entering a node is its indegree; likewise, the number of edges leaving a node is its outdegree. A set of edges that allow traveling from one node to another is called a “path.” The most common way to model a graph in Structured ...
openaire   +2 more sources

Parallel SQL on Tandem's NonStop SQL

Digest of Papers. COMPCON Spring 89. Thirty-Fourth IEEE Computer Society International Conference: Intellectual Leverage, 2003
A comparison is made of a number of different strategies for the concurrent execution of multiple SQL (structured query language) statements on a completely nonsharing multiprocessor system. The author gives some preliminary results in the form of heuristics derived from measurements on a Tandem system.
openaire   +2 more sources

PL/SQL from SQL

2011
Functions are an integral part of any well-designed PL/SQL application. They are an embodiment of programming best practices, such as code modularization, reuse, and the encapsulation of business or application logic. When used as simple building-blocks for larger programs, they can be an elegant and simple way to extend functionality while reducing ...
openaire   +2 more sources

SQL and PL/SQL by Example

2015
All database activity is conducted in SQL, and therefore database administrators need to be intimately familiar with it. Figure 2-1 illustrates that the greatest potential for performance improvement usually lies within the software application, not within the database where the application stores its data or within the physical infrastructure where ...
openaire   +2 more sources

Gruppierungen in SQL

2011
Im vorherigen Kapitel wurden alle wichtigen Sprachkonstrukte von SQL zur einfachen Verknupfung von Tabellen vorgestellt. SQL-Anfragen bieten neben der reinen Tabellenverknupfung auch die Moglichkeit, Auswertungen fur einzelne Attribute oder fur mehrere Attribute durchzufuhren. Damit kann man z. B.
openaire   +2 more sources

Introduction to SQL and SQL Developer

2014
This is the first chapter with real SQL statement examples. It thus would be beneficial for you to have access to an Oracle database and a schema with the seven case tables introduced in Chapter 1 and described in detail in Appendix A. You can find the scripts to create that schema in the download hosted from this book’s catalog page or the Source Code
openaire   +2 more sources

The SQL Workshop

2015
Congratulations! You are on the brink of learning how to build APEX web applications. But before you can begin, you need an APEX account. There are several ways to obtain an account: you can register for a free account through the apex.oracle.com web site; you might be given an account to an APEX server at your job; or you can even install an APEX ...
openaire   +2 more sources

Introduction to SQL

2003
This chapter presents an overview of the SQL database language. It covers the language’s history, as well as the software environments that provide an interface to database management systems. It concludes with a discussion of the elements of a SQL statement.
openaire   +3 more sources

SQL/TP: A Temporal Extension of SQL

2000
Research in the area of temporal databases and query languages has produced a large number of proposals for temporal extensions of SQL; however, none of these proposals has been used in commercial database management systems nor become a basis for foundations of temporal database theory.
openaire   +2 more sources