Live support
We will be happy to answer any support, sales or upgrade questions that you have.
Chat Now! | Learn more
Follow SQL Developer on Twitter
Home 
Products DreamCoder for Oracle Product FAQ
Products DreamCoder for Oracle Product FAQ
DreamCoder for Oracle |
|||
FAQ |
 |
 |
 |
|
This is a list of our users' most frequently asked questions. By answering them we hope to clarify any doubts they may have regarding DreamCoder for Oracle. What is DreamCoder for Oracle? The DreamCoder for Oracle is a comprehensive IDE for developing and managing Oracle database servers. The product has a graphic interface which simplifies development and management tasks such as creating users, managing permissions, monitoring users, creating, debugging and testing stored procedures, building queries, exporting, generating reports, graphical building of queries and synchronizing data and structure among others. What is the difference between the Freeware and the Enterprise versions? The main difference between the commercial and the freeware versions are the features included. The freeware version has limited functionality. DreamCoder for Oracle Freeware is suitable for beginners and people who do not need advanced options. To learn about features included in these two versions we recommend reviewing the comparison section. It is possible to evaluate DreamCoder for Oracle Enterprise before purchasing? Yes, you can download a 100% functional version of the product and evaluate it for a period of 30 days, plus free access to our technical support channels. What is the difference between Freeware version and the Enterprise? The main difference between the retail version and the features included are freeware, the freeware version with limited functionality. The DreamCoder for Oracle Freeware is suitable for beginners and people who do not need advanced options. To learn about features included in these two versions we recommend reviewing our comparison matrix. It is possible to evaluate the Enterprise or DBA DreamCoder for Orcale before buying? Yes, you can download a 100% functional version of the product and evaluate it for a period of 30 days, plus free access to our technical support channels. Can I connect to an Oracle database server without Oracle Client installed on my computer? Yes, DreamCoder for Oracle includes the option of connecting directly to the database via TCP-IP protocole. All you need to do is enter the values in the connection interface in the Direct tab. Is there a difference between the Direct connection and the connection using the Oracle Client (OCI)? When you are using a direct connection it is not possible to use the PL / SQL debugger. If I'm connected to the database with an OCI connection, can I open another Direct connection? No, currently it is only possible to establish connections to the Oracle database through the same type of connection. If my database is on a Linux server and I work on a Windows computer, can I use the DreamCoder for Oracle? Yes, DreamCoder for Oracle is independent of the OS where the Oracle database server is installed, but keep in mind that DreamCoder for Oracle works only in Windows environments. Does DreamCoder for Oracle support Oracle 10g Express? Yes, DreamCoder for Oracle works with the new Oracle Express edition. Does the SQL editor have an autocomplete feature? Both the SQL and the stored procedures editors have autocomplete, objects description, open object, format SQL code and many other features to make development easier for editors. The main options available in the editors are: Autocomplete: CTRL + SPACE Object description: CTRL + CLICK Open object: F4 Autocomplete special: CTRL + J SQL code formatting: SHIFT + CTRL + F Can I export my entire database? You can export the created scripts for most objects in the database as well as data, but it is not possible to perform a full export, as is done with the Oracle client library exp. Is there an option to build graphical queries for the database? Yes, DreamCoder for Oracle Enterprise and DBA has a modern query builder to easily build more complex queries, without previous SQL language knowledge. Is there an option to graphically build insert, delete or updates for tables? The product has an option to generate code to handle tables, this option can be called from the object browser or from the tools menu "generate SQL table." If I have two equal databases with different records, can I synchronize them? Yes, DreamCoder for Oracle Enterprise and DBA has an option for synchronizing data. You can find this option on the Tools menu, "Database Data Synchronization". The only condition is that the tables are physically equal. If I have two different structure databases, can I synchronize them? Yes, DreamCoder for Oracle Enterprise and DBA has an option for synchronizing the structure of two databases. You can find this option is available on the Tools menu, "Database structure synchronization”. Can I monitor the users who are connected to my Oracle database server? DreamCoder for Oracle Enterprise or DBA feature multiple options for monitoring and auditing meetings, system, users, storage and SGA. With these options the managers can have a full picture of the Oracle database server, since they are nable to monitor from one user's activity to the overall database operation. I have a table that takes a long time to open, how is this possible? If the table has many columns and these are fields with large values, the product may take some time formatting before showing it on the grid view. To speed up this process you can disable the option "columns best fit", it is available in the interface options, in the grid calling tab. If the table has a large number of foreign keys and the “value list for foreign keys” option is enabled, this can also affect performance. In this case you should only disable this option from the interface options in the call grid tab. I have 1000 records in a table and the product only shows 50, why does this happen? The product always shows records in blocks of 50 in the grid. If you want to view the last record, just press the navigation button called "last." Is there an option to generate database reports? The DreamCoder for Oracle Enterprise and DBA has a reports module, where you can generate reports for DBAs, objects and users. There are over 20 reports that cover the entire database. Is there an utility to test stored procedures? The Enterprise DreamCoder for Oracle DBA includes a feature for quickly testing stored procedures. You can access this option by right-clicking on a stored procedure and then clicking "test". Can I import data directly from Excel into a table? The Enterprise DreamCoder for Oracle DBA has a large number of options to handle, import and export data. One of them is a procedure by which the user just needs to copy data from Excel and then press the option called "paste records to grid ", available in the grid's advanced options, to insert data into the table in Oracle. The Excel file must include the names of the columns being selected and copied. Can I manipulate an XML field? Yes, currently the DreamCoder for Oracle includes a utility to manipulate XML type objects from the data grid view. Can I manipulate CLOB and BLOB field types? Yes, DreamCoder for Oracle includes the LOV viewer. With this utility you can quickly and easily handle these types of fields. If I have SQL code and I want to format it, can DreamCoder for Oracle help me? Yes, DreamCoder for Oracle Enterprise and DBA include an option to format SQL and PL / SQL code, available from the SQL editor and the procedure builder. Can I filter the objects displayed by the object browser? The latest version of DreamCoder for Oracle includes a comprehensive option to filter objects in the browser according to type and connection. |
Support Center
SQLDeveloper provides support in multiple ways, for an expedite resolution of any issue related to our databases management and products development.
Request Support:Community
Join our Community
and help us create better products
Colombia Address: Calle 39 norte #6n-41 
GermanyMagic Hands – Thomas Sauerland e.K. Address: Möhnestr. 16 59755 Arnsberg
Tel: Phone +49 02932/802750
Fax: +49 02932/805929
E-mail: sales.ge@sqldeveloper.net
United States