I guess this is a matter of personal taste, but I usually create a SEQUENCE
for each table that has an ID field I need to populate.  I've seen others
create one SEQUENCE to generate IDs for all the tables.
I'm working on a new system, and I have 12 such tables, and I'm not sure I

Is there a way to see the constraint definition? I checked
user_constraints and it doesn't have column that contains
user defined code.
Thanks for your help

I have a question about a query.  I have a personnel table.  In this
table there is a column for employee type (S_EType).  I want to find
the average age of the group of employees by each employee type.  There
is no age column; only a birth date column.  Therefore, some processing

We currently have the following setup:
Server:
Oracle Database on Unix @ 9.2
Client:

I am trying to use the CASE statement on oracle 9.2.0.4 on Redhat
(intel) and 9.2.0.6 on PA_RISC HPUX and seem to get a strange error in
a certain case.  Either I am doing something very silly, or there is a
bug in Oracle.  Here is my test case:-

1. I begin a transaction
2. I insert data into a table
3. Commit.
3. I open a cursor to select the data i just inserted.

I am using Oracle 10.1.0.3 on a Red Hat Enterprise Linux server (see
below for kernel version and so on).
I have a complex query (joining quite a few tables) that is using
full table scans in some places where I think that access by indexes

Experts ,
I am working on a need to clone databases..and in that I need to write
a shell script which will 'dynamically generate' the init.ora file for
target database using that of source database and a temp file which

I've launched (through ADO and OLEDB provider) this query on a Oracle
8.1.7 server:
SELECT * FROM
  (SELECT field1,... , fieldn, RANK() OVER ( ORDER BY field1,..,

Is there any data dictionary which gives short version description of
database?
I do not want to query v$version, because v$version gives me detailed
info. I just need a short description of db version like 9.2.0.4

select
 PL.SYSTEM_CONTROL_NO AS "SCN",
 PL.AGENCY_CASE_NO AS "OCA",
PL.AGENCY_ORI_NO AS "ORI",

I am trying to use an oracle view in ms query, but it MS query keeps
telling me that it cant use the table in ms query.
Will MS Query work with oracle views ???
Regards,

Hello out there,
I am trying to compile some OCI demos that come with Oracle. I am have
installed Oracle 10 on Linux. When I go to the following
directory:

I just got yasql up and running (and its great!!). The only thing which
I've not been able to find is how to autorun a script at start up.
SQL*Plus will autorun glogin.sql, or any scripts in my SQL_PATH
directory. Yasql does not do the same (as far as I can tell).

Hi ng,
there is a database with
- a schema DAT that contains the Data including all Tables and integrity
triggers that are necessary.