Firebird currently supports two other forms of derived table: the selectable stored procedure and the external virtual table (EVT).
Selectable Stored Procedures
Firebird’s PSQL extensions provide syntax for defining a stored procedure that outputs a derived set of data from virtually anywhere: from the database, from context variables (even from input variables alone), from external tables, or from any combination. PSQL and DSQL SELECT syntax provides for these virtual tables to be retrieved just as though they were real tables.
The output set for a selectable stored procedure is defined as a set of output variables, using the RETURNS clause of a CREATE PROCEDURE statement. The output data is created by looping through a cursor set, defined by a SELECT statement, and reading the values of the specified columns into these output variables or into declared local variables. Within the loop, almost anything can be done to manipulate the data, including processing embedded loops. A selectable stored procedure can be called from (embedded in) another stored procedure. Anything that can be selected, calculated, or derived can be transformed to output.
As a simple illustration, the following stored procedure declaration sets up a loop and proceeds to pass processed rows, one at a time, to the output buffer:CREATE PROCEDURE SHOW_JOBS_FOR_COUNTRY (
When the stored procedure is compiled, it is ready for action. Retrieval of the set is by way of a slightly specialized SELECT statement that can, if required, take constant arguments as input parameters:
External Virtual Tables
An external virtual table (EVT) is a table that gets its data from some external data source rather than from the database. The results of a query on an EVT are treated in exactly the same way as the results of any other query, and they look exactly as if they came from a database table. This allows the integration of external data such as real-time data feeds, formatted data in operating system files, other databases (even non-SQL databases), and any other tabular data sources.
Firebird implements EVTs by means of the EXTERNAL FILE clause of the CREATE TABLE statement. External data is read from fixed-format text records into regular Firebird data columns.
Firebird external tables can also insert records into EVTs.
Firebird Related Interview Questions
|RDBMS Interview Questions||MySQL Interview Questions|
|Linux Interview Questions||Mac OS X Deployment Interview Questions|
|Windows Administration Interview Questions||Windows Server 2003 Interview Questions|
|SQL Interview Questions||NoSQL Interview Questions|
|Advanced C++ Interview Questions|
Introduction To Client/server Architecture
About Firebird Data Types
Date And Time Types
Blobs And Arrays
From Drawing Board To Database
Creating And Maintaining A Database
Firebird’s Sql Language
Expressions And Predicates
Querying Multiple Tables
Ordered And Aggregated Sets
Overview Of Firebird Transactions In
Programming With Transactions
Introduction To Firebird Programming
Developing Psql Modules
Error Handling And Events
Security In The Operating Environment
Configuration And Special Features
Interactive Sql Utility (isql)
Database Backup And Restore (gbak)
Housekeeping Tool (gfix)
Understanding The Lock Manager
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.