dparker (AT) learnnc (DOT) org wrote: the 'as SYSDBA' when logging in...

dparker@learnnc.org

07-21-2003 12:32 PM
TurkBear

I have to create a trigger that, using java class, calculates a barcode (EAN13) ena having in input a number from an autoincrement object (sequence...

Nicola

07-21-2003 01:37 AM
Billy Verreynne

Stonebraker's original contribution is far different from today's PostgreSQL. Also it is based on postgres not Ingres. Ingres goes back to earlier...

Keith

07-21-2003 12:59 AM
Frank Foss

Guess what, I am using the auditing feature of Oracle, but the user_audit_trail view does not tell me, for just those "very important columns" who...

Ted Knijff

07-20-2003 06:24 PM
Ted Knijff

some1 wrote:

Anna C. Dent

07-20-2003 09:21 AM
Anna C. Dent

Fari paladon wrote: # ./exp --help LRM-00116: syntax error at '-' following '-' EXP-00019: failed to process parameters, type 'EXP HELP=Y' for...

Timo Nentwig

07-19-2003 04:06 PM
Sybrand Bakker

If you are using the Oracle Forms Server you can get the actual end-to-end response time from the log file. You can code it yourself, or use a tool...

Sybrand Bakker

07-19-2003 04:03 PM
Jitendra Patel

Hi, I am trying to create a view which shows inheritence but cannot get this right. I have provided the table and data to assist anyone kind enough...

GlenT

07-19-2003 02:49 PM
Laly

Hi! As you'll notice I'm new to oracel :) I set up 9i r2 on a linux machine but the attempt to connect to a database (java, jdbc) ends up with...

Timo Nentwig

07-19-2003 11:59 AM
Timo Nentwig

It is a long time I try to install Oracle 8.1.7 on miy linux PCs (Mandrake 9.2, Mandrake 8.1) but without results. In first case (using Mandrake...

Nicola

07-19-2003 05:32 AM
Nicola

Just being informative .. Dont kill the messenger. http://www.eweek.com/article2/0,3959,1196879,00.asp

Keith

07-19-2003 12:08 AM
Noons

Keith <nospam (AT) nospam (DOT) com> wrote in news:vhgep3qcble8e9 (AT) news (DOT) supernews.com: That article doesn't mention any data...

Keith

07-18-2003 08:36 PM
Orville

Hi, there' s a new Tool (only Windows) called Sql-Biest available. The Sql-Biest is a fast development and administration tool for Oracle. It is...

Stefan Bieringer

07-18-2003 08:06 PM
Daniel Morgan

Originally posted by Sricharan Saripalli -- Posted via http://dbforums.com

carlos_lotero

07-18-2003 04:24 PM
carlos_lotero

It's recent.. I know it works in 9i, but not sure about 8i (don't have an 8i instance to try it on). It absolutely did not work in 7.x. "Thomas...

Ian McCall

07-18-2003 03:41 PM
Thomas Kellerer

Before issuing your statement, in SQL*Plus, enter the command set define off SQL*Plus treats the & character as the start of a varialbe name. ...

JJ Reynolds

07-18-2003 02:41 PM
Anurag Varma

Hello everybody, we are experiencing a quite strange problem in our environment. An application has to check-in (embedded sql) a certain amount of...

Marco

07-18-2003 11:42 AM
Marco

Hello, i use java procedure in an oracle job. This procedure run continous without a stop. So i have problem to set job offline. Is there a way to...

thomas

07-18-2003 09:14 AM
thomas

Hi everyone, I have a master procedure which opens a cursor and then calls another CHILD procedure that has to do some other work. I need to pass a...

GF

07-18-2003 03:19 AM
GF

Bob Woodward wrote: Then go to http://www.yahoo.com, open a free account, and get back to tahiti.oracle.com. You can't expect this usenet group to...

Jusung Yang

07-17-2003 06:33 PM
Niall Litchfield

My name is Lino Giuseppe and I'm a Italian Studente of Bari. I'm doing my thesis and i need help, any kind of help. I'm study "test automation", so...

pino

07-17-2003 05:03 PM
pino

"Sybrand Bakker" <gooiditweg (AT) sybrandb (DOT) demon.nl> wrote < snip > Your last remark is both off-topic and has a nasty racist tone. You...

Billy Verreynne

07-17-2003 04:10 PM
Robert A.M. van Lopik

I have the following table: create table t ( t1 varchar2(35), t2 varchar2(35), t3 varchar2(35)); And I insert into this table the following...

Pierre

07-17-2003 03:31 PM
Svend Jensen

i have installed Oracle9iDS Release 2 in a separate oracle_home as my Oracle9i db on a Win2k workstation. When i try to launch: Oracle9i Developer...

Guy Dillen

07-17-2003 03:24 PM
Guy Dillen

Frank T. Rambøl wrote: SQL> Set pause off Svend

Svend Jensen

07-17-2003 03:15 PM
Svend Jensen

