I have this query:
SELECT q10.q10_count,
vi.mgr_flag,vi.inst_type,vi.inst_num,vi.inst_cst,vi.inst_zip,vi.inst_phone,vi.url,vi.turnover,vi.hold_cnt,
vi.date_,vi.inst_size,vi.inst_dchg,

I have the following cut down pls/sql:
cur_entries cursorType;
IF condition
  open cur_entries for

We have to look at ,igrating data from an existing system that was built
using mysql. Was in two minds where to post this to or whether to cross-
post but decided to ask here first.
Does anyone know of any utilities that will enable a mysql schema to be

This is what I wish I could to do.
insert into table_x (a, b, c)
 values(1, 2, 3)
   where not exist (select * from table_x where a = 2);

Hi. I have a server "A" with oracle 10g express (free) and a server
"B" with an Access database.
I need that an application that uses oracle server can reads tables on
"B". How can i do this?

Hi...
I have an index organized table on which i'll be carrying out a select
of the following type...
select value from table

I need to be able to pull just the last name out of a string consisting of
lastname and firstname, separated by a comma, or space, or comma and space.
Complicating matters somewhat is the fact that lastname might be something
like "Mc Kay" or "St. Louis" so simply grabbing ...

Please look at this query.  notice that most of the criteria is the
same, except for 1 line.  I need to get the count for 10 items.  Is
there a better way to do this so I do not have to repeat the criteria
for each item I want to return?

executing the following query
SELECT b.tablespace_name, a.*,
      TRUNC (a.segment_size / tbs_size * 100, 2) segment_perc_used,
      b.tbs_freespace,

I have to clone a DB to built a Test DB.
To avoid manual work our admin wrote a script, that in general
- fills some files with file structure
- fills some files with parameters

How to write down the comment in a database?
Example:
CREATE View:
CREATE VIEW test(COL1) AS

Please distribute this email. This is a reminder. Data on both agile
and plan-driven projects are welcome.
To Whom It May Concern,
My name is Donald Buresh, and I am a Ph.D. student at Northcentral

 I'm setting up my first ASM based database ever. (Just for testing
and learning, NOT for production). I only have 3 physical disks in the
ASM disk group. (4 total physical disks in the server).
 I am loading the OS (Windows 2003 server) on one physical disk as

In order to upgrade a 9i DB (Oracle 9.2.0.5 on Redhat Linux Adv.
Server 2.1 32 bit) to version 10g (Oracle 10.2.0.3 on Redhat Linux
Ent. Ed. V 4 64 bit) I will move all files of the shut down DB to a
new server where the target version of Oracle is istalled and take

we are running oracle 10 on suse linux. when i try to rebuild the
tables i see this message:
"ORA-29400: data cartridge error
ORA-01688: unable to extend table..."