Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

Search the Tips

Oracle - Page 4

61-80 of 170     Previous     Next
Wrapping Application Code
by Jayanta Sengupta
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 code by ...
Avoid Multiple Exit Points in a Function
by Jayanta Sengupta
If you have a database function that has multiple return statements, try to minimize the exit points. I will explain with the following ...
Caching Packages on Database Startup
by Jayanta Sengupta
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 ...
Performance Analysis of Application by Code Profiling
by Jayanta Sengupta
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, ...
Performance Enhancements Using Temporary Tables
by Jayanta Sengupta
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 allows you to create ...
Advantages of EXISTS over IN Clause in a Query
by Jayanta Sengupta
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 ...
Faster Data Access Using Index-Organized Tables
by Jayanta Sengupta
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 and all the table data is ...
Processing of Large Batch Transactions in Oracle
by Jayanta Sengupta
At some point, you must have encountered a "Snapshot too old" error when running a huge batch transaction. Then you find that you may have to restart the process all over again when 80 percent of ...
Pre-Compiled Database Triggers
by Jayanta
Many programmers create stored procedures out of large bodies of database trigger codes. This has primarily been because while stored procedures are stored in compiled form, database triggers are ...
Enhanced Parameter Passing in Oracle8i
by Jayanta Sengupta
PL/SQL supports three parameter-passing ...
Altering the Substitution Character in SQL*Plus
by Jayanta Sengupta
When you are inserting data into Oracle tables in SQL*Plus using hard-coded string, some of the character fields may contain the ampersand character (&). The following is an ...
One-Step Compilation of Oracle Packages, Functions and Procedures
by Jayanta Sengupta
The DBMS_UTILITY.COMPILE_SCHEMA procedure compiles all procedures, functions and packages in the specified schema. DBAs now don't have to generate the dynamic scripts to recompile the invalid objects ...
Declaring Data Variables in Oracle PL/SQL Blocks
by Jayanta Sengupta
In a PL/SQL block, if you are querying a database table, you need to declare data variables to hold column values returned from the query. The variables can be declared of the same explicit datatype ...
Benefits of Using PLS_INTEGER Datatype in PL/SQL
by Jayanta Sengupta
If you have a whole-number counter, for example in a loop or record counter, consider using a datatype of PLS_INTEGER instead of INTEGER or NUMBER. When declaring an integer variable, PLS_INTEGER is ...
Use of LIKE in SQL
by Jayanta Sengupta
The LIKE statement is often used in SQL queries with wildcards to find data that ...
Retrieving the Top-N or Bottom-N Rows from a SQL Table
by Jayanta Sengupta
You often encounter requirements for reports to retrieve the top-n/first-n rows of a table
Use the Oracle8 Call Stack to Track Error Locations
by Jayanta Sengupta
When an error message is logged into the errorlog table, there is often a need to know the entire call stack, to debug the exact location of the error. This becomes more crucial when the error occurs ...
Update Primary/Foreign Key Columns of Numeric/Character Datatype in Oracle
by Jayanta Sengupta
Often the existing data in the database needs to get updated, even if they are part of any primary or foreign keys. In Oracle8.0, it is possible to defer integrity constraints but this feature is ...
Transaction Independence in Oracle8i
by Jayanta Sengupta
In a nested procedure environment, I have often felt the need to ...
Porting from Oracle to Informix
by DevX Pro
We have an existing application, which has been developed using ASP. The database being used is Oracle 8. Now, for a different customer, we want to port this application to Informix. Can we port this application from Oracle to Informix?
61-80 of 170     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date