Daniel Morgan wrote: Yes, I am aware that I would have to re-write all the procs, and I had counted on that. All SQL is in the procs, so what I...

Michael Rothwell

07-17-2003 03:15 PM
Michael Rothwell

I wrote a small VB application that will read in an Oracle package from a text file and apply it to the database using the ExecuteSql function. The...

JP

07-17-2003 02:58 PM
JP

I'm doing a query similar to this in structure, and it currently works fine in Oracle 8.1.7: SELECT tableOne.name, tableTwo.nameAgain, (SELECT...

Robert Schultz

07-17-2003 02:20 PM
Sybrand Bakker

Actually the query returns LOTs of rows. It just took a long time (and err out) for a Large set of rows. I started trying to do ROWNUM = 1 and it...

Kin Ng

07-17-2003 02:13 PM
Kin Ng

Hi Newsgroup! I like to know how to create and write a file in pl/sql in a stored procedure. Thanks, Ralf

Ralf Schnickmann

07-17-2003 02:04 PM
Sybrand Bakker

" The site, which is owned by major airlines and has expanded aggressively into hotel reservations, froze around 6 a.m. EDT on Wednesday and was...

Keith

07-17-2003 11:41 AM
Ryan

Knackeback wrote: when to use it, its implications, what you lose and then do it. And put your redologs on a different disks. I know, it's always a...

Volker Hetzer

07-17-2003 10:01 AM
Volker Hetzer

Hi, Can anyone shed some light on what an "embedded developers agreement " with oracle would be and how that impacts on our access level to an...

tw

07-17-2003 09:56 AM
Phil Britton

Hi, Okay, so I didn't realise what information was required. Here it goes: Sun Solaris 2.7 - Enterprise 450. Oracle 8.1.7 Optimiser =...

Craig Burtenshaw

07-17-2003 09:07 AM
Richard Foote

Hi to all I have this query select a.* -- a is a view from a left join (b inner join c on b.f1 = c.f1) on a.f3 = c.f3 that give me a ORA-00904...

Fabio

07-17-2003 08:30 AM
Fabio

Hello everyone, Is there a way to find out how much diskspace all objects of a particular shema are using? thanks for your help Markus

Markus Boehmer

07-17-2003 08:29 AM
Alex Lamp

I have the following table: create table t ( t1 varchar2(35), t2 varchar2(35), t3 varchar2(35)); And I insert into this table the following...

Pierre

07-17-2003 07:52 AM
Billy Verreynne

Hi all, I am working with weblogic. I need to know at any point of time how many users were connected to Weblogic. A piece of code will be...

sreeanne

07-17-2003 07:48 AM
Niall Litchfield

Hi Areon Ku, thanks for writing this: What error are you getting? Is this the actual code? Well, I see 3 'begin' statements and one 'end' statement....

Karsten Farrell

07-17-2003 07:33 AM
andrewst

Ian McCall wrote: It appears that you don't own the table. You must, in this case, use the fully qualified object name which is: schema_name dot...

Ian McCall

07-17-2003 07:20 AM
andrewst

Keith wrote: Or the crossposting? Problems happen. The difference between oracle and other db supports is that oracle support is actually competent...

Volker Hetzer

07-17-2003 07:10 AM
Volker Hetzer

Hi can anyone recommend a UK or Ireland based freelance trainer for Oracle 9i Developer training. Would be an advantage if they have their own...

David Bole

07-17-2003 06:22 AM
David Bole

Hi All, I've been asked to do a code review, and came across this line... select nvl(count(*),0) into variable ....and I'm not sure if it is...

Steve Holdoway

07-17-2003 05:24 AM
Steve Holdoway

Greetings, I am developing an application using C++, and using OCI to access Oracle database. One process read data from a table, let' call it TA,...

music4

07-17-2003 03:11 AM
Billy Verreynne

Hello, I thought I'd hit up the Oracle gurus in the crowd to seek any assistance and/or strategies on approach. I have one table with straight...

Toney

07-16-2003 08:14 PM
Daniel Morgan

On Wed, 16 Jul 2003 16:50:42 +0100, "Mahesh" <mash1830-yahoo (AT) yahoo (DOT) com> wrote: You need to set an init.ora parameter for that. Can't...

Sybrand Bakker

07-16-2003 07:08 PM
Anurag Varma

Hello all, I want (using the DBMS_output.put_line) create a table using a oracle package. So, i need to insert a TAB or something in the...

Andre

07-16-2003 03:36 PM
Daniel Morgan

Greetings, I am trying to install Oracle 9.2 on to a Windows/XP machine for the first time, but am getting the following error: "Thrown when the IP...

Simon Knights

07-16-2003 11:36 AM
Simon Knights

i'm exporting data from a table to a txt file but in the top of the file is written the sql statement i need that in the file are written only...

CogitoErgoDigito

07-16-2003 10:45 AM
Alan Mills

Hi oracle folks, I have done the following insert statement: the datatype of datum_upd is DATE. SQL> insert into manser.previsions...

Manser

07-16-2003 08:40 AM
andrewst