 |
Passing data between Functions and Procedures in Oracle.
|
| Total Hit (6729) |
In this code I've tried to show how data might be passed between functions and procedures in Oracle using cursor variables and collections.
I have made use of the example schema HR which is provided by Oracle.
The objective was to create a function that accepted a set of records passed to it a
....Read More |
Rating
 |
|
|
|
Displaying Date-Time in different formats in SQL
|
| Total Hit (5808) |
The TO_CHAR function, when applied to dates can be used to display a date-time in a user-defined format. This article will give you an introduction to the possibilities.
The following date format elements can be used together as shown in the examples to display date in a custom manner.
«b»Exam
....Read More |
Rating
 |
|
|
|
Sending mail from a PL/SQL program
|
| Total Hit (5770) |
You can send e-mail from a PL/SQL program using the built in UTL_SMTP package. It is written on top of UTL_TCP and implements the SMTP protocol for sending email. You can use it to communicate with an SMTP sever outside the database.
Please note that UTL_SMTP can be used only to send mail though
....Read More |
| Rating
|
|
|
|
How can I run Apache and IIS on the same Windows NT server?
|
| Total Hit (5687) |
I just installed ORACLE 9i on my Windows 2000 server (With IIS) and I noticed that Apache web server couldn't start so I was not able to run iSQL Plus. The reason was both IIS and Apache were trying to listen on port 80 and since IIS starts first it locks the port 80 so Apache couldn't listen on def
....Read More |
Rating
 |
|
|
|
Oracle's LogMiner - Part 1: Getting Started
|
| Total Hit (3256) |
Oracle's LogMiner utility has been around for several years now, and it originally appeared as a new feature (as opposed to being an improvement of something else). Each major release of Oracle typically ushers in a new set of features, some of which are actually useful and can make your job as a DB
....Read More |
| Rating
|
|