Sometimes when I do a query, I make a mistake in typing in some
characters.
Then I have to do the whole query over and type in everything again ;-(
Is there a way to edit what was previously typed in so that I don't

Hey guys,
 I thought I'd try to get some feedback on something I'm looking at.
 I have this 2 table query that I'm trying to figure out the bad
execution

i needed some help with writing and scheduling a stored procedure, our
dba is out and we need this done :)  it's fairy simple, we have an
application that users fill out, once filled and user is emailed asking
to respond within 7 days, if no response is received we set a flag in a

Any ideas how I can get the status of the Oracle TDE Wallet, i.e if its
open, closed or non-existent

What is the best way to find how much redo has been generated per a SQL
statement?
I know about "redo size" statistics in v$sesstat, but that is redo size
per session, not redo size per a statement.

Getting the above mentioned error when running the following command
from my unix shell script.
ANALYZE TABLE table_test_new VALIDATE STRUCTURE CASCADE
I am executing the same command at multiple places in my unix script...

I came across an unusual problem today....
We are just getting started loading incoming files into a staging area
to analyse source data for a DW build.
I am sending data into a database (that I didn't set up and am not the

In spite of the fact that my PL/SQL skills are really rather poor, I have
attached a procedure that I wrote that minimizes the physical size of an
index using the COMPRESS parameter.
The procedure adopts a rather brute force approach by continually

I'm working with a table of survey data in which each respondent has
data for 2 questions: 1) what is your household type? (family, couple,
roommate, single), and 2) how many people do you shop for?
(1,2,3,4,5+). I'd like to pivot the result set of the following query

Due my experienced (so-called) seniors who designed the app and the
database, i have been given a task to learn more about ORA-4030. The
design of the application is such that, user will be allowed to set the
filter to exclude order information placed which inturn is converted to

Does somebody have spatial running on 10g and can try the following script for me?
create global temporary table TST_PARTS
    (
    REFDes varchar(10) not null,

Hello again,
I have a table that has (for one of the fields) VARCHAR2(64) - but -
whenever I select in sqlplus using this field, the display is chopped
off and I don't see the entire entry.

- Hi
Ideally I would love to use variables defined and assigned inside a
view.
create or replace view as rates

If I buy a new motherboard for my computer, do I need to reinstall
Oracle after swapping in new motherboard? How do I preserve all my
databases and settings?
Thanks

I have Oracle 9i installed in Windows 2000.
When i change the system time in windows to any year greater
than 2039, the the oracle instance fails.
Why it is so?