Good Day All, I am using Oracle 7.3. Using the following table definition and sample data, how can I obtain the PayID which has the maximum PayDate...

Smartin

05-02-2006 06:30 PM
Smartin

Se subj. læs mere her : http://orakons.googlepages.com/cykeltilsalg sælges af privat. Henv. på orakons (AT) gmail (DOT) com

Alfons Åberg

05-01-2006 05:07 PM
Alfons Åberg

Oracle 10.1.0.3.0 Whenever we see row-level contention, or even today when a table lock caused contention for incoming DML, we see a huge spike in...

chuck_forbes

04-27-2006 03:42 PM
chuck_forbes

Hi, I've got 2 databases which need to update each other. Some of the updates can occur in the same tables. Also these databases don't have the...

berj

04-01-2006 11:08 PM
berj

Oracle 9.2.0.6 in AIX I am trying to find ranges and where the range ends for each d_no: The increment of val is one My example is: select * from...

Oxnard

03-21-2006 04:40 PM
Mark C. Stock

How do I reset the default file locations for Oracle Xe? -- Thomas M. Fuller thomas.fuller (AT) worldnet (DOT) att.net

THOMAS FULLER

03-15-2006 06:34 AM
Mark C. Stock

OMNI GROUP tgugger (AT) sbcglobal (DOT) net 419-537-9447 ORACLE APPLICATION SERVER (OAS) OPPORTUNITY AVAILABLE

OMNI GROUP

03-13-2006 11:21 AM
OMNI GROUP

Email your resume to: JMinton (AT) emdeon (DOT) com The position will be part of the WebMD Mercury ITG support team and will assist the teams in...

Jason Minton

03-12-2006 04:36 PM
DA Morgan

Please email your resume to me if at: JMinton (AT) Emdeon (DOT) com if you feel you could excel in the below position as a Siebel Production...

Jason Minton

03-10-2006 01:10 AM
Jason Minton

Hi all, I am thinking about becoming an Oracle developer. I have experience with Centura Team Developer AKA SQLWindows, this is a front-end...

Corrado Valiente

02-24-2006 04:11 PM
HansF

Hi, Is there any SQL command in Oracle that returns a "CREATE TABLE" statement in Oracle. For example in MySQL there is a command called "SHOW...

Jack Miller

01-30-2006 09:20 PM
Jim Kennedy

I have been finding some strange behaviour with the Oracle InstantClient 10 libraries on Solaris 10 (Sparc 9). We are running the 10g 64bit server,...

PJ Halls

01-18-2006 05:51 AM
PJ Halls

Hi How can I remove all tables UserName.TblNam1 UserName.TblNam2 UserName.TblNam3 etc with one SQL statement?

Jan Doggen

01-09-2006 10:59 AM
Chuck

How can validation testing on DBMSs such as DB2 and Oracle be performed? Is there a quick commonly used publicly available DBMS test that can...

z

12-14-2005 03:52 PM
DA Morgan

US-VA: Sr.Oracle ATS/Testing LoadRunner QuickTest Pro # 1129R1 Start Date: ASAP Duration: 1 Month++ Rate: $50-$60 DOE Expenses: PAID

DosLaredos@gmail.com

12-04-2005 09:06 PM
DosLaredos@gmail.com

i am at uni studying computer science and as suh have to program an swl database, the problem is the mahine that the database has to exist on...

Andrew Gardiner

12-01-2005 01:14 AM
Paul

Hello, 1) What type will NrInstances have in this query: SELECT Module_ModuleType as LicProgPartID,'Module' as LicFor,COUNT(Module_ID) as...

Jan Doggen

11-25-2005 04:36 AM
Jan Doggen

goto control panel > admin tasks > services and set thestartup type to mannual

%u

11-22-2005 11:56 AM
%u

I have the following procedure: TYPE testarray is table of int index by binary_integer; PROCEDURE testfast(par1 in testarray) is begin FORALL i IN...

Tor Hovland

11-16-2005 10:28 AM
HansF

Hello, I'm building a wireless application with Java J2ME (CDC profile). My application needs a direct connection with a remote Oracle database....

news.xs4all.nl

11-15-2005 04:56 AM
news.xs4all.nl

Hi, I wonder if anybody can help. I have a where clause which looks for a string pattern e.g. Select * from Table where Instr(String1,string2) >...

Ashley Morgan

11-14-2005 02:57 PM
Frank van Bortel

Hi everyone Firstly i would like to thank everyone for their help an suggestions However, i still could not fulfil my boss request. Here what i need...

losway

11-11-2005 03:11 AM
Altasen.com

Hello all: I am fairly new the Oracle and SQL and I am trying to find out how can I achieve the following: I have a program that uses a database...

FC

11-11-2005 03:11 AM
Altasen.com

I am looking for a rules engine, based on Oracle, that is as generic as possible. I don't even know if such a beast exists. The application area is...

Malte

