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

PL/SQL - Page 3

41-55 of 55     Previous     Next
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 ...
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 ...
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
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 ...
by DevX Pro
What does the PL stand for in PL/SQL?
Programming techniques: EXEC SQL and bind variables
by DevX Pro
I am having a problem with EXEC SQL. When I use the following code: DIM var1 AS Integer DIM var2 AS Integer DIM var3 AS Integer DIM sSQL AS String sSQL = "SELECT 1, 2, 3 from :var1, :var2, :var3 from systable.dual" EXEC SQL :sSQL it does not work. If I use the string directly after the EXEC SQL, everything is fine. What gives?
Can't get values back from a PL/SQL block
by DevX Pro
I've noticed that I cannot get any values returned to my Power Objects application from a PL/SQL block. How can I get around this?
41-55 of 55     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