Re: Oracle Command Equivelent
Posted in 2006
Try eSQLEditor. Program shows list of tables or procedures by pattern of name, columns, indexes, etc; paste name of table or other database object to sql text by double click; execute sql scripts with timing and logging and show error place. ftp://ftp.iiug.org/pub/informix/pub/esqleditor5.zip http://myinformix.narod.ru/index_en.html * Info about tables, synonyms, views (with text), columns, indexes, functional indexes, constrains (with check text), triggers (with text), procedures (with text), fragments, generate DDL (only test yet), depends from table (references - sysconstraints, views - sysdepend, synonyms - syssyntable). * Syntax highlighting of sql text. Search and replace. Undo/Redo. * Executing of sql scripts or selected part. Logging of executing with timings. * Export to cvs, excel or html results of queries or tables data. * Auto save text of SQL tabs, and all program parameters (font size, panels height and etc). * In bottom-left corner in status bar shown estimated cost: estimated number of rows returned: number of rows processed after executing query.