Oracle database query tool
The Oracle database query tool features provided by RazorSQL include a custom Oracle database browser tailored to Oracle, a PL/SQL SQL editor with Oracle and PL/SQL specific features and syntax highlighting, Oracle import and export tools, custom Oracle GUI and visual tools, and Oracle specific database administration tools. Listed below are more details on these features.
- A GUI Oracle create table tool that generates Oracle specific create table SQL that includes such elements as column names, column types, column lengths or precisions, column scales, nullability, unique constraints, default values, and the ability to add check constraints.
- Oracle tools for creating Oracle packages and package bodies
- An Oracle alter table tool for generating the SQL to alter Oracle tables with such options as add column, add primary key, add foreign key, add constraint, add sequence trigger, rename table, rename column, drop column, drop primary key, drop foreign key, and drop constraint
- SQL Drop Tools for dropping tables, views, indexes, sequences, procedures, functions, triggers, packages, and package bodies for Oracle
- Tools for editing procedures, functions, packages, package bodies, and triggers for Oracle.
- Oracle Import and Export tools for importing data into tables, or exporting data from single tables or all tables in a database
- Displays information in a tree format for schemas, tables, views, procedures, functions, triggers, packages, package bodies, indexes, constraints, sequences, materialized views, materialized view logs, and clusters.
- Displays Oracle table information such as column name, column type, column length, column nullability, and primary and foreign key information
- An Oracle View DDL option for viewing the create table SQL for tables and the DDL for other Oracle objects such as views, indexes, procedures, etc.
- Easily view table contents or database object information via the View Contents and Show Info context menu options
Edit SQL and PL/SQL scripts. Run SQL queries. Auto column and auto table lookup. Supports over 20 programming languages including SQL, PHP, HTML, XML, Java, and more.
Import data from various formats such as delimited files, Excel spreadsheets, and fixed width files.
Export data in various formats such as delimited files, Excel spreadsheets, text, HTML, XML, and SQL insert statements.
Edit tables in a spreadsheet format with support for finding and replacing data, automatic generation of SQL, and support for editing multi-line data.keypath education horizons education center education degrees monroe county board of education cross country education fuel education south dakota department of education academy for classical education the education trust china education institute of international education education com 504 education plan special education paraprofessional www education com education is important to society because windows 10 education vs pro why education is important wharton executive education kimberly klacik education special education teaching education degree online education loan adult continuing education national association for the education of young children diverse issues in higher education bill nye education presidential education award education achievement gap differentiation in education center for early education harvard continuing education humboldt county office of education jobs larry page education elaine chao education texas education education tax credits chiropractor education requirements physical education degree passaic board of education oregon driver education center education networking special education advocate mark cuban education florida dept of education va education benefits for dependents south carolina education lottery pick 3 pick 4 benjamin netanyahu education higher ground education higher education act of 1965 jim parsons education education secretary betsy devos citrus research and education center the health and education federal credit union mh education idaho education news right to education mit executive education which education level has the highest return on investment (roi)? special education lawyer missouri department of education education planner west haven board of education civics education education portal navy education critical race theory in education pdf physical therapist education requirements garfield board of education san diego county office of education santa clara county office of education brown v board of education date oak ridge institute for science and education education mis education perfect george washington education social worker education requirements arizona education ranking general education degree certified health education specialist center for real estate education tennessee education lottery xinjiang re education camps phd education education sociology strategic education wyoming department of education education and government credit union orbis education jen psaki education florida education ranking early childcare education savannah guthrie education