Hi everyone, I would like to ask how am I going to execute multiple scripts using UNIX command? I have found a command to execute. However, I cannot...

teckguan

12-25-2007 08:26 PM
teckguan

Hi I am writing a program (in c#) which provides functions for "document handling". Each document is represented by a row in an Oracle...

Peter K

11-14-2007 09:46 AM
Ana C. Dent

C# Web Service in IIS Stops Connecting to Oracle (via ADO.NET) Over Time I have a Web Service, written in C#, published on a Windows XT Web Server...

Temporary

11-13-2007 10:18 PM
Temporary

Hi all Is possible with RMAN recover only one table of my db? Where can i find some infromation about this? If is not possible , where can i find...

Alex

11-08-2007 02:36 AM
Lodewicus Maas

On Mon, 7 Jul 2003 15:39:51 -0400, "Charles" <u96_cwang (AT) hotmail (DOT) com> wrote: My experience is that using ODBC is quite slow, I would...

ajk

11-02-2007 07:29 AM
ajk

I have a table in Oracle9i that has an index on a Date field. The NLS_DATE_FORMAT is set to 'DD-MON-YY'. If I run a query on the table and compare...

DBF

10-11-2007 08:10 PM
DBF

My address is: Robert Bralic Danilska 7 Razine 22000 Sibenik robert.bralic (AT) si (DOT) t-com.hr (If you are from croatia please don't answer...

Robert Bralic

07-30-2007 01:16 AM
Robert Bralic

Help! I am running 10g database and wish to connect to it via mod_plsql in HTTP Server. I have installed HTTP server from the companion CD, but am...

Matthew Harman

06-22-2007 11:52 PM
Ana C. Dent

Is it possible to obtain data from two different databased, each being on a different server. How would the query be written? example: TABLE1 on...

JustAQTCub

05-20-2007 07:06 PM
snlrice

Is there a command to export just field names from a given table to a comma delimited file?

Brian

03-07-2007 08:47 AM
Brian

I'm new to Oracle and stored procedures in general. I need to write a sp that can be coded to dynamically reference different schemas. Can someone...

Lorenzo Thurman

02-28-2007 02:21 PM
Lorenzo Thurman

We are experiencing difficulties with "identical" sql's switching execution plans. When trying to research this on metalink, there is a reference to...

larry larsen

02-17-2007 08:34 AM
Ana C. Dent

We are experiencing difficulties with "identical" sql's switching execution plans. When trying to research this on metalink, there is a reference to...

larry larsen

02-12-2007 06:35 PM
larry larsen

Hi all! Can anyone help me? My problem is a group by! For example select tabA.x , tabB.y, (select sum(tabC.z)....) as q .. .. .. group by tabA.x ,...

Ale

02-12-2007 02:37 AM
Ale

Group, I'm running Oracle 8.05 with Solaris 6. I have a database with several schemas, and I want to create a test schema from one of the other...

Julie Warden

01-04-2007 05:08 PM
Julie Warden

Is there a resource for database field naming conventions? Jerry

Charlie

12-23-2006 12:40 PM
Paul

Has anyone ever attempted multiple regression within Oracle? Just curious... Thanks, Andreas

Andreas Sheriff

12-19-2006 06:30 PM
Andreas Sheriff

In attempting to solve a problem posted earlier (see "non-tab delimited output?) I discovered that, in their infinite wisdom, the MySQL developers...

Michael Austin

11-22-2006 11:54 AM
Michael Austin

Let's say I have three database users: * user_a * user_b * user_c user_a has a table called table_a upon which user_b and user_c create their...

Kristian

11-18-2006 08:46 AM
Paul

I have an application that is used by users across the country. It reads from a table in a centrally located database. It needs to convert...

MartyL

11-01-2006 09:15 AM
MartyL

Is is possible to recover deleted rows from a table from archive logs? For example, say you have a database with archive logging turned off. You...

Snonck

10-26-2006 07:22 AM
Snonck

Hello, How does one go about finding all the tables that have a particular field name? For example a field name "EVENT_CODE" I would like to find...

Fred Wilson

10-14-2006 11:53 AM
Paul

I have been searching for answers to this question ... but all I have found is other people asking the same question..but I have not found an...

riggor

10-12-2006 04:23 PM
riggor

Hi everyone I would like to know if using several views for a complicated query is slower than placing all the code in one large query. I had heard...

Jeff User

09-05-2006 09:47 PM
Jeff User

I tried to install 10g onto a MacMini for development environment but it wont install. I changed kernal settings, added groups and users, set env etc...

Combined Resource

09-04-2006 06:54 AM
Combined Resource

On Fri, 27 Dec 2002 14:27:05 -0500, "BK" <benjaminkao (AT) sympatico (DOT) ca> wrote: Precious experience is the relevant phrase. I work for a...

Luso Joe

09-01-2006 11:52 PM
Luso Joe

Hi, Could you tell me (or point me to some information source) what could be the sympthoms of too small component size in SGA? For example - what...

Marcin Szarek

08-24-2006 10:14 AM
Marcin Szarek

Hi I'd like to known the best performance architecture for oracle db server with 100 users access. what kind of processor, memory,hard-disk subsystem...

libre

08-21-2006 06:26 AM
libre

Hi! For a few months we suffer mysterious problem with Oracle 10g RAC (more details on server configuration at the bottom). At regular basis (every...

Marcin Szarek

08-18-2006 05:23 AM
Marcin Szarek

I'm at a loss (and, like a hard-core alcoholic) the "experts" I'm working with won't even acknowledge there is a problem. . . Is there any way to...

John K. Humkey

08-17-2006 11:20 PM
Mark Townsend

Hello to all; Will Oracle ver 7.3 run on windows 2003 server ? Please advise Mike

Mike Bules

08-17-2006 04:42 PM
Mike Bules

Hello DBA’s I have a problem with my TEMP tablespace. It’s 1 GB and its full. Shouldn’t be empty? When the tablespace is full i have to restart the...

airmax

08-09-2006 08:10 PM
HansF

Frank, Still have some issues that need resolving..so I'll wait until I resolve them all. Right now I am real close. The only thing that I cannot...

Dave Williams

08-03-2006 05:19 PM
Sybrand Bakker

OMNI GROUP tgugger (AT) sbcglobal (DOT) net 419-537-9447 ENOVIA LCA / PERM/ NC

OMNI GROUP

07-23-2006 01:32 PM
OMNI GROUP

hello it is possible in oracle 10g to implement history which remember which row in a table was read by a user? thanks in advance Peter

Piotr Kozak

07-18-2006 08:52 AM
Piotr Kozak

I am just learning Oracle 10g, and I thought it would be nice to have some CBT's. Does anyone have some they could post, or know of a binary...

Josh

07-04-2006 05:51 PM
Mark Townsend

Hi, I am looking for a tool to document and maintain a large data model (500 tables). Oracle Designer used to be the tool of choice for this sort of...

AT

06-27-2006 11:52 AM
AT

Is it possible to have the Oracle OLEDB or ODAC drivers for 8i and 10g installed on the same machine? If so, is there a way to select oracle home's...

Chris Skaryd

06-16-2006 06:33 AM
Eric Fortin

Is there an Oracle DB API similar to SQL Server's SQLDMO ?

Chad

06-16-2006 02:29 AM
Mark Townsend

I am trying to obtain a trial key for SQL Navigator Versions 3 or 4. These versions are included in the Oracle9i PL/SQL by Scott Urman. I have...

AT

05-27-2006 06:14 PM
AT

I have some PL/SQL code that has been running for several years and just started giving me problems. It inserts a record from one database to...

Paul

05-25-2006 07:46 AM
Paul

Hi, I'm a newbie when it comes to Oracle, but I was asked to check if an application could run with Oracle, so I installed Oracle XE. The...

Ove

05-22-2006 07:20 AM
Viktor Zacek

I would like to get a little bit of hands on experience with PL/SQL, Developer 6.0, and Report Writer on Oracle in the next few days. I'm very...

Rhino

05-18-2006 09:39 AM
Rhino

Is there a way to catch these exceptions when thrown by PL/SQL? I get them on occasion and apparently the "WHEN OTHER" clause of my final EXCEPTION...

Ubiquitous

05-18-2006 06:49 AM
Ubiquitous

I have several views with unions, outer joints and calculations that later combine to find a "final" report view. This was to make things easier for...

AcCeSsDeNiEd

05-17-2006 08:18 PM
AcCeSsDeNiEd

Hi, I am a SQL Server programmer using Oracle for the first time. In our .NET client apps which use a SQL Server back end, we would use...

Chad

05-13-2006 09:57 AM
Jim Kennedy

Hello, I have Crystal 9.0. Also I have Oracle 9i. (I didn't any normal newsgroup for crystal, so I ask here, please help). I want to give the sql...

Eitan

05-08-2006 08:50 AM
Eitan

Hello, Can I somehow by tricky way, return the current sql running (or id of sql) by the current select statement. Something like : select...

Eitan

05-08-2006 03:58 AM
Eitan

Here's my issue. We've decided to replace a very critical (without it the business would lose lots of money) departmental reporting system with a...

Larry Dooley

05-07-2006 11:48 AM
Jim Kennedy

Hello I dunno if this is the good place to ask. I'm looking for the following information about oracle lite: trigger support? footprint on...

paulus

05-04-2006 10:06 AM
paulus