oracle sql syntax
Gorilla SQL 0.3
Gorilla SQL is considered as a professional and helpful network communication program. more>> Gorilla SQL 0.3 is considered as a professional and helpful network communication program. Gorilla SQL is a cross platform, universal sql client manager. Now you can connect to PostgreSQL (native), MySQL (native), Microsoft Access / SQL Server or other ODBC databases with one program.
Gorilla SQL also known as Gsql, is a straight SQL client which allows you to execute sql commands to any of its native or ODBC databases.
Gsql supports joins, sort results, supports inserts, updates and deletes. Also Gsql has supports bookmark sql commands, history commands and many other functions to make your time on your database more efficient. It is, the all in one universal sql client. Any command your database accepts, Gsql supports.
- Export results to XML or delimited format.
- Table schema window. Allows you to drag table and field names into the query box.
- Fixed Welcome Window.
- OpenBase Support Now Added. Now native support for OpenBase, PostGres, Mysql and ODBC (Any ODBC DB (mysql, access, exel etc...)
- Improved Error Checking
Requirements: Mac OS X 10.2 or later.
Oracle SQL Developer 1.5.4.59.40
Graphical tool that enhances productivity and simplifies database development tasks. more>>
Graphical tool that enhances productivity and simplifies database development tasks. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own.
SQL Developer can connect to any Oracle Database version 9.2.0.1 and later. We support SQL Developer running on Windows, Linux and Mac OS X.
Oracle SQL Developer enhances productivity and simplifies ...Oracle SQL Developer is a powerful graphical application that enhancesSQuirrel SQL Client 2.5
SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database more>>
The minimum version of Java supported is 1.5.x as of SQuirreL version 2.4. See the Old Versions page for versions of SQuirreL that will work with older versions of Java. SQuirreLs functionality may be extended through the use of plugins.
Main features:
Object Tree of Session window
- Right-click to access the popup menu which provides access to advanced script generation and graphing features. The graph plugin allows the user to create table charts.
SQL Editor with code completion popup (ctrl+space) open
- Code completion can be used to access drop-down lists of options that include keywords, tables, columns, views, stored procedures. Code completion also provides join generation functions.
SQL Editor with tools popup menu (ctrl+t) shown
- With the tools popup any editor function can be located with only a single short cut: ctrl+t
- Additionally, the list can be searched incrementally with just a few keystrokes.
SQL Editor with bookmark selection popup (ctrl+j) shown
- Bookmarks are user-defined code templates. SQuirreL comes with several pre-defined example bookmarks for the most common SQL and DDL statements.
Abbreviations and auto corrections dialog
- This feature works much like auto corrects in common office products. With the entries shown in the dialog you may for example type sf which will expand to SELECT * FROM.
Editing of SQL results.
- The result tabs of SQL queries support editing the rows returned from a query on a single table. You may also edit the contents tab of tables in the Object tree.
Graph: Charts of tables and their relations.
- To create new charts or to add tables to existing charts right mouse click tables in the Object tree and choose the Add to graph menu. Graph manipulation functions can be accessed by using the right-click context popup menu.
Graph: Scaling and distributing tables on configurable page sizes to prepare for printing
- Use the right-click context popup menu to switch to the scaling and printing mode.
Enhancements:
- Enhancements
- New plugins provide enhanced capabilities:
- DB2 Plugin: Stored Procedures, Triggers and Views are shown in the object tree and have a Source tab which displays the source of the selected object and a Details tab which gives DB2-specific information about the object. Sequences and Indexes are also shown in the object tree and have a details tab giving DB2-specific information about them.
- H2 Plugin: Indexes and Views are shown in the object tree and have a Source tab which displays the source of the selected object and a Details tab which gives H2-specific information about the object. Sequences and Indexes are also shown in the object tree and have a details tab giving H2-specific information about them.
- PostgreSQL Plugin: Stored Procedures, Triggers and Views are shown in the object tree and have a Source tab which displays the source of the selected object and a Details tab which gives PostgreSQL-specific information about the object. Sequences and Indexes are also shown in the object tree and have a details tab giving DB2-specific information about them.
- Sybase Plugin: Allows the user to reverse engineer to the source code for Views and Stored Procedures displayed in the object tree.
- Added better support for executing large scripts so that SQuirreL remains responsive to UI interaction, as well as providing much faster execution.
- Added custom statement tokenizer framework to allow plugins to control how statements are tokenized.
- Drop tables, Delete Records and Copy Tables features now will order the tables according to Foreign Key dependencies instead of alphabetically by name.
- Oracle Plugin now supports executing create statements for triggers, stored procedures and functions using "/" just as is done in SQL-Plus. Also "@" can now be used to indicate a file to be parsed and executed while running another script in SQL Editor.
- SQL History Dialog allows for searching previously executed statements by regular expression.
- Many bug fixes
Oracle JDeveloper 11.1.1
Oracle JDeveloper - a J2EE and XML development environment with end-to-end support for developing applications and Web services more>>
We spent more time than ever in this release listening carefully to what our users need in order to make them more productive. We also embarked on an intensive design and usability review by an external company.
The result of these efforts is a huge leap forward in the speed in which developers can create, assemble, and reuse components to build rich, interactive applications that are highly performant and easy to maintain.
Enhanced use experience
There have been many updates throughout the product to make working with JDeveloper a pleasant experience. These improvements are not restricted to a particular type of development, but have been applied consistently to all areas of the design time.
Enhanced navigator: The Application Navigator has been enhanced to organize your application the way you want. New categories make it easier for you to find what you are looking for. Collapsible panels put common elements of your application within easy reach. Files that make up a composite node are conveniently exposed by simply clicking on the composite node.
Improved Component Palette: The component palette now features collapsible panels and divider sections to organize related components. A quick search field is provided to help locate components. You can now add commonly-used components to your Favorites list for easier access later, and another panel keeps track of your recently used components.
New Property Inspector: The Property Inspector has been redesigned with a new, user-friendly layout. Property categories have been used consistently throughout the product to make using the Property Inspector more predictable.
Application Overview: The new Application Overview window provides a convenient listing of all the sources for your application, grouped into helpful categories. From here, you can get a sense of the overall status of your application (which sources are incomplete, which have errors, etc) too. The Application Overview also functions as a way for you to learn about the various kinds of components you may use in your application, and easily launch wizards to create them.
File List: The File List makes it easier than ever to locate source files that are part of your project. You can search by file name, file extension, status, date modified and more.
Updated appearance: The JDeveloper development environment has been updated with a brand-new look.
Integrated modeless editors: Many editors for components have been converted to integrated modeless editors. These appear in the editor area along with the other editors, and allow for much more productive navigation.
Contextual linking: Contextual linking is the concept that as you are working on something, you should be able to easily get to relevant related resources. For example, as you are working on defining a page flow for databound pages, you should be able to easily get to the page definition of those pages. This concept is now employed wherever it makes sense in the development environment.
Resource Catalog
The Resource Catalog is your window onto the many disparate resources your application may need to consume. It allows you to define connections to the resource providers, and drag-and-drop those resources into your application as needed. The resource catalog provides a search tool to search all the defined repositories in a single action.
Connections can be created for the following types of resource repositories:
Application server
Database
File system
UDDI Registry
URL adapter
WebDAV
New diagramming framework
The internal diagramming framework used to build the UML tools in JDeveloper, the Page Flow diagrams, and other visual editors has been re-architected to be more flexible for internal consumers.
Java Coding and Agile Development
New code generators
New generators have been added for generating equals and hashcode and to simplify generating fields and properties with getters and setters and to generate constructor from fields
Updated JUnit 4.0 support
JDeveloper now generates unit tests using JUnit 4 annotations. The integrated runner has been updated to support JUnit 4, including new instructions, such as @ignore.
New profilers
The new profilers leverage JVMTI and therefore run on any certified Java VM. Oracles OJVM is no longer required for profiling.
CPU Profiler
Memory Profiler
XML Compare
Comparing of XML files is now done using an XML-aware algorithm. In previous releases compare was done using a line algorithm with no understanding of the syntax of the file content. XML is used extensively within JDeveloper (projects, diagrams, ADF artifacts) and the characteristics of the file content will be understood by the tool.
For example if an XML elements attributes are reordered the compare tool will not mark that as a change - the attributes (name and value) are the same, but in different positions.
The compare tool is used by all the version control extensions to compare file content with previous versions. Compare is also used by the local history feature to compare content between saved points.
Enhanced Merge Conflict Resolution for Subversion and CVS
JDeveloper now provides an enhanced XML-aware interactive GUI to browse and update unresolvable conflicts reported during the merge process.
Navicat Oracle Lite 8.1.2
Navicat Oracle Lite offers users a useful and user-friendly Database administration tool for Oracle. more>>
Navicat Oracle Lite 8.1.2 offers users a useful and user-friendly Database administration tool for Oracle. It works with any Oracle Database Server from version 8i or above, and supports most of the latest Oracle objects features including Directory, Tablespace, Synonym, Materialized View, Trigger, Sequence, and Type, etc. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to Oracle.
Benefits:
- Latest Oracle Versions Support: Navicat for Oracle a powerful Oracle Database Server administration and development tool. Highlights of supported features:
-
- Support of Oracle versions 8.1.7 or above
- Support of Multiple Connections to local or remote Oracle Server
- Support of Unicode / Character Set
- Support of Triggers and Foreign Keys
- Support of Views and Stored Procedures creation
- Support of Oracle Objects like Directory, Synonym and Materialized View
- Additional Connection Options
-
- Native Connection Options: Navicat for Oracle offers two connection modes to the Oracle server: connection through the Oracle Call Interface (OCI) in Basic mode and alias entry from a tnsnames.ora file in TNS mode.
- Other Connection Options: You can set the role for user to connect with Default, SYSOPER or SYSDBA system privilege. Besides, you can pass control of user authentication to the operating system by means of OS authentication option.
- Support of SSH Tunnel: Establish a secure SSH session through SSH Tunneling in Navicat. Enjoy a strong authentication and secure encrypted communications between two hosts. The authentication method can use a password or public / private key pair.
- Comprehensive Management of Oracle objects
-
- Create, edit and drop table's fields, indexes, foreign keys, uniques, checks, triggers and privileges: With Table Designer the basic Navicat for Oracle tool for working with tables, you can create, edit and drop table's fields, indexes, foreign keys, checks, triggers, privileges and much more.
- Support of tablespace, package, sequence, synonym, trigger, type and more: Navicat allows you to create, edit and drop directories, tablespaces, publice database links, public synonyms, database links, indexes, materialized views, materialized view logs, packages, sequences, synonyms, triggesr and more.
- SQL Preview: The SQL Preview area shows you SQL representation of the oracle objects you are creating. This ability allows you to preview SQL before execution.
- Dump object definition as sql file: Backup object definition and data with ease by dumping as sql file.
- View Schema / Table Structure: Present the schema / table definition by printing their structures in Navicat. Understand the respective object structure fully at a glance.
- Diversified Import and Export Competence
-
- Import data up to 5 most popular formats including XLS, CSV, TXT, DBF and XML: Import Wizard allows you to import data into a table from diverse format. On top of that, you can save your settings as an import profile for setting schedule.
- Export Data to different file formats: TXT, CSV, DBF and XML: Likewise, Export Wizard allows you to export data into various format. Save your settings as an export profile for setting schedule.
- Powerful Data Manipulation Tools
-
- Support of Foreign Key Data Selection: With the GUI tool Foreign Key Data Selection, you can locate the foreign key values from the reference table. Stop shifting the view to a master table to look for the available values!
- Data and Structure Synchronization: You can transfer data from one Oracle schema to another with detailed analytical process. Likewise, you can compare and modify the table structures. For both Data and Structure Synchronization, the target schema can be on the same server as the source or on another server.
- Support of Data Transfer between local / remote Oracle schemas: Transfer tables/views/stored procedures/functions/sequences from one Oracle schema to another, or to a plain text file.
- Create Schedule for Import / Export, Data Transfer, Saved Queries and Data Synchronization: Create a batch job for setting schedule to execute at one or more regular intervals, beginning and ending at a specific date and time. Batch job can be created for Query, Data Transfer, Data Synchronization, Import and Export.
- Powerful Security Management
-
- Visual User Manager: Navicat provides users a visual tool for user management. You can easily add, delete, edit users / roles, and grant privileges on the selected schemas, tables / views, fields and stored procedures.
- Well-Designed Visual Builder / Editor
-
- Visual Query / View Builder: Visual Query / View Builder which is divided into two portions: the upper Graphical View, and the lower Syntax View, allows you to create and edit queries / views visually without knowledge of SQL.
- Query Editor: It allows you to create and edit SQL text for a query, prepare and execute selected queries.
- Support of Parameter Query: Set query parameters to add variable values to a query each time you run it.
- More great features
-
- Virtual Grouping: Have a better organization over objects in Navicat. You can categorize objects into groups with the Virtual Grouping feature. Virtual Grouping can be applied on Connection, Table, View, Stored Procedure/Function and Schedule.
- Server Monitor: Select the servers that you want to monitor by checking them in the checklist box of the Server Monitor Window. Click on either Process List, Variables or Status icon to show and/or modify the properties of Oracle servers.
- SQL Console: To use a command-line interface, you can open SQL Console in Navicat. It provides you an interactive text-based screen to query input and result output from database.
- Tabbed Windows: Customize your window behaviour style. Navicat supports you of dragging windows in and out of the tabbed windows.
- Oracle Objects Management
- Support Oracle servers 8i or above
- Create/drop schemas
- Support all Oracle objects: tables (Normal, External and Index Organized), views, stored procedures/functions
- Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers
- Managing tablespaces, public database links and public synonyms
- Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin
- Support of physical attributes
- Support of character set and unicode
- Connection Management and Navigation
- Multiple local/remote Oracle server connections
- Support of Basic Connection
- Support of TNS Connection
- Connection to Oracle server through SSH
- Data Viewer and Editor
- Grid view
- TEXT, Hex and BLOB/BFile viewer/editor
- Copying and pasting selected records
- Customize display formats
- Incremental search, sorting and formatting table grid
- Ability to show/hide ROWID
- Ability to set number of records showing on each page
- SQL Processing
- Ability to create parameter queries
- Multiple SQL editors with syntax highlighted feature
- Ability to preview SQL before execution
- Server Security and Maintenance Services
- Visual user manager to administer users, roles and privileges
- Maintaining tables like Table Lock, Row Movement, Shrink Space, Table Move, Validate Table Structure and Collect Table Statistics
- Other Useful Features
- Empty/truncate tables
- Backing up schema/table to SQL script
- Executing SQL script
- Create table/view shortcut on desktop
- Support of docking/tab windows
- Ability to run profile from command line
- Log files: keep track on the actions that have been performed in Navicat
- Ability to copy Connection Information into Clipboard
- Improvements: Improved the stability when running a query.
- Bug Fixes: Some windows size and position were not saved after closed.
- Mac OS X 10.3 Panther, 10.4 Tiger or 10.5 Leopard
- Universal Binary
area shows you SQL representation of the oracle objects you are creating. This ability allows ... Multiple SQL editors with syntax highlighted feature. Ability to preview SQL before executionLicense:Freeware
Eclipse SQL 3.5.0 RC8
A thin SQL client that allows you to query and browse any JDBC compliant database more>>
Eclipse SQL 3.5.0 RC8 provides you with a professional and useful thin SQL client which can allow you to query and browse any JDBC compliant database.
Eclipse SQL Explorer supports plugins with specialized functionality for individual databases (Oracle, DB2 and MySQL) and can be extended to include specialized support for other databases. Eclipse SQL started as a fork from the original JFaceDb project which has gone commercial and uses some of the core libraries of the SQuirreL SQL project.
Major Features:
- Oracle Specific Features;
- Query Execution Explain Plan
- Function, JavaSource, Package, Procedure, Sequence and Trigger Nodes
- Session, User, Job, Top SQL and Parameter info for database node
- Source, Info, DDL and XML tabs for most of the nodes
- DB2 Specific Features:
- Query Execution Explain Plan
- Triggers Node in Database Structure View
- Trigger Source Displayed in Database Detail View
- MySQL Specific Features:
- Create Table Script Action
- Logs, Processes, Status, Variables and TableStatus detail tabs
Enhancements:
- Added preference to control sorting of column names in db structure view (feature #2663329, bug #1611426)
- Fixed problem that double click in file search results does not select found line in SQLEditor
- Added preference to show session name in SQL editor title too (feature #2638982)
- Fixed #2687620, general solution triggered from SQLite bug
- Fixed auto completion using table alias (Patch #2643772 by seekforth)
- Some internal changes (Patches #2637474,#2633721,#2633365,#2633298 by joco01)
- New action Generate Insert Statement (Patch #2695812, part of feature #1590278 by a_lazar)
- Fixed #1200935, missing foreign key in create table script (Patch #2708377 by sishi)
- Fixed #2709713, added new preference Log SQL Info Messages to check for SQLWarnings which displays raise info or print messages from stored routines
- Show server info node as root node in db structure view
- Added apache derby plugin (Patch #1612294)
- Internal cleanup for, removed deprecated sources
Color Oracle for Mac 1.1.1
Color Oracle applies a full screen color filter to art you are designing. more>> Color Oracle takes the guesswork out of designing for color blindness by showing you in real time what people with common color vision impairments will see. Color Oracle applies a full screen color filter to art you are designing independently of the software that you are using. Eight percent of all males are affected by color vision impairement make sure that your graphical work is readable by the widest possible audience.
Seeing is believing! Instantaneously identify and correct problem colors in your art using Color Oracles system-wide menu accessible in any program.
New:
Color Oracle 1.1.1 fixes a few bugs on all platforms (25 February 2008).
Color Oracle 1.1 now runs on Windows and Linux (20 February 2008).<<less
Axamol SQL Library 0.1.4
Axamol SQL Library - Execute SQL statements stored in external library files more>>
Axamol SQL Library can often reduce code size of complex queries by 40%. You can also create HTML documentation with embedded documentation strings and a supplied XSLT stylesheet.
Ronin SQL 0.1.1
Open source Ruby library that offers SQL security task support more>> Open source Ruby library that offers SQL security task support
Ronin SQL is a Ruby library for Ronin that provids support for SQL related
security tasks.
Ronin is a Ruby platform that has been designed for data exploration tasks and information security.
Ronin allows for the rapid development and distribution of code over many of the common Source-Code-Management (SCM) systems.
Enhancements:
- Trivial bug fix to URI::HTTP#sql_errors.
Silverwolfs SQL Query 2.2.0
Silverwolfs SQL Query - Connect to mysql database & display records more>>
Note: ODBC Support only functions in the windows version at this time.
Main features:
- Run Any SQL Query
- Server Address Book
- Export Records to CSV
- Save Queries as .SQL files
- recent query list
- Column Type Detection
- multi line sql queries
Enhancements:
- Bug Fixes in ODBC Server Entry Screen.
SQL Query 2.2.2 Beta 1
SQL Query 2.2.2 Beta 1 is a user-friendly tool which can be used to connect to a MYSQL or ODBC Database and Display the Records in a table view. more>> <<less
OpenbravoPOS 2.30 Beta
Open source Point-of-Sale (POS) application for SMEs in the retail industry more>> Open source Point-of-Sale (POS) application for SMEs in the retail industry
OpenbravoPOS is a free and open source Point-of-Sale (POS) application for SMEs in the retail industry.
OpenbravoPOS features reports, cash management and warehouse management, among others. It will help you manage restaurants, including table seating, floor plans, and reservations.
OpenbravoPOS has been created with cutting edge technology to take greatest advantage of the rich open source ecosystem. Entirely developed in 100% Java, using Swing for a sophisticated and consistent user interface.
OpenbravoPOS is database independant, and features rich reports and charts are provided by JasperReports and FreeChart; exportable to HTML, PDF, Excel, XML and CSV.
OpenbravoPOS works with touch screens, bar code scanners, printers, cash drawers, magnetic card devices, and scales.
OpenbravoPOS is cross-platform and it is known to run on Mac OS X, Linux, and Windows.
System requirements:
-
Enhancements
- Fixes issue: Rounding in the cash tab of the payment dialog
- Added openbravo icon
- Fixed. If no categories, the categories selector in the sales panel is not displayed
- Fixed. Start scripts for Windows
- Fixes issue: Payment panel parses numbers but not currencies
- Receipts of other machines cannot be saved
- Fixes issue: Wrong instructions for potential contributors
- Fixes issue: MessageInf.SGN_IMPORTANT conflict with SGN_DANGER Platforms directory
- Opensuse build service platform files
- Small improvements for scripts in ticket objects
- Small fixes in javapos support
- Fixes issue: Localization key message.CannotPrint must be changed to message.cannotprint
- Fixes issue: Attributes like notes are shared between lines that have the same product
- New feature. Now the move table button also merge receipts when moving to an occupied table
- Upgraded library to Barcode4J 2.0 and added support for more barcode types
- Upgraded libraries and code to Substance 5.0, SwingX 0.9.3, JasperReports 3.0.0. Upgraded reports to 3.0.0. Added all available Substance skins to configuration panel.
- Fixes issue: Synchronization of Products and Customers does not work in Oracle
- Fixed daily build. Replaced substance.jar compiled as target 1,5
- Downgraded libraries and code to Substance 4.3 due to the incompatibility of these libraries with java 1.5
- Updated version number to 2.20
- Added backward compatibility integration with Openbravo ERP 2.35
- Added SEARCHKEY field to CUSTOMERS table
- Fixes issue: Any of the customers reports do not work with Oracle
- Fixes issue: After r216, compilation fails in /src-data/com/openbravo/data/loader/Session.java
- Added two fields more in the filter of the Customers search dialog
- Added check for credit card numbers with length 15 and 16
- Fixes issue: After splitting a ticket the ticket cannot be saved
- Removed BasicComboBoxRenderer subclasses
- Fixes issue: Anyone can access pressing ENTER if a user has his card cleaned. Minus button disabled in the sales panel if the user does not have permissions to remove items in the receipt
- Added access to tracks information in magnetic card payment. Added support for parameters in the start scripts
- Added contact and location / address fields to customer entity
- Fixes issue: Openbravo POS does not completely clear the customer display
- New permissions for edit a receipt line, edit a receipt, refund a receipt and print a receipt. Bigger label for record counter Edit receipt button is enabled only if the receipt is of an open cash. If the receipt belongs to a closed cash the edit receipt button is disabled Added a sequence number for closed cash records. This number appears in the closed cash panel, receipt and the report
- Updated MySQL sripts. Using InnoDB engine and UTF8 encoding
- Updated sample database
- Included attributes field for receipts
- Added check that avoids to surpase the customer maximum debts
- Added animation support in the customer display. Animations supported: scroll, flyer, blink, curtain
- Update of third party libraries to latest stable versions available
- Added jasper reports printing capabilities in the sales panel Added the url of the database connected in the taskbar
- Fixed exception thrown in initialization of any serial display
- First RTL tests
- Adde Tax customer categories table and editors
- TaxPanel rename
- Added Tax categories table and editors
- Added new tax fields
- Added Customers diary report Added machine.printername configuration parameter Added translation messages
- Fixed reports printing from the sales panel
- Fixed reports printing in sales panel
- Removed the hard coded behavior for free payments
- Replaced split bar in menu by a button to spand/contract the menu
- Floors ordered alphabetically in the restaurant panel,
- First cycle of new taxes management
- Second cycle of new taxes management
- hird cycle of new taxes management Moved Galician translation to translation-pos project
- Added new attributes titlekey and title to script buttons in the Ticket.Buttons resource
- Added permission sales.Total to allow/disallow close sales Added permission sales.ChangeTaxOptions to make it visible or invisible the options that allow to edit the tax category and edit tax flags in the sales panel Hidden white line bellow the onscreen keyboard in the sales panel
- Fourth cycle of new taxes management. Finished
- Changed the name of the field AMOUNT in taxes lines
- Fixed Taxes field in edit line dialog
- Fixes issue 0004640 Price value for receipt line item does not appear in Sales screen Fixes in the database resources
- Fixed customer debts receipt exception
- Fixing database update scripts.
- Fixing database update scripts. Updated licensing notice
- Fixed CASCADE field in sample database
- Added event ticket.show
- Reverted compilation error in ScritFactory class
- Fixed ERP integration changes
- Changed license message
- Added logging messages in communication errors
- Added field RATEORDER in TAXES
- Fixed start scripts
- Fixed Oracle SQL update scripts
- Fixed default taxes values in all SQL scripts Fixed length of field Order in the Taxes panel
- Fixed windows launcher start.bat
- Fixed customer debt payment dialog when the current debt is 0
- Fixed standard mode that could not save receipts.
- Fixed edit customers search function
- Fixed synchronization of orders
- Fixed taxes summaries
- Fixed fonts in reports
- Added a new event ticket.save
- Fixed Close Cash receipt
GalaXQL 2.0
GalaXQL - Unique interactive SQL tutorial more>>
Follow the instructions by your virtual teacher. The teacher can understand several possible mistakes that you may make, and gives hints on what may have gone wrong. You can skip to any chapter in the tutorial whenever you want.
Use the query editor to interact with the database, and to complete the assignments given by the virtual teacher. In case of syntax errors, SQLite (the database engine used in GalaXQL) returns helpful, human-readable error messages.
If you need more information, you can look things up in the integrated reference.
Oh, and the OpenGL-rendered galaxy map is not there just for show; you can alter the galaxy using SQL.
Enhancements:
- Changes include better layout, new rendering mode for lower-end computers, optional rendering of the 3d coordinate axes, updated SQLite database engine with CHECK constraints, and various little fixes.
- Mac OS X version is now ppc/intel universal binary, and source release supports both ansi and unicode builds.
iPhoto To SQL 1.2
iPhoto To SQL - Creates SQL metadata dump of a photo from iPhoto more>>
iPhoto To SQL will create the following fields: id, title, comment, keywords, stars, date, album, thumbnail filename and image filename. You can set height/width maximums on the thumbnails and images and they will be rescaled with their aspect ratio preserved.
Enhancements:
- Minor fix to no longer clobber the SQL file when doing multiple exports.
- The SQL file is named for the album being exported also saved in the directory itself.
Navicat for MySQL 8.1.5
Navicat for MySQL brings you an effective solution for MySQL administration and development. more>>
Navicat for MySQL 8.1.5 brings you an effective solution for MySQL administration and development. This is an all-inclusive mysql front end provides a powerful graphical interface for databases management, development and maintenance. Easy installation and intuitive interface make it an irreplaceable tool for mysql on the web or your local desktop. Navicat supports all verions of MySQL and let you converts Access to MySQL, MS SQL to MySQL, Excel to MySQL, synchronizes and backups database in a snap through helpful wizards.
Major Features:
- Latest MySQL Versions Support: Navicat for MySQL a powerful MySQL Database Server administration and development tool. Highlights of supported features:
- Support of MySQL versions from 3.21 or above
- Support of Unicode / Character Set
- Support of MySQL Events, Views and Stored Procedures creation
- Support of Triggers
- Support of Foreign Keys
- Support of Partition
- Additional Connection Options
- Support of SSH Tunnel: Establish a secure SSH session through SSH Tunneling in Navicat. Enjoy a strong authentication and secure encrypted communications between two hosts.
- Support of HTTP Tunnel: Navicat comes with you HTTP Tunneling while your ISPs do not allow direct connections to their MySQL server but allows establishing HTTP connections. HTTP Tunneling is a method for connecting to a MySQL server that uses the same protocol (http://) and the same port (port 80) as a webserver does.
- Provide auto-reconnection for MySQL server: With the option "Keepalive Interval", you can keep connection alive with the server by pinging it.
- Comprehensive Management of MySQL objects
- Create, edit and drop table's fields, indices, foreign keys and triggers: With Table Designer the basic Navicat for MySQL tool for working with tables, you can create, edit and drop table's fields, indices, foreign keys, and much more.
- SQL Preview: The SQL Preview area shows you SQL representation of the oracle objects you are creating. This ability allows you to preview SQL before execution.
- Dump object definition as sql file: Backup object definition and data with ease by dumping as sql file.
- View Database / Table Structure: Present the database / table definition by printing their structures in Navicat. Understand the respective object structure fully at a glance.
- Diversified Import and Export Competence
- Import data from ODBC: You can import data from ODBC after setting up a data source connection. All available tables will be included if connection success. Just simply choose the tables you wish to import or specify a query using Add Query button.
- Import data from different file formats: XLS, CSV, TXT, DBF and XML: Import Wizard allows you to import data into a table from diverse format. On top of that, you can save your settings as an import profile for setting schedule.
- Export data to different file formats: XLS, TXT, CSV, DBF and XML: Likewise, Export Wizard allows you to export data into various format. Save your settings as an export profile for setting schedule.
- Export data and create records as INSERT statements in sql file: During Data Transfer, you can choose to export data as sql file with record options like complete insert statements / extended insert statements etc.
- Powerful Data Manipulation Tools
- Form View: Manipulate the current record with Form View. Enjoy a clear display of field name and its value with focus on current record.
- Support of Foreign Key Data Selection: With the GUI tool Foreign Key Data Selection, you can locate the foreign key values from the reference table. Stop shifting the view to a master table to look for the available values!
- Data and Structure Synchronization: Navicat for MySQL allows you to transfer data from one MySQL database to another with detailed analytical process. Likewise, you can compare and modify the table structures. For both Data and Structure Synchronization, the target database can be on the same server as the source database or on another MySQL server.
- Support of Data Transfer between local / remote MySQL databases: Transfer tables/views/stored procedures/events from one MySQL database to another MySQL database, or to a plain text file.
- Support of Backup and Restore MySQL databases: Regular backup on database is important to users. Backup/restore all tables and records, views, stored procedures and events for your MySQL database using Navicat. You can also schedule backups between databases.
- Create Schedule for Backup, Import / Export, Data Transfer, Saved Queries and Data Synchronization: Create a batch job for setting schedule to execute at one or more regular intervals, beginning and ending at a specific date and time. Batch job can be created for Query, Backup, Data Transfer, Data Synchronization, Import and Export.
- Send notification e-mail and attachment for schedule task: Generate notification e-mails with attach exported files to recipients you specify, connecting them to the latest schedule information. Read directly through your email account on the results returned from a schedule.
- Powerful Security Management
- Visual User Manager: Navicat provides users a visual tool for user management. You can easily add, duplicate, delete users, and edit global user privileges, and grant privileges on the selected databases, tables/views, fields and stored procedures/functions.
- Well-Designed Visual Builder / Editor
- Visual Query / View Builder: Visual Query / View Builder which is divided into two portions: the upper Graphical View, and the lower Syntax View, allows you to create and edit queries / views visually without knowledge of SQL.
- Query Editor: It allows you to create and edit SQL text for a query, prepare and execute selected queries.
- Support of Parameter Query: Set query parameters to add variable values to a query each time you run it.
- Code-Completion for Query, View, Stored Procedure and Event: Experience a quick way in constructing SQL statements in Query Editor, View, Stored Procedure and Event with the Code-completion feature. Whether you want to select available properties of database objects or SQL keywords, all it takes is a pick from the drop-down list.
- More great features
- Virtual Grouping: Have a better organization over objects in Navicat. You can categorize objects into groups with the Virtual Grouping feature. Virtual Grouping can be applied on Connection, Table, View, Stored Procedure, Event, Query, Backup and Schedule.
- Server Monitor: Select the servers that you want to monitor by checking them in the checklist box of the Server Monitor Window. Click on either Process List, Variables or Status icon to show and/or modify the properties of MySQL servers.
- SQL Console: To use a command-line interface, you can open SQL Console in Navicat. It provides you an interactive text-based screen to query input and result output from database.
- Tabbed Windows: Customize your window behaviour style. Navicat supports you of dragging windows in and out of the tabbed windows.
Enhancements:
- Improvements:
-
- Improved compatibility to some ODBC drivers for Import Wizard.
- Bug Fixes:
-
- Incorrect use of hexadecimal format in MySQL data types other than BLOB in Data Transfer.
- Data grid was unable to be opened properly when some kind of text were displayed.
- Removed some internal SQL run by Navicat in Query Viewer.
- Unable to change the default value of an existing field from NULL to other values in Table Designer.
Requirements
- Mac OS X 10.4 Tiger or 10.5 Leopard
area shows you SQL representation of the oracle objects you are creating. This ability allows ... divided into two portions: the upper Graphical View, and the lower Syntax View, allows you toLicense:update/patch
