Results 251 to 260 of about 82,951 (280)

Knowledge-to-SQL: Enhancing SQL Generation with Data Expert LLM

Annual Meeting of the Association for Computational Linguistics
Generating accurate SQL queries for user questions (text-to-SQL) has been a long-standing challenge since it requires a deep understanding of both the user's question and the corresponding database schema in order to retrieve the desired content ...
Zijin Hong, Zheng Yuan, Hao Chen, Qinggang Zhang, Feiran Huang, Xiao Huang   +5 more
semanticscholar   +1 more source

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

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

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

Standardizing T-SQL

2020
Before I start talking about how to write queries for complex scenarios, I want to focus on how to write good T-SQL. This is not about writing code that performs well. This is about writing T-SQL code that reads well. I want to go over how to write code so that it is easily readable to others and to yourself.
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

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

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