Follow on Google News News By Tag Industry News News By Location Country(s) Industry News
Follow on Google News | XtractPro Launches Query Xtractor, a Visual Query Builder and SQL GeneratorQuery Xtractor is a visual SQL query builder, generator and runner, as a productivity tool.
By: XtractPro Generic vendor-independent interface and universal support for over a dozen database platforms, including Oracle and Microsoft SQL Server, MySQL and PostgreSQL, SQLite and Firebird, cloud databases such as Amazon Redshift and Microsoft SQL Azure Database. Major Features in Query Xtractor version 1.0 include: • Emulation of missing features, such as pivot/cross tables and grouping sets. • Emulation of intersect/except, extended aggregate functions, ALL/ANY etc, when not implemented. • Extended sort with NULLs first or last in any database. • Learn SQL from generated demo queries or queries you design from scratch. • Type less and let us auto-quote identifiers and handle internal SQL aliases. • Automatic fix of known SQL gotchas, NULL or math problems, vendor-specific inconsistencies. • Switch from nested subqueries to CTEs, for multiple SQL query views. • Use complex window functions. • Auto-detected lookup fields and powerful drill-down on relationships. • Visual effects, with graphic bar columns, same icons for duplicates, unique value detection etc. For more details on the new software release, please see our presentation screens (https://data- End
Account Email Address Account Phone Number Disclaimer Report Abuse
|
|