I am afraid I have a question that most of you must have heard a
million times. I should have found the answer on some of the existing
posts, but I am overwhelmed by the information. I a DB newbie tasked by
management to figure out how the Oracle database ought to be setup!

Hello sirs,
I have this SQL statement:
DELETE FROM EMODPRODUTOS
WHERE (CdProduto = 105) AND

Hello sirs,
I have this SQL statement:
DELETE FROM EMODPRODUTOS
WHERE (CdProduto = 105) AND

I defined two env variables in "httpd.conf" as:
SetEnv MW_HOST "localhost"
SetEnv MW_PORT "7280"
In the mod plsql procedure, I am trying to retrieve the variable like:

I unsuccessfully tried to export data from Oracle with:
Export: Release 9.2.0.4.0 - Production on Wed Sep 28 15:47:17 2005
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected to: Oracle9i Release 9.2.0.4.0 - Production

I have a table test. I have set up a trigger  (before insert)
CREATE OR REPLACE TRIGGER tr_test_row
BEFORE INSERT ON test
FOR EACH ROW

We are getting ready to move one of our Oracle databases from one SAN
to another.  I was asked if I wanted to layout the file system in any
particular fashion.  Here is what I came up with. Please add your
experience/comments:

Server 8.1.7.4.0, SQL Plus 8.1.7.0.0  I'm trying to see if SQL PLus can
accept more characters in an SQL statement than it does.
I am finished working on a pretty hideous SQL statement that was more
than 10,000 characters*.  I use MS Access as a front end tool against

I am a new Oracle user version 9.2.0.1.0 for tru64.
It is the first time that I try to install the db and I am not sure about
the kernel parameters setting.
The alpha file server I'm using to learn to use the db has 256MB of RAM and

We have a large range partitioned table with the partion id being the
index_bill_ref.   When we query it like
SELECT *
   FROM BILL_INVOICE_DETAIL BID,       BILL_INVOICE BI

I have a few security related questions and would like to hear from you
if these are really an issue in the real world.  If yes what their
risks are.  Any comments are appreciated.
1. In the init.ora file, is it mandatory that we need to have the

I have a SQL script that I'm running in SQLPLUS Worksheet to generate
some DDL. It's like this:
---------
spool mynewscript.sql;

Hey all,
This should be easy but I'm just not seeing it...
box a: win2k3, Oracle 9.2 catalog db, rman
box b: aix 5.2L, Oracle 9.2 db

I am looking for a generic approach to create an empty temp table
matching the definition of given columns of existing view.
To do that I use SQL like the following:
CREATE GLOBAL TEMPORARY TABLE MY_TEMP_TABLE AS

I am running Oracle 9.0.2 on AIX.I have an ODBC compliant DB (Called TDS, on
Objectstar) on a Windows 2003 server.The ODBC drivers supplied by the vendor
have been installed on my windows machine and the Windows server.I can
connect from EXCEL/ACCESS etc from my machine.No problem.