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

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.

Search the Tips

Oracle - Page 4

61-80 of 173     Previous     Next
Dynamic SQL in Oracle 8i
by Andrew Holliday
Oracle 8I gives developers a new feature to allow execution of native dynamic SQL. This is an alternative to the DBMS_SQL package previously required. Now developers can use dynamic SQL in their ...
Using Temp Tables in Oracle 8i
by Andrew Holliday
Oracle 8i introduces the concept of temp tables. This feature long since enjoyed by SQL Server developers enables data to be visible on a Session ...
Quickly Comment and Uncomment Blocks of Code in SQL
by Don Benson
During development, it is often necessary to have blocks of code for ...
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 ...
61-80 of 173     Previous     Next
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date