Question: I have to admit, I’m new to the Exchange community. After extensive reading of various books and forums I have managed to configure and setup the IMS, etc. The
Question: To make a long story short, we have a copy of the private and public EDB files. Is there a way to get the data out of at least
Whenever you access a database field through the Recordset object you incur in a slight overhead. Take for example the following code snippet: Dim rs As New ADODB.Recordsetrs.Open “SELECT au_lname,
If you wish to retrieve from the department table all the department numbers that have at least one employee assigned to them, write the query as: select deptno, deptname from
Oracle8i provides a standard package, DBMS_PROFILER, which facilitates performance and code coverage analysis of your PL/SQL application. This package provides functions for gathering statistics, such as total number of times
Oracle8i has introduced database-level and system-level triggers. They can track events in the database such as logon/logoff from a schema, startup and shutdown of a database, and response to a
A temporary table has a definition or structure like that of a regular table, but the data it contains exists for only the duration of a transaction or session. Oracle8i
Oracle comes with a PL/SQL wrapper, which converts the PL/SQL source code into an intermediate form of object code. By hiding application internals, the wrapper prevents the misuse of your
If you have a table whose columns always are queried together, maybe you should store them as an index-organized table (IOT). An IOT is indexed on one or more columns