11-09-2005 03:11 AM
Altasen.com

I have the CDs for version 10.1 Enterprise Edition and have successfully installed them. I want to upgrade to 10.2. When I bought the CDs the...

Paul

10-30-2005 11:48 PM
HansF

Hello, For my study I have some questions about Java J2ME: 1. Is it possible to develop a J2ME (CLDC/ MIDP) application, which has a direct...

news.xs4all.nl

10-28-2005 11:42 AM
news.xs4all.nl

Hello, Could some one tel lme what is the real time use of oracle Virtua Indexes.. Thanks -- techguruMessage posted via http://www.exforsys.co

techguru

10-24-2005 02:44 AM
Ashish Shanbhag

Today, I noticed different empty string behaviour then I am used to. Before, empty string was treated as null, so statement vcResult := 'something'...

krofak

10-21-2005 01:23 PM
krofak

I want to unload data from table in oracle to table in anothe database,for example DB2 Can you help me with a sample code thanks

tonik

10-19-2005 03:11 AM
dbaman

Hello boys must install for test Oracle Rac on my pc a Windows 200 only I have a problem do not have no other PC to put in cluster wit mine there is...

spignex

10-19-2005 03:11 AM
spignex

Can anyone help to understand why re-parsing occurs on a remote database (using database links), even though we are using a prepared statement on the...

Pentti

10-14-2005 03:11 PM
Pentti

Pls, post in cdo.server; this ng is not carried by many ISP's -- Regards, Frank van Bortel Top-posting is one way to shut me up...

Frank van Bortel

10-05-2005 02:29 PM
Frank van Bortel

Can all "joins" be mimicked via nested selects?

DG

09-22-2005 01:03 AM
DG

when i create a new database , assistant does not ask to me the database internal password..I don't understand why ??? thanks reply on...

dave

09-09-2005 12:25 PM
dave

Suppose that you are connected to an Oracle database with the user SYS or SYSTEM. I know that there is a way to inpersonate another Oracle user...

Martin

09-07-2005 10:27 AM
Martin

RDBMS Version:: 10.1.0.3.0 Operating System and Version:: MAC OS X 10.4.2 Product Version:: ORACLE Db10g Version 10.1.0.3.0 OEM Console Operating...

max

09-06-2005 07:25 AM
max

Hello all: I have a very basic question about oracle database structures. I am coming from MS SQLServer where I have three "databases", each...

FC

09-04-2005 12:32 AM
FC

Hi, I want to bind an array to the following sql statement using oci SELECT UUID FROM TEST WHERE TYPE=:VAL UUID is INTEGER TYPE is CHAR(1) If i...

Bruce Collie

09-03-2005 06:34 PM
HansF

Hi all! Sorry guys but I am totally ignorant on oracle matters. I need some guidance in how and what is needed to connect directly to an oracle...

Andrew

08-21-2005 03:40 AM
Andrew

Anybody knows a way to produce output from a SELECT statement on a single line, instead of each hit on a separate line? Here is what I mean: let's...

R. P.

08-16-2005 02:52 PM


Hi everyone! We've just installed a two node 10G RAC environment under Linux AS 3.0 for EM64T (Intel's new chip) with shared storage on an EMC box...

stheby

08-10-2005 10:22 PM
stheby

Announcing complete and extensive PowerPoint slides for both an introductory and an advanced database course, along with supporting manuals,...

Ellis Cohen

07-22-2005 10:13 AM
Ellis Cohen

Hello, SLES9 SP1 is on PIII with two 800MHz procesors and 2GB RAM, on four SATA 156GBhard disks are created two RAID1 arays, on one RAID is OS with...

Martin Solveig

07-11-2005 06:41 PM
Mater

Hi everyone, I wondered if anyone has have experiences with using JDeveloper with Oracle 7.3.4. (Yeah, I know you are probably wondering why we are...

The Doctor

06-18-2005 04:07 PM
The Doctor

A customer has 11i Purchasing and is unsure how to configure it for sending a fax. After they reserve the funds, there are 2 radio buttons; Print...

Slider

06-16-2005 04:21 PM
Slider

Hi there Am just about to deploy a new application - one of those 'generic' database types with very little Oracle specific functionality built...

simoncole

06-15-2005 04:39 PM
Paul

How can I create a link setup with oracle and DB2

tonik

05-31-2005 03:05 AM
tonik

DA Morgan wrote: To be really fair, this is just nitpicking on the semantics. To most people, "licensing" really means "total cost payable to the...

Rhino

05-28-2005 04:31 PM
Jasper Scholten

Hello everyone! Has anyone every seen the following behavior? Oracle 9.? running on AIX, no problems here Windows NT machine, Oracle client...

DG

05-27-2005 05:10 PM
DG

Hi, A few years ago (2000 ?) I installed an oracle client on a linux server (oracle8iR2 on Debian Woody) and everything went beautifully. ...

carex

05-24-2005 03:52 PM
carex