Where can I get the basic version of Oracle 9i to study/practise SQL and PL/SQL? Is the newer version 10 g much better than 9i?

curious

01-26-2004 10:37 PM
KevJohnP

I think this is do-able, and possibly even simple, but it's been too many years since I've done anything significant with SQL. Any help would be...

Philip Hachey

01-26-2004 02:20 PM
Philip Hachey

Hi everyone, if you wonna earn some money using your IT-knowledge, have a look at www.infutura.com. Also you can post there very serious IT problems...

brad.lewis@usa.com

01-26-2004 11:49 AM
brad.lewis@usa.com

Bonjours, Je suis stagière en logiciel et je dois développer 2 applications WEB qui devront consulter des BD Oracle. Les applications WEB seront...

Jiador

01-21-2004 10:23 PM
George Elkins

Galen Boyer wrote: I agree with the sentiment. At the same time, I lurk on about 65 newsgroups and lists (almost all about technology) - the...

Hans Forbrich

01-20-2004 07:25 PM
Joel Garry

We are trying to solve a problem relating to the decimal character used by sessions created by our user ID. We ran this SQL SELECT * FROM...

UNIXNewBie

01-20-2004 09:41 AM
UNIXNewBie

Hi All, I have a Geographic parent/child relationship table with the following columns. Geographic_Units ------------------- Geo_Unit_Code...

Anand

01-20-2004 02:52 AM
Anand

I would like to create a multi-statement table valued function in Oracle (having done so for years in SQL Server). Functions in Oracle do not...

Mike D

01-19-2004 09:41 AM
elwood

I'm trying to change some reference in oracle forms. ref comes from table query so should be valid, but when i try to update old value i...

TommyR

01-16-2004 06:26 PM
TommyR

Hi - I'm trying to query my database to find the min, max and average times (in seconds, or minutes, or something) between two timestamps. ...

Ariant

01-16-2004 11:47 AM
Ariant

Could anyone direct me to a complete list of Oracle DB types? I'm having trouble finding a complete list. # Johannes

Johannes Beyer

01-15-2004 10:11 AM
Jim Kennedy

Hello, Until now we do not want to use Database Links for security reasons. But an application needs to access informations that are on two separate...

Kona

01-15-2004 04:15 AM
Kona

HI ALL ! Have a problem : (this is not a junk) I must learn Oracle9i for 7 months, advice me good literature , and useful links please . I want to...

webber

01-14-2004 07:49 AM
CFoot

Hi there, i have a good working windows nt 2000 server with oracle 8i on it. It is in production, and i get no errors from my clients. But....every...

Rogier

01-14-2004 06:13 AM
Rogier

Hi, I am using Oracle 9i as database and the frontend application in PowerBuilder 8 which will be installed in English or French Version per user...

Nimmi

01-13-2004 11:46 PM
Nimmi

I am trying to establish a database link to a MS SQL server on an Oracle database. I am almost there, but there is one file missing: the...

Eric de Redelijkheid

01-13-2004 05:42 PM
Ted Thibodeau Jr

We have an application that loads millions of records into a table. Around 10 fields in this record are date fields. We perform the insert using...

Yash

01-13-2004 08:25 AM
Yash

Hi, what's the effect of primary key field size on performance, as a rule of thumb? Let's say that NUMBER(10) would probably be suffient size for a...

janne

01-13-2004 03:05 AM
Paul Busse

Hi All, A huge thanks in advance to anybody who can tackle this question. I am trying to implement online backups on my Oracle 9.2 Server. When...

Rick

01-12-2004 08:25 AM
CFoot

A deinstall of Oracle 9i on a Windows 200 Server did not deinstall the OracleServiceSIDNAME. When I reinstalled I changed the SID name so now I have...

Newbie1

01-12-2004 08:13 AM
CFoot

Good day, I am a Coop student in software engineering and I have to develop 2 WEB applications that will have to get data or consult some...

Jiador

01-09-2004 01:03 PM
Jiador

HELLO, I AM VERY MUCH HAPPY WITH THE CREATORS OF A SITE LIKE GOOGLE.A PERFECT SEARCH ENGINE WITH SPECIFICATION IN ALL THE FIELD.I CAN...

Cherrish Vaidiyan

01-08-2004 06:42 PM
Joel Garry

Hi, I try to write little tool to manage my database. A reporting utility to compare two schemas. Can anyone say me how and where I can find...

quarkx

01-08-2004 10:16 AM
quarkx

Hi, I have downloaded & installed Oracle9R2(english) on German Windows XP. I have documentation in english,but i am getting...

dilbir

01-05-2004 04:42 PM
dilbir

Hi, In sqlplus, type the following before you select the long field from the table: set long <number>; ie: set long 3000 This value will modify...

Beth

01-05-2004 03:25 PM
Beth

I am trying to add a logging facility to an application I am working on which will keep the history of blobs. The problem is that I want to throw an...

Neil

01-05-2004 12:10 PM
Neil

