Hi, i need help on a query. I've this table : create table t ( customer number(5), time date, status varchar2(1)

FRITSCH Vincent

02-24-2004 01:59 AM
FRITSCH Vincent

Hi, I need to retrieve 1. a total SELECT SUM(COL1) FROM SOME_TABLE 2. most frequent values SELECT COL1, COUNT(*) FROM SOME_TABLE GROUP BY COL1 I...

Ford Desperado

02-23-2004 03:00 PM
amit

I tried converting them all using to_char and other syntax but in general I think it can't be done. Can it? Anyone have an example? thanks, Don

D

02-23-2004 02:06 PM
D

I'm running sqlplus from a DOS command line and inducing an error by purposly giving it the wrong script (hence, it cannot find the script file.) ...

tommy

02-23-2004 09:28 AM
george lewycky

How could I execute an exported procedure (in a local .sql file), through a VB or ASP command? For example, I saved a procedure or a package on my...

Buky

02-23-2004 07:31 AM
x

I was wondering - is there some part of sql that can display text? I wanted to add simple instruictions to the beginning of an sql script so the user...

Joe Christl

02-23-2004 06:29 AM
Joe Christl

I'm an ASP/ASP.NET/MS SQL server guy looking for a good book to start me off with Oracle 9i. I'm a computer science senior and have a web project...

dSchwartz

02-22-2004 09:30 AM
Seth Stevens

Hello Everyone, I am trying to install Oracle 9 on my Windows XP Pro laptop so I can play around. I downloaded the 3 ZIP files specified on the...

John De Lello

02-21-2004 05:42 PM
Michael Willer

