How can I get the body of stored procedures and functions?
I would like to extract some documentation embedded in
the comments.
Many TIA!

All, does PL/SQL support inserting more than one row with a single
statement, similar to what mySQL has? I looked around but couldn't
find anything regarding this.
I'm assuming that a single insert to insert, say 10,000 rows would be

Dear Experts,
I'm looking at the MODEL clause in 10G, and reading a number
of articles on it.
All I want to do is a simple pivot, with no hardcoding

How can I write an oracle function that can return a set of rows? this
is what I am doing now. It doesnt work.
create or replace FN_ABCD
(

Here is my environment : Oracle 10G release 2 on RED HAT LINUX
ENTERPRISE.
I have a shell script (.sh) with an Oracle export and a ftp command to
transfer the file *.dmp to an other machine. When i execute this

I have a question concerning rman on oracle 9.2.0.6
I've made a backup of archivelog with this command
backup  format 'f:\test_archivelog_d1008_h0955.bck' (archivelog all delete
input) ;

hi, we have Oracle 10g db on Solaris. All of a sudden the developers
are unable to edit the procedures in the db. Nothing is changed and I
restarted the db and still the same. So I shutdown, then in mount
stage I issued alter database open read write. But still the

Let's consider an accounting application for small businessess. It is
a web based application with about 2000 users issueing invoices and
making lots of other business transactions. In the same time they
want to view tax reports, generate tax declarations and see general

Our C++ application is built with Oracle 10.2.0 client libraries,
whereas deployment environment has client libraries 10.1.0, also
server version at deployment is 10.1.0. Our application crashes very
frequently which accessing Oracle database.

is there any short reference what privilege you need to run a
statement.
For example:
when I run 'CREATE FUNCTION' what privilege I need?

Can somebody give help with a sql statement that retrieves the count
of vowels in a semtence...
Write a select statement that returns the number of vowels in the
sentence

so my situation here:
10.2.0.3 with RAC (one node)
SunOS 5.9 sparc 64bit
There is a table with a NCLOB type field. The table and the LOB

Is there any function (10g) that would return a kind of hash value,
I was thinking of getting one value for the whole table.
My idea was to concatenate all the columns (5 columns there not very
big around 10chars each) get a numerical hash value.

I've created a table, say tbl and a PL/SQL function fcn that I want to
share with a friend.  I used the following:
GRANT SELECT ON tbl TO friend;
GRANT EXECUTE ON fcn TO friend;

Has anyone delt with Oracle core files and the information in the core
files. I understand that the information is different based when the
core was dumped. From security presepctive, is there a chance that it
could contain lot of data stored in SGA or any data for that matter?