Is oracle meant to be accessed from other available tools
programatically and SQL* Plus is for demonstration purpose only?
Why Oracle do not design a good tool to execute SQL queries.
I found the Oracle SQL*Plus to be very non-user friendly (This is my

I have two tables TASKS and TASK_PREDECESSORS
CREATE TABLE TASKS
(
 ID         NUMBER                             NOT NULL,

Scenario:
Got a big normal(non-partition) table (about 5 million rows), only
index is the default ascending primary key index on primary key column
(id)

Is it possible to tranafer a MS Access 2000 database to Oracle 81/10g?
How to do this?
What resources do I need?
Please help

we've RedHat Linux AS3 (upd. 1) running in a 8 proccessor IA64 Itanium
II machine with RAM-16Gb. Oracle 9i (OLTP database) under RawDevices
with
an oracle blocksize of 8k and 2 QLogic Fibre Channel Adapters (QLA2340)

I've got an odd problem with 9i (9.2.0.4) on Windows XP, hoping that someone
can give me a pointer in the right direction.
The database is not starting with the system service.  I can start the db
with sqlplus, no problem.  When the system boots, the server service starts

i am looking for a way to concatenate all values
of query (that returns one varchar-field with multiple rows)
into one string:
e.g:

When the oracle database of monolingual character set was exported and
imported in a UTF8 data base
The following error log is found for some tables having BLOB attribute
or string type:

I have a multiplier that multiplies 2 floating point numbers with 7
bits exponent and 10 bits mantissa.so its output has 7 bits exponent
and 20 bits mantissa.
now its output must return to its input in order to compute another

Hello !!
I've got a problem with a query,I would like to select some data from "
TbOrder"
table  where  the period date is from  the 01/04/(current year) to 31/March

I have a column named Gender in my table. Its a varchar2 type column
and each row is either 'M' or and 'F'.  I want to count the no. of Ms
and number of Fs and obtain the result of the number of Ms and Fs in a
separate row.

I have the following strange effect:
The statement:
select <some values> from <some tables> where <some join statements>
and <some conditions> and value1a in (select value1b from table1 where

We created a user in Oracle 9i and use it to run nightly processing via
scheduler (3rd party) by executing .bat files (windows 2003).
Works fine, but there is one little thing: the user/pass is visible in
the string.

Our department is loosing access to MS Server 2000.  I am looking into
different possibilities of replacements, Oracle being one.  I know
Oracle is available for free, but I'm not clear what the limitations of
it are, and that's what I need clarified for me please.

Our database: Oracle 10g Release 2, IBM AIX, 2 proc machine.
I have the following problem and I've run out of ideas :-((
Suppose I have a view:
create or replace view v_200601 as (