SQL Engine - Result Set

Oracle Database Sql Processing

About

The result of a query is stored in a result table, called the result-set.

An SQL result set is a set of rows from a database, as well as meta-information about the query such as the column names, and the types and sizes of each column. A result set is effectively a table.

See also: Sql Engine - Row Set





Discover More
Data System Architecture
Database - Client Result Cache

Automatically caches results sets on client Accessible across the same process to different sessions with same user settings Cache remains consistent via DB Change Notification No .NET code changes...
Model Funny
Function - Display Function

A display function is a function that operates on the result set of a query. They computes their result on a query result set such as: ranks, Ntiles, standard deviations, running totals,...
Jdbc Class Architecture
JDBC - Resultset (SELECT|SQL query)

The java/sql/ResultSetResultSet interface encapsulates the results of an SQL query and implements a cursor API. Statements may also be batched, allowing an application to submit multiple updates to a data...
Obiee Agent Cache Seeding
OBIS 10G/11G - BI Server (Logical Query|Result) Cache

Query caching is a persistent cache mechanism. When you ask for data with a query, the data are retrieved from the cache instead to ask again the data source. The BI Server Query Cache The Presentation...
Saw Object
Obiee - The SearchId (Sid) - ResultSet ID

Answers assigned unique ID to result set associate with an answers request (called SID). If you want to retrieve the data set from an answer call, you can pass this parameter in a Go Url to retrieve the...
Card Puncher Data Processing
Oracle Database - PL/SQL - Result Sets from Stored Procedures

ORACLE supports procedures (functions) which returns result sets. Thus, a stored procedure can act as a table or a view. Here is an example on the HR schema with a cursor variable:
Card Puncher Data Processing
Oracle Database - Result Set

Oracle does not return Result Sets.
Data System Architecture
Ordinal Data - TopN (Analysis|Function)

Top 'N' Analysis in general refers to getting the top-n rows from a result set. find the top 3 employees ranked by salary: thats a top-n type query. Top...
Oracle Database Sql Processing
RDBMS - Sql Processing (Engine)

A SQL engine is responsible to produce a result set on the client side (generally backed by a cursor on the back-end side) from a SQL statement. See Every relational database has an SQL engine:...
Data System Architecture
SQL - Query (SELECT)

A query is a SQL statement that begins with the SELECT word. A stored query is called a view. The result of a query is stored in a result table, called the result-set. A query is itself a Relations...



Share this page:
Follow us:
Task Runner