Firebird does not currently provide any form of temporary table that is managed as such by the system. It has less need for them than many other DBMSs have. For example, Firebird has the capability to output a virtual table directly from a stored procedure that is written with a specific syntax.
Permanent “Temporary” Tables
A popular model for storing temporary data for applications to access is to define a permanent structure for the data that includes a “session ID” or “batch ID” acquired from a generator or, in Firebird 1.5, the CURRENT _TRANSACTION value. Applications can insert, reprocess, and delete rows in such a table during the course of a task. Remember, Firebird does not put locks on tables in the normal course of events.
According to the conditions and needs of the application, it can itself be responsible for deleting the temporary rows when its session completes, using the session ID for a searched delete. Alternatively, the application could post a row to a housekeeping table signaling “cleanup required” to a later, deferred operation that runs after hours, before a backup.
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.