I HAVE 10 Years EXPERIENCE WITH *ORACLE 7.x 8.x, and 9x DATABASE Administration *ORACLE 9iAS Support *11i/10.7 ERP/CRM Installation and...

8i DBA

01-04-2004 10:05 AM
8i DBA

Frank van Bortel <fvanbortel (AT) netscape (DOT) net> wrote Sir, I request ur pardon for my words & query typed in uppercase. I have copied the...

Cherrish Vaidiyan

01-03-2004 01:23 AM
Hans Forbrich

Hi, All: Can anyone point me in the right direction to find an example of source code examples that use the OC4J JAAS Provider API? I am new to...

John Curley

01-02-2004 08:09 PM
John Curley

This is one of my older post which went unanswered. As I also didn't get the answer for this problem, I am posting it again...

qazmlp

01-02-2004 12:18 PM
John Smith

Sir, A Warm and Smart 2004 greetings to all. I have a problem with standby database.I have been posting queries but no response ..... I am using 2...

Cherrish Vaidiyan

01-02-2004 08:39 AM
sybrandb@yahoo.com

Sir, I have implemented asynchronous replication on 2 database located in 2 different system. I did it with Replication Management GUI Tool. Before...

Cherrish Vaidiyan

01-02-2004 05:27 AM
Cherrish Vaidiyan

Hello Great minds, I have setup a Master Site and a Master Group.I created it with GUI tool. Here is my doubts.. Kindly could you provide me with...

Cherrish Vaidiyan

01-02-2004 04:06 AM
Frank van Bortel

when I...

none_ya

01-02-2004 03:40 AM
none_ya

Hi, We are migrating our systems from aix4.3.3 to solaris8. During migration we noticed that the sqlplus queries take a lot longer with the Solaris...

computer person

01-01-2004 10:37 PM
computer person

Gurus, Are there guidelines to determine the necessary size to allocate to a disk device that contains my log archive? My Unix sysadmin got the...

Al

01-01-2004 04:02 PM
Paul Drake

Vax to Alpha Migration Rally VAX to Alpha Migration Current VAX VMS 7.3 RDB 7.0.7 Rally 7.0.3.2 Future Alpha ES47 VMS 7.3 RDB 7.0.7 Rally...

David White

12-31-2003 01:36 PM
David White

Dear Hi: Hope to see u in good health. I was surfing Internet for some Oracle resources, and I found that you are a Guru in Oracle, so here Iam...

Azhar Bilgrami

12-31-2003 04:41 AM
Azhar Bilgrami

Hi, I have downloaded both CPAN-moduls DBD-Oracle-1.14.tar and DBI-1.39.tar. But I fail in installing these moduls! The Perl Package Manager...

Axel Dachtler

12-29-2003 10:51 AM
Axel Dachtler

I want to monitor any suspicious financial transaction which take place in a bank through electronic transfer. There are three tables Customers,...

Sam

12-28-2003 06:40 PM
Erland Sommarskog

I`m beginer user data base Oracle`s, so I have simple question: What`s a thirst user name end password admin`s? :-) SemaFor

SemaFor

12-27-2003 12:59 PM
SemaFor

sir, The following are the steps that i followed in setting up standby database on Red hat Linux 9. i am using Oracle 9i. i have followed the steps...

Cherrish Vaidiyan

12-27-2003 06:46 AM
Cherrish Vaidiyan

hello, Thanx for the suggestions on my Listener query. Now i am performing a simple work.. STANDBY DATABASE creation. I have followed the...

Cherrish Vaidiyan

12-27-2003 01:53 AM
Cherrish Vaidiyan

sir, I have a small error in Listener configuration.I have two system with a database in each. I am using Red Hat 9 and Oracle 9i. so i shall anme...

Cherrish Vaidiyan

12-26-2003 07:09 PM
Ana C. Dent

hello, I'm searching for a list of oracle certified persons in my region or in all the world Does this list exist, and where can i find this...

fatah

12-26-2003 08:15 AM
fatah

Hello all, A warm Xmas greetings to all. I have a small problem with starting up the database. Here my strategy. I have installed Oracle 9i R 2 on...

Cherrish Vaidiyan

12-25-2003 10:47 PM
Cherrish Vaidiyan

Dear reader, My software supplier does not allow me to create an index on "their" tables. Their point is that it can have a bad influence on the...

Freek

12-25-2003 07:21 PM
David Sanchez

Is there a way to do backups of data, control files and logs without bringing the engine offline? Starting with what version of Oracle? Is the backup...

C. Geier

12-25-2003 07:02 PM
David Sanchez

Hi- I come from a SQL Server background and am just starting to use Oracle. We are changing the names of data within a table and want to copy data...

Andy

12-25-2003 06:51 PM
David Sanchez

Hi all, I have no MetaLink login available to me, but need to get 9i running on RedHat Enterprise 3 - does anyone know how to do this without the...

! Chris

12-25-2003 07:27 AM
mikem