Is it possible to use a stored procedure as the source of data for a view? The reason I want to use a stored procedure is because (for this...

tkestell

02-21-2004 10:13 AM
SOLSPEAKS

This question is not strictly Oracle only but as I'm using Oracle 8i I couldn't think of a better place to post it! Anyway my problem/qustion is...

Blueyonder

02-20-2004 02:10 PM
Joe Maloney

I store sql-commands in a database table. In the first step I get the sql command out of the database table with embedded sql. In the second step I...

Jan

02-20-2004 12:50 PM
Jan

Does anyone know that code that allows you to replace a lov object in Forms Bulider 9i with a drop down box like you would see on a web interface. ...

Seth Stevens

02-20-2004 10:37 AM
Mark C. Stock

Hiyas I am currently working on Oracle Report which ties in with my a report in the ebusiness suite of Oracle telesales module. Basically, the...

etravels

02-20-2004 10:35 AM
Mark C. Stock

Hello, Is it possible to create a transaction in a transaction? BEGIN T1 INSERT into t1 values(2); BEGIN T2

CM

02-20-2004 10:10 AM
CM

"Niy" <niy38 (AT) hotmail (DOT) com> wrote that's the rules also, '-' has special meaning to the parser however, just like Access and VB use ...

Mark C. Stock

02-20-2004 07:45 AM
x

Dear all, i would like to know that is it mult-thread processing in Oracle Form (6i) ? Please give me advice. Thanks all. se6b14

se6b14

02-20-2004 07:39 AM
Ryan Gaffuri

Hi, I am having a strange problem with the storage parameters in Oracle 9.2.0.1 database. I create a tablespace with some default storage parameters...

Jens H. Hamann

02-20-2004 06:35 AM
sybrandb@yahoo.com

Hello, I received this error message when I issue the drop statement. We are using a 9.2.0.3 DB on UNIX OS. I have been able to drop other...

Brett Baloun

02-20-2004 03:00 AM
m_raj_mohan@yahoo.com

Is this a valid sql statement: SELECT case field1 when 'first' then 1 when 'second' then 1 else null end FROM mytable

Michael Hill

02-20-2004 02:56 AM
kibeha

Hi, i need some help on a query. I've this table : create table t ( customer number(5), time date, status varchar2(1)

FRITSCH Vincent

02-20-2004 01:04 AM
FRITSCH Vincent

I am trying to do some analysis on customer's locality, so I'd like to extract numeric part from address. Here is how the table looks like Table...

David Chang

02-19-2004 10:22 PM
UNIXNewBie

Hi, I have tkprof output with non-recursive and recursive overall timings. I understand that when PLSQL calls sql statements it is considered...

Vissu

02-19-2004 10:14 PM
Vissu

Armed with my new O'Reilly book Optimizing Oracle Performance I have been trying to get a better understanding of how Oracle works. The book makes...

Oxmard

02-19-2004 06:39 AM
Oxmard

We have an application that updates a row in a table. Sometimes Oracle does not respond for over 10 seconds. This is after an insert. It seems that...

Noddy

02-18-2004 06:48 PM
Joel Garry

I am going to drop a primary key from one column and create a new column to be used as primary key in an existing database. The old column was a date...

Ken1

02-18-2004 05:07 PM
Mark C. Stock

I use websphere connection pooling and had a failure attempting a CLOB.createTemporary. tempClob = CLOB.createTemporary(conn,...

Chris

02-18-2004 03:14 PM
Chris

Hi NG is it possible to schedule a PL/SQL proc / function "inside" ORACLE ? Thanks Peter

Peter Jenny

02-18-2004 10:39 AM
Hans Forbrich

I have several questions about queries I make into my database. I will explain you. Could you please help me? 1)In my people table, persons have a...

Vince

02-18-2004 10:35 AM
Hans Forbrich

I have two tables, appointments and backupappointments. I also have a function getAppointments(theDate DATE) RETURN RECORDSET (which has not been...

Jagdip Singh Ajimal

02-18-2004 10:21 AM
Seamus Ma' Cleriec

Hi NG is it possible to protect a PL/SQL proc / func from running more than one instance simultaenously ? Thanks Peter

Peter Jenny

02-18-2004 06:10 AM
Mark C. Stock

Hi, I have a pro*c program that inserts records into a table from another table.This was working fine until i recently upgrade from 8i to 9i. Now...

Dexter

02-18-2004 05:21 AM
Dexter

Hello, I have a very simple table, and want to create a trigger that updates the date column entry (with the current date), whenever a row...

M

02-17-2004 09:39 PM
VC

Hi, This is my first posting to this group. We are thinking to migrate a Informix database which is running on HP-UX 11. Initially we are try to...

Chavan Koya

02-17-2004 11:51 AM
Chavan Koya

Why is it that rows returned from this statement have extra trailing spaces? I.e. today tuesday the returned string is "Tuesday " with the...

Ken1

02-17-2004 08:38 AM
Mark C. Stock

I have a new VB 6 project, and I have successfully created a data environment that connects to my oracle server (they don't make this easy!!). In my...

Jagdip Singh Ajimal

02-17-2004 08:01 AM
Jagdip Singh Ajimal

I have taken over management of a data warehouse running on Oracle/Windows. I would like to add some code to the daily load processing scripts that...

Jack Overhiser

02-16-2004 07:35 PM
SteveE

I am attempting to install the Oracle 8i client on a freshly imaged PC & I receive the error mentioned in the subject line. I have followed the...

Derrick W

02-16-2004 07:18 PM
Hans Forbrich

I am running Oracle Enterprise Edition 9.2.0.1 on Windows XP Professional on my home pc for learning purposes. I want to get familiar with Oracle...

David Carmichael

02-16-2004 12:32 PM
Hans Forbrich

I'm developing an application for medical use that will be used to capture patient background and visit data. The application will...

John

02-16-2004 09:16 AM
Dave

this group should really no longer exist. But google and others still carry it.

Ed prochak

02-16-2004 02:30 AM
sybrandb@yahoo.com

This may be obvious, but I don't write many triggers so it's got me puzzled.. Row level, after update trigger is designed to perform an insert or...

Mike Stenzler

02-15-2004 10:27 AM
Raj Jamadagni

I'm getting a ORA-00600 error on SYS.EXU8REF (see trace file below). SYS.EXU8REF is a view so the problem should be with one of the underlaying...

Doron

02-13-2004 02:40 PM
Ron

Greetings folks, Just curious if anyone knows what the following would produce: SELECT MAX( ECP_SUPPORT_DED_EMAIL.CD_TYP_CMPGN) ...

Jack

02-13-2004 01:12 PM
Ed prochak

I am creating the following view CREATE OR REPLACE VIEW AllMedics AS SELECT * FROM Medic m, Employee e WHERE e.EmployeeID = m.MedicID...

Jagdip Singh Ajimal

02-13-2004 05:58 AM
Jagdip Singh Ajimal

Trying to install Oracle 9i on Redhat 9.0 Get the following error message: Initializing Java Virtual Machine...

ccc31807

02-12-2004 01:34 PM
Unregistered

I would like to install oracle9 database on a ultra 5(solaris9) 270Mhz 256MB ram. Will this machine meet the minimum requirements of installing...

chudee

02-12-2004 12:21 PM
Ron

Hi Guys Need a help i am facing a sporadic issue when executing the query using nested table of numbers Here are the things which i did 1. I...

sarith sutha

02-12-2004 10:23 AM
sarith sutha

Hi, currently my office has oracle 8.1.7.4 on HP/VMS 7-2. Does any one have experience with 9i on HP/vms 7-2?? and if so,, are there major bugs in...

michel v marion

02-12-2004 09:31 AM
michel v marion

I need to find customer's names that repeat / occur more than once in the same table. I have treid many options and I have tried comparing the column...

Nimesh

02-12-2004 04:57 AM
Kalmact

Hie all, I am currently using materialized views within Oracle 9i. For instance I create mv1 on DB bddist2, as a snapshot of sur1 on bddist1...

Matthieu Exbrayat

02-12-2004 02:24 AM
Matthieu Exbrayat