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 163     Previous     Next
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?
Ensure the Stability of Your Database
by Joseph Lax
As a database administrator, it is your responsibility to be concerned about anything that might affect the stability of your systems. In that vein, it is not enough to back up your database ...
Interoperable Dates and Times in SQL Queries
by Ken North
Many developers using ODBC, JDBC, OLE DB, and ADO are unaware that there is a standards-compliant solution for expressing dates, times, and timestamps in SQL statements. When writing queries in ...
Starting NT Services for SQL Databases
by Ken North
The Windows NT installation process for SQL servers from Oracle, Microsoft, IBM, Sybase, and Informix installs NT services. Not all products include a graphical tool that enables you to start and ...
by DevX Pro
What does the PL stand for in PL/SQL?
How to structure a database created in Excel
by DevX Pro
How can I structure a database created in Excel?
Problems with database
by DevX Pro
I am developing a radon database for the Ohio Department of Health with Oracle Power Objects. I have two combo boxes. First a choice is made from one of them, and in the second one, the values change according to that choice. I know Microsoft Access and Developer 2000, but the logic used in them is not working here. What I am missing? Also, I am not able to create the main menu to open all the forms from that form-Main Menu. Help!
Transporting Dbases
by DevX Pro
Can I export or import a Dbase file from OPO 1.016 to another DBMS (Microsoft Access or Visual Basic, for example)?
61-80 of 163     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date