I try the extend and it works fine. Thanks also for the collection site. There are great informations there.

testmirora

12-21-2004 10:26 AM
testmirora

I am attempting to return a keyword of 'Novice', 'Journey' or 'Expert' based on dates held in three columns and the userid. The date references the...

Tim Frawley

12-20-2004 08:02 PM
Mark D Powell

Hi, COULD ANYBODY HELP ME UNDERSTAND THIS ERROR PLEASE, I'm trying to initialize a collection ALREADY DEFINE. DESC SEARCH_X; SEARCH_X TABLE OF...

testmirora@hotmail.com

12-20-2004 07:46 PM
DA Morgan

I need to store character data of size up to 64K. Is it a good case for using CLOB column? - I was thinking that CLOB was designed for much larger...

kenosha

12-20-2004 05:06 PM
Thomas Kyte

Is it possible to embed an IF - THEN - ELSE statement INSIDE of a SELECT statement?

WebTracer

12-20-2004 01:25 PM
Thomas Kyte

I have a function which returns an object type which is just a wrapper for four native sql types. When I call the function it takes x time, but if I...

streib@cs.indiana.edu

12-20-2004 01:20 PM
GQ

I have just upgraded my AS from 9i to 10g and none of my forms will now do any processing. Is there anyone who has had this problem as i have...

PeterHardy

12-20-2004 11:21 AM
PeterHardy

According to Oracle's documentation (SQL reference), GROUP BY and HAVING clause cannot have scalar subquery. However, I tested with Oracle...

12-20-2004 09:19 AM
Mark D Powell

I am using Oracle. When I define the new tables, I need to add one column at a time (or a few columns at a time for large table) using 'alter...

12-20-2004 07:56 AM
Thomas Kyte

Hi, This is a really elementary question. What is the command to list all the tablespaces in the database? Thanks. Grace

Grace Tsai

12-18-2004 07:58 AM
Andy Hassall

just run into a problem with Oracle 9i running on Linux If my exceptin handlers don't reraise exceptions, all works as expected: CREATE TABLE AAT(N...

ford_desperado@yahoo.com

12-17-2004 03:14 PM
DA Morgan

Hi Guys, We are planning to migrate my Sybase Database (Large in size) to Oracle 9i/10g. Can somebody tell me what are the benefits I get by this in...

sampath

12-17-2004 03:11 PM
DA Morgan

I've downloaded the 8.1.7 client (about 220MB) but it doesn't come with the Oracle Installer. I can' find it anywhere on the Oracle download pages...

Kev

12-17-2004 02:59 PM
Frank van Bortel

I have a table T1 with columns ( C1,C2,C3). I've written say a complex SELECT query that returns 3 fields say S1, S2, S3 of the same data type as...

Mansoor Azam

12-17-2004 10:12 AM
GQ

If somebody still have interrrogation abou this check out...

mboizeau@free.fr

12-17-2004 06:22 AM
mboizeau@free.fr

Hello everybody, what are the minumum requirements to install JPublisher 10g standalone (I have to access an existing Oracle 8.1.7 Server)? Thank you...

cmi@ch.ibm.com

12-16-2004 01:11 PM
cmi@ch.ibm.com

Guys, I've got a problem with Oracle 10g on a Solaris 10 x86. I was able to install and create a database successfully. I saw a lot of...

Alexander Prohorenko

12-16-2004 11:41 AM
Alexander Prohorenko

AlphaTIX is a powerful, fast, scalable and easy to use Full Text Indexing and Retrieval library that will completely satisfy your application's...

SoftComplete Development

12-16-2004 08:57 AM
Rauf Sarwar

We have the following problem. We use Intermedia for full-text searching in external files. We place the files in a specifice directory (../docs)....

ako

12-16-2004 07:21 AM
ako

Hi, I used to program pl/sql, but I would like to learn some more of Oracle db now to improve my chances of getting back in the jobmarket. I have a...

EM

12-16-2004 06:04 AM
Rauf Sarwar

Hello, We are in a process of going for Oracle 9i licences. But I would like to know which are the options available in Oracle 9i Standard...

sameer_deshpande

12-16-2004 04:04 AM
sameer_deshpande

Abhisek wrote: Hello Abhisek, I am getting the similar error from purify for OCIServerAttach() function call. Did you manage to identify the...

dharan@newspage.com.sg

12-15-2004 10:29 AM
Dave

Hi, I need to learn about the Oracle financials software so that I can get a job> How do I get some education on Oracle financials software? Thanks...

Peter

12-14-2004 07:02 PM
DA Morgan

Hello, I'm hitting the old problem that I need to spool data into a text file, but SQL*Plus insists on padding the fields to the length of the...

Thomas Kellerer

12-14-2004 05:26 PM
joel-garry@home.com

Hallo together has someone practice with oracle 10g lite on Windows 32bit systems ? Detlef Klauser

Detlef Klauser

12-14-2004 03:43 PM
Detlef Klauser

