Oracle SQL handler, yesDesigned for Oracle database developers and operatorsA carefully crafted Oracle client tool:
Ultra-intelligent SQL Editor;Ultra-convenient table operations(You can update the data warehouse table by modifying the cell data of the table );Export data in multiple formats, including xls, CSV, insert SQL, HTML, and XML;Chinese and English InterfacesAnd can be switched; MonitoringRun batch SQL statements(Paused and corrected during running );No need to install the Oracle client; Occupies very few system resources; can run on all mainstream platforms including
Windows (including Windows 7 ),Linux, UNIX and Mac OS; multi-threaded Multi-connection. All these features are available inSimilar Tools are outstanding, and even exclusive to this tool!
Also, it can be fastShow explain plans of SQL;Able to run/debug PL/SQL statements; Precise error locating; efficient statement block operations;SQL format beautification; Simple connection configuration; automatic reconnection; personalized interface settings; simple and clean interface; easy to operate; practical and comprehensive functions!
In short, this tool does"Small, practical, convenient, and efficientIt is a powerful tool required by oralce database developers and operators!
Free tools made in China, early use of early benefits, what are you waiting ?!
Download URL:
Http://www.onlinedown.net/soft/91179.htm
Http://www.duote.com/soft/17069.html#downsite
(Extract the downloaded ZIP file to a directory, and double-click the batch file start. BAT to start running)
The main functions are as follows:
<1> display the query results of the SELECT statement in the worksheet. You can directly reoperate the query results, such as modifying, inserting, deleting, and submitting rows (writing data changes in the table to the corresponding database table) multi-function copy, export the selected cell data to xls, CSV, insert SQL, HTML, and XML formats, perform single record operations, and search and replace the data in cells, numerical statistics, row and column movement, column sorting, selection mode switch, etc; allows you to conveniently View/Edit large text fields (such as clob and long)
<2> intelligent SQL Editor: the prompt window is displayed automatically to list keywords, keyword combinations, function names, column names, object names, object types, parameters, processes and functions in the package, improve SQL Editing efficiency. For example:
(1) enter the string "Sel", and list all the keywords and keyword combinations starting with "Sel" (such as select, select distinct, select * From), functions, and object names in one second;
(2) input string "ABC" + ". ". If" ABC "is a table name/view or its alias, all column names and Data Types of the table/view are listed. If" ABC "is a user name, all objects of the user are listed. If "ABC" is a package name, the processes and functions in the package are listed;
(3) input the string "Grant" + space to list all permissions and roles, enter "on" + space to list all objects, and then enter "to" + space, lists all user names;
<3> color SQL editor for enhanced readability:
(1) keywords, comments, strings in quotation marks, operators, and special characters are differentiated in different color fonts;
(2) If there is a bracket before the cursor, the matching brackets are displayed in high brightness.
<4> support for running batch SQL statements: monitor the running of each statement by using a monitor. During the running process, you can interrupt, pause, or continue running statements, you can even correct the wrong statement.
<5> convenient and efficient block operations to meet special requirements:
(1) The "format SQL" button can rearrange the messy statements in the statement block in the indent format, that is, beautify the format;
(2) The "explain Plan" button can quickly display the statement execution plan;
(3) The "Export" button can export SELECT statement blocks in the SQL editor to xls, CSV, insert SQL, HTML, XML, and other formats, convenient for data migration, backup, printing and archiving;
(4) supports column block operations;
(5) Add/Remove annotation marks, Add/Remove quotation marks, add/reduce indentation, and convert uppercase and lowercase letters.
<6> run the statement "DESC [user.] objectname [@ dblink] "or Ctrl + Click the string" [user.] objectname [@ dblink] ". If it is a table name, the column information of the table is clearly displayed (including the column name, data type and length, default value, and non-null), index, constraints (primary key, unique key, check key, sub-table, trigger, foreign key, and even foreign key)
<7> run the statement "schema [user.] objectname [@ dblink] ". If it is a table name or view name or materialized view (snapshot), the generated script/statement is displayed.
<8> supports PL/SQL statements (including procedure, function, trigger, and package), which can display the output of dbms_ouptput.put_line and provide error information, even the cursor can precisely locate the row and column where the error is located, facilitating debugging.
<9> multithreading and multi-connection: multiple sessions/connections can be created, and multiple sessions can be run at the same time. During the running process, you can control the running status and be interrupted at any time, you can continue editing and other work during the running process. You do not have to wait until the running is complete before editing.
<10> provides common operations for common data dictionaries (such as tables, views, indexes, synonyms, constraints, processes, and triggers. For example, if you enter "% name", "name %", or "% name %", you can find all the object names that contain the sub-string "name, you can perform operations on each object through the pop-up menu, such as modification, deletion, and viewing.
Tool interface image: