In my Designer 9i repository I've identified a number of Users and Schemas
that I'm wondering if I could remove without damage.  I've already removed
the HR and SCOTT schemas since I know those aren't necessary but I have
questions on a number of other users.

I need a simple sample, please.
for using sql statement by dbms_sql,
and fetching the rows inside.
Thanks :)

I have the following execution plan for a parallel query but I can't find
any information about the "TQ" field. Someone can tell me where I can found
informations about it's meaning? I try Oracle manual (Performance tuning
guide) but found

I am trying to display in an array the result of a query. Unfortunately I
cannot concatenate 2 fields
in 1, it makes an error :
Warning: ociexecute() [function.ociexecute]: ORA-00911: Caractère non valide

Hi all, and thanks in advance...
What's the clever way to create and populate a new
table from the contents of an old table, but converting
the LONG RAW columns in the old table to BLOB columns

select * from v$version
BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production

excuse me  for the simplicity of the question but I'm a beginner..
I have seen somethings similar in this forum.
If i have a procedure plsql that calls an other one like this:
CREATE OR REPLACE PROCEDURE p1

Please email your resume to me if at:  JMinton@Emdeon.com if you feel you
could excel in the below position as a Siebel Production Engineer.
Compensation for this position is such that only the very best should apply.
Position is with Emdeon Business Services (Formerly WebMD) in ...

I attended course Introduction to Oracle 9i: SQL. Now I would like to
pratice course material at home. During the course we used database
written for course purposes. The problem is that I don't have scripts
for creating this database (In the course book I can find description

Email your resume to: JMinton@emdeon.com
The position will be part of the WebMD Mercury ITG support team and will
assist the teams in future phases of installs. This position includes being
the main architecture for sizing and requirements as it pertains to ITG.

I'm a quite new in the RAC field and I want to know if the following
behavior is normal for such a configuration:
A few weeks ago we succeeded to configure an Oracle 10.2.0.1 cluster.
The configuration was comprised of 2 nodes and the underlying OS was

Could you please give me some information about Oracale Database Systems
reputation.  Would you think that it would be a good system to use for
processing claims?

I have the following sql select code in a .asp page which I'd like to
convert to a stored procedure on an Oracle 9i schema:
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open Application("connstring")

Hello.  I would like to present a situation facing many of my customers
regarding a product they each use.
They each have a applicant, built in Oracle Forms 6, utilizing 8.15
thru 9i, as a backend.  Most of them have terminated their agreements

I have a Designer 9i repository on my home PC and noticed that the space
used on a large number of my tablespaces are at 100% and a good number in
the 90%s.
I've recently been doing a lot of work in Designer and have been deleting