Such a simple question, but nothing I am reading makes me feel confident I have this right. A single plsql procedure needs to select from one table,...

Malcolm Dew-Jones

12-14-2004 03:39 PM
Sybrand Bakker

I have a very large program (2000+ lines) and I want to try to break it down into smaller pieces, make it more modular. I have a cursor with 80...

Keith

12-14-2004 05:18 AM
Patrick van Zweden

Hi all, Question about the FNDLOAD, a data migration tool that gets delivered with Oracle Applications. The FNDLOAD tool works by creating control...

Patrick van Zweden

12-14-2004 04:49 AM
Patrick van Zweden

All, I am trying to select from a list of ids where the ids are not in a table. So far all I've come up with is adding all the ids to a temporary...

dmclaude

12-14-2004 04:01 AM
Sujit

I'm using Oracle 8.1.7 and trying to figure out the effect of using ALTER USER IDENTIFIED BY password -- syntax 1 versus ALTER USER IDENTIFIED BY...

Jim McMahon

12-14-2004 02:21 AM
Michel Cadot

Hello Stecal, I am doing my homework..........Reading the Oracle Doc... ----- I can run WebForms through the Web. I can call-up the Reports Web...

ptreves

12-14-2004 12:55 AM
ptreves

I have at least three complete set of Oracle 8 Manuals and many Oracle Press books, with Forms CBTs and Videos. If you are interested let me know -...

sholay_at_heart@yahoo.com

12-13-2004 09:08 PM
Mark Bole

I am writing a PL/SQL program (a single anonymous block) that performs a query input by the user at run-time. I want to allow the user to read...

pbewig@swbell.net

12-13-2004 08:32 PM
DA Morgan

Is it possible to develop a report in SQL*Plus in a bill type format with multiple selects? I want to run a select to see my customers personal...

Collywobbles

12-13-2004 08:03 PM
Mark C. Stock

LOOP BEGIN GOTO INSERTREC ...... GOTO UPDATEREC ...... GOTO DONEXTREC

seanj

12-13-2004 07:55 PM
Mark C. Stock

Hi Everybody, I am looking for Oracle 9i DBA Practice tests, "Test King" or similar ones any help Thanks a lot

WT

12-13-2004 11:11 AM
WT

Is there way to count a number of rows in opened cursor before fetching it (%rowcount works only after fetching)? I need to know the number of...

eudorica

12-13-2004 04:26 AM
tojo

Hello, I reinstalled my Forms/Reports Services 10g on my Linux Red Hat Enterprise 3 (ES) box. I can run my WebReports stand alone from the Reports...

Paolo Treves via OracleMonster.com

12-12-2004 06:11 PM
Paolo Treves via OracleMonster.com

Could anyone shead some light on this problem that I'm faced with. I have a stored procedure that has 2 parameters. The first is the primary key ...

Adrian Scott-Day

12-12-2004 03:58 PM
Noons

http://www.developer.com/db/article.php/10920_3308841_3 This is the first chapter of connor mcdonald's book.

Oradba Linux

12-11-2004 11:26 PM
Oradba Linux

Hello, an Oracle-DB with several constraints does complain correctly if a user tries to insert data over the frontends which do not fit to the...

Thomas Blankschein

12-11-2004 10:51 AM
Sybrand Bakker

hi everyone, I'm not sure whether this is the right NG for my questions. If not, please let me know which NG would be the better one. My Q: We have...

dbyy

12-11-2004 07:26 AM
dbyy

Okay first up this is not a NULL vs. Empty String thing as I am well aware of that little gotcha but instead it is when a 'Null' string (a person's...

jbainbridge@gmail.com

12-10-2004 09:02 PM
DA Morgan

It is possible to install and run it BUT Oracle does not certify it... which means no support. They only certify it on NT. Regards /Rauf

Rauf Sarwar

12-10-2004 08:58 PM
DA Morgan

I posted this question on Oracle Metalink back in October, but didn't receive any feedback so I just wanted to present the issue again. (...

KurtisK

12-10-2004 09:03 AM
KurtisK

Hi All, I am hving real trouble with this one. Basically I've been asked to crack down on database security. Everyone knows all the passwords...

amerar@iwc.net

12-10-2004 05:13 AM
Volker Hetzer

Can anybody help me in setting up SQL. I never set a password but it is asking for the same, what do I do ??

Manish

12-09-2004 11:34 PM
HansF

Hi! I have an Oracle 9.2 database set up with UTF-8 and nls_length_semantics=char (W2000 Server). I have data in an access database which I want to...

Hans

12-09-2004 09:22 AM
Hans

I have a field (acct) that I want to create an index on. The index field needs to be reset to 1 everytime the acct changes. I have mainly only...

sbowles@lwcky.com

12-09-2004 03:22 AM
Douglas Hawthorne

Hi, I would like to introduce a new VoIP(Voice Over Internet Protocol) Usergroup to you. The link is:...

erika_angella@yahoo.com

12-09-2004 02:16 AM
erika_angella@yahoo.com