SELECT *
FROM (
SELECT ssl_user_code,
              ssl_user_code ssl,

This is what I think I know:
         If you have an XML doc that you would like to load into
         an relational table you must first transform it with
         XSLT into Oracles canonical format.

I'm just trying to move an application from MySQL to Oracle 9.2.
Now I'm looking for the equivalent for the MySQL statement:
ALTER TABLE tablename
ADD INDEX indexname ( column1, column2 )

I am wondering if it is possible to use multiple source files with
Oracle extenal tables. For example file A contains fname and lname
column while file B contains also fname and lname columns. I would like
to tell Oracle to use both files A and B to populate my external table.

I was monitoring some (really) long-running SQLs in my 9.2.0.6 EE bd
with the following query :
select b.sid, substr(a.segment_name,1,25) obj_name,
 substr(a.partition_name,1,15) partition,

Our Oracle server has the address 192.168.10.60. The remote client is
on another subnet and sees the Oracle server on the NATed address
192.168.15.60. The router does not filter ports.
Now, the TNSPING from the remote client gives:

Hello Oracle Guru's,
I know that PL/SQL does't accept any user inputs.
but i need the following  functionality like  And Please do not ask the
reason for.

How I can load data to BBDD with control file? I have two data files.
Content of data file 1:
data1#data2#data3#data4
Content of data file 2:

I am running Oracle Server 8.1.7 in Win2000.
I have two database on the server : GMAOPROD and GMAOTEST.
after power is cut off suddenly, I have the following error shutdown or
initialization un progress.

I have a small database (about 4 gig total) that generates web pages
through mod_plsql.  The DB gets hit by 30 users 10 hours a day pretty
regularly.
The db is 10g running on a Dell 3gig 2meg Zeon hyper-threaded intel

I have a table with primary key values:
1, 2, 6, 8, 10, 13, 15,...
Suppose I need to insert a new row with the minimum PK not used (here it is
3).

Can anyone recommend HW for running Oracle under Windows NT in a redundant
configuration? We are currently running in backup mode using transaction
logs, but would like to switch to a scheme that wouldn't require downtime to
switch over.

I know CBO was introduced in Oracle 7 (7.1?), but when did oracle first
say "stop using RBO because it is going away?"

the documentation for 9.2 says:
"Although users can grant column-selective INSERT, UPDATE, and REFERENCES
privileges for tables and views, they cannot selectively revoke column
specific privileges with a similar REVOKE statement. Instead, the grantor

Oracle’s 9i OCP (Oracle Certified Professional) DBA (Database
Administrator) certification is a mid-level certification for IT
professionals who manage large-scale databases or develop applications
that are used enterprise-wide. The Oracle 9i OCP was introduced in late