Since 1996 Benthic Software has produced high quality database tools for Oracle and other SQL databases. Our products are high performance Windows programs that. FlySpeed SQL Query is an easy data handling tool for all database users and developers. It allows you to build queries on different database servers without. Looking for books on Oracle? Check our section of free e-books and guides on Oracle now! This page contains list of freely available E-books, Online Textbooks and. FlySpeed SQL Query Free SQL Query Tool for any database. Oracle® Hyperion Smart View for Office User's Guide Release 11.1.2.3 Updated: July 2013. SQL Query Builder, SQL Parser and analyzer. Active Query Builder allows your end- users to build complex SQL queries via the intuitive drag'n'drop interface. It lets parse, analyze and modify even complex SQL queries programmatically. Active Query Builder is a true two- way SQL query builder: the end- user can combine visual query building with direct SQL query text editing. Active Query Builder is an ultimate helper for your work with SQL queries! Active Query Builder renders all SQL features, such as table joining, data grouping, sorting and filtration easy to accomplish and allows to build complex SQL with sub- queries and unions. The interface of Active Query Builder is familiar to most database users. Visual query builder lets adding tables and fields to the query by drag & drop. Active Query Builder lets design sub- queries on separate tabs, edit their texts independently from main query and preview the sub- query results. Learn more about building queries visually with Active Query Builder »Active Query Builder can parse an SQL query of any complexity and build its diagram to represent a query visually. You can replace unclear object names with descriptive aliases, remove unwanted objects and add virtual objects and fields, group objects in the tree the way you need, etc. File description Version Date Size Download; EMS SQL Manager for PostgreSQL (full installation package) 5.9.1.49393: 04/26/2017: 81.27 Mb: Download: EMS SQL Manager. With Active Query Builder you can give obvious view of any database schema for your end- users. Learn more about Customizing user environment and database schema view »Active Query Builder is a true two- way query builder, the end- user can combine visual query building with direct SQL query text editing. SQL text formatting lets beautify SQL query text to ease it's understanding. Learn more about SQL text editing with Active Query Builder »Queries often need to be changed when browsing the result data, so sorting, filtration, totals calculation and pagination must be easy for end- user and programmer. Active Query Builder provides the tree- like SQL filter builder lets quickly find the needed data. The special query transformation API is available to meet these needs. Changes made to the query during the end- user work session can be saved and restored afterwards. Learn more about SQL filter builder and SQL changes for easy data browsing »Active Query Builder can load database schema from various DB connections, use different data access components and load metadata from custom sources, such as . NET datasets. You can filter unwanted objects by defining own metadata loading rules, remove them programmatically one by one. You can fill database schema information programmatically in case of working with custom data sources or web services. Once loaded, metadata can be saved to XML and then loaded without establishing live database connection for each work session. Learn more about metadata management and filtration in Active Query Builder »Active Query Builder API gives you full control over SQL queries. You can parse SQL queries for different database servers, get information about used database objects and fields, perform deep SQL query analysis at the object model level and at the level of SQL token syntax tree, programmatically change SQL queries and create queries from scratch. This lets you deny execution of unwanted queries or seamlessly add the necessary conditions to prevent unauthorized access to data. Active Query Builder gives the list of parameters used in the query, letting you know to which fields and objects they are applied to. Learn more about analyzing and modifying SQL queries with Active Query Builder »Active Query Builder's SQL Parser supports SQL syntax dialects of Oracle, MS SQL Server, Azure, My. SQL, Postgre. SQL, SQLite, MS Access, Inter. Base, Firebird, DB2, Informix, Sybase, Advantage DB, Netezza, Teradata. It correctly handles fine points of each supported SQL dialect. Building parsed queries visually Active Query Builder keeps every single query clause during the query building process with no losses. Being compatible with ANSI SQL/9. SQL/8. 9 and SQL/2. Active Query Builder works fine with many other ANSI SQL- compatible database servers, such as Vista DB, Nexus, Elevate DB, Redshift, Vertica, Progress, Pervasive, Amazon Aurora, and so on. The component can be integrated into your application with a few lines of code. Designed to increase productivity, this application. Oracle Optimizer hint tips. Oracle Tips by Burleson Consulting February 21, 2015. Active Query Builder. SQL Query Builder Visual Query Builder, SQL parser and data retrieval assistant Visual component for WinForms.NET, WPF, ASP.NET, Delphi/C+. Oracle Map Builder Hints and Tips Introduction Increasingly, Oracle applications are being shipped with Business Intelligence road map includes the ability to. SQL query builder that doesn't make you learn SQL. The Knowledge Base, documentation and numerous demo projects allows for mastering the component for a few days.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
August 2017
Categories |