Thanks in advance for any clues... I am rather new to Oracle so here
goes. I have a package body / query that is returning data with no
problems. I do however need to take this package body and rewrite the
code above the "     select p.pr_p_i_n "PIN"," line to allow me to use

I have a complex view created from which I can query from for data
refresh purposes.
The following query runs fine without any problems
select * from <complex view> where cola = :value

very important for your life...
Excuse me!!
Would you stop for a moment?!
O...man...Haven't you thought-one day- about yourself ?

I am trying to set up Streams in Oracle 11g between two RAC
databases.  Unfortunately the connectivity between the two databases
is on a different network than the one on which the VIP is set up.  In
doing sqlplus from one to the other on this other (management)

Hello!!
  I need to create test database like production database. The best
solution for now is standby databse but it not good enough there is any
other solution????? I need to update test databse for every 5 min...

I once had a good connection from my machine to our Oracle server, but
something has gone wrong lately apparently with transferring packets
over the network.  Here's the symptom:
I connect in SQLPlus and do a large select.  Records scroll by.  I

I have :
XX@MYDB9I:XXXX> desc t1;
Name
Null?    Type

I have the following Oracle function from a vendor:
CREATE OR REPLACE
FUNCTION test_warn3
RETURN VARCHAR2 IS

Last day I've encountered a problem with a procedure waiting due to a
buffer busy waits. In v$session_wait I've found FILE# and BLOCK#.
Looking in DBA_SEGMENTS I've discovered incriminated blocks is belonging
to a table called 'DUMMYTBL'.

Description
Little bit history about SAS
SAS is the world's leader in business analytics software, delivering
the breakthrough technology you need to transform the way you do

All,
When I do a "select count(*)" from a materialised view I have created
and compare the execution time with the same select on the table the
materialised view is being driven off, the time for the materialised

Hello, I've an employee table which I created as follows:
CREATE TABLE employee
    (fname           VARCHAR2(15)        NOT NULL,
     minit           VARCHAR2(1)             NULL,

Ok, this is probably a dumb question, but, I have this code:
CREATE OR REPLACE PROCEDURE cj_trials_log (
 p_newsletter_id      NUMBER,
 p_conversion_date    VARCHAR2,

I've a column of salaries in a table and I want them to print in the
format $999,990.00. How to go about doing this ?

I wrote a form using the pl/sql web toolkit. The form fields and the
form handler parameters all appear to match up. It compiles all right
but when I run it in a browser and click the submit button, I get an
HTTP